Database
db={_id65bba37ff520a4734855ba99headerObjectid"1d427422-76d0-4e69-a583-a17f6e6cd5e8"testfalseprepared"2024-02-01T13:58:22.7789193Z"senderObjectid"OECD"name"OrganisationforEconomicCo-operationandDevelopment"linksArray(1)0Objecthref"https://stats.oecd.org:443/SDMX-JSON/data/KEI/LOLITOAA.USA.ST.M/all?st…"rel"request"dataSetsArray(1)0Objectaction"Information"seriesObject0:0:0:0ObjectattributesArray(4)0010203nullobservationsObject0Array(2)099.60647364900811null1Array(2)099.68079519269831null2Array(2)099.77785397926791null3Array(2)099.90017396493841null4Array(2)0100.042508292581null5Array(2)0100.187878673031null6Array(2)0100.3099475983441null7Array(2)0100.4241609401271null8Array(2)0100.5372263581031null9Array(2)0100.6265048830321null10Array(2)0100.6804940463411null11Array(2)0100.7122375390531null12Array(2)0100.7251610601341null13Array(2)0100.7289687763381null14Array(2)0100.7327256765461null15Array(2)0100.72558098131null16Array(2)0100.7135637662441null17Array(2)0100.7306367056581null18Array(2)0100.7770931102551null19Array(2)0100.8348444115251null20Array(2)0100.8856947885691null21Array(2)0100.9231785754851null22Array(2)0100.9423729675611null23Array(2)0100.9458940867891null24Array(2)0100.935045245411null25Array(2)0100.9062566878711null26Array(2)0100.8598193822921null27Array(2)0100.7902516379111null28Array(2)0100.698742618411null29Array(2)0100.5920222191411null30Array(2)0100.4804468086231null31Array(2)0100.3693014456921null32Array(2)0100.2518293619381null33Array(2)0100.1238948455941null34Array(2)099.96415655952621null35Array(2)099.78479949241511null36Array(2)099.61191191478431null37Array(2)099.46945277939371null38Array(2)099.34965948449881null39Array(2)099.2453251917461null40Array(2)099.16032288772161null41Array(2)099.10200926310521null42Array(2)099.08046183380971null43Array(2)099.07786827715681null44Array(2)099.07807997508371null45Array(2)099.07480825410021null46Array(2)099.08647076389131null47Array(2)099.12658724823521null48Array(2)099.20973852258451null49Array(2)099.33318029494391null50Array(2)099.48416324347631null51Array(2)099.64018699926771null52Array(2)099.76718655944251null53Array(2)099.85140458918661null54Array(2)099.89231099061761null55Array(2)099.90620780056431null56Array(2)099.91375847435491null57Array(2)099.92985946413411null58Array(2)099.96129024996091null59Array(2)0100.0335683099081null60Array(2)0100.1374325963011null61Array(2)0100.2607136814291null62Array(2)0100.3859368768611null63Array(2)0100.5099224690091null64Array(2)0100.6324380051391null65Array(2)0100.7444936965681null66Array(2)0100.8175903236631null67Array(2)0100.8433489096581null68Array(2)0100.8313164125431null69Array(2)0100.7883541526571null70Array(2)0100.7166172949191null71Array(2)0100.618900579191null72Array(2)0100.4800032516871null73Array(2)0100.2942174995511null74Array(2)0100.0778781632841null75Array(2)099.85411127355951null76Array(2)099.64574414132731null77Array(2)099.47106139687471null78Array(2)099.33182593798961null79Array(2)099.2058179188891null80Array(2)099.0891239276431null81Array(2)098.98215986859831null82Array(2)098.89260481305881null83Array(2)098.83254168502511null84Array(2)098.8311845673621null85Array(2)098.88565412619241null86Array(2)098.97026614626261null87Array(2)099.05199687265271null88Array(2)099.09212900085651null89Array(2)099.06018772240811null90Array(2)097.66242822480131null91Array(2)092.63270169095111null92Array(2)094.3320711078621null93Array(2)096.16554258525041null94Array(2)097.71690696054731null95Array(2)098.43650325501241null96Array(2)098.72673413722451null97Array(2)099.08487455201141null98Array(2)099.47994874615721null99Array(2)099.89778179074641null100Array(2)0100.2739365862561null101Array(2)0100.6504240299041null102Array(2)0100.9795899871011null103Array(2)0101.2542936890911null104Array(2)0101.3349211043141null105Array(2)0101.3417730572161null106Array(2)0101.2912391704951null107Array(2)0101.2171439214121null108Array(2)0101.1544034065251null109Array(2)0101.1084111359641null110Array(2)0101.0706652598161null111Array(2)0101.021001840441null112Array(2)0100.9392477749391null113Array(2)0100.8172432768271null114Array(2)0100.6399931682391null115Array(2)0100.4064563267421null116Array(2)0100.1205123916821null117Array(2)099.82374801062491null118Array(2)099.56422763294291null119Array(2)099.35707095000141null120Array(2)099.18692251677811null121Array(2)099.04436405539691null122Array(2)098.93193852253711null123Array(2)098.86257938077281null124Array(2)098.83160918079341null125Array(2)098.82182610172221null126Array(2)098.83694941172741null127Array(2)098.89503120418631null128Array(2)098.99475126122721null129Array(2)099.12665964308481null130Array(2)099.25702116031711null131Array(2)099.36600287576631null132Array(2)099.4489088275211null133Array(2)099.51644000542681null134Array(2)099.59901592231821null135Array(2)099.70095715417781nullstructureObjectlinksArray(1)0Objecthref"https://stats.oecd.org/SDMX-JSON/dataflow/KEI/all"rel"dataflow"name"KeyShort-TermEconomicIndicators"description"KeyShort-TermEconomicIndicators"dimensionsObjectseriesArray(4)0ObjectkeyPosition0id"SUBJECT"name"Subject"valuesArray(1)0Objectid"LOLITOAA"name"Leadingindicator,amplitudeadjusted"1ObjectkeyPosition1id"LOCATION"name"Country"valuesArray(1)0Objectid"USA"name"UnitedStates"role"REF_AREA"2ObjectkeyPosition2id"MEASURE"name"Measure"valuesArray(1)0Objectid"ST"name"Level,ratioorindex"3ObjectkeyPosition3id"FREQUENCY"name"Frequency"valuesArray(1)0Objectid"M"name"Monthly"role"FREQ"observationArray(1)0Objectid"TIME_PERIOD"name"Time"valuesArray(136)0Objectid"2012-09"name"Sep-2012"1Objectid"2012-10"name"Oct-2012"2Objectid"2012-11"name"Nov-2012"3Objectid"2012-12"name"Dec-2012"4Objectid"2013-01"name"Jan-2013"5Objectid"2013-02"name"Feb-2013"6Objectid"2013-03"name"Mar-2013"7Objectid"2013-04"name"Apr-2013"8Objectid"2013-05"name"May-2013"9Objectid"2013-06"name"Jun-2013"10Objectid"2013-07"name"Jul-2013"11Objectid"2013-08"name"Aug-2013"12Objectid"2013-09"name"Sep-2013"13Objectid"2013-10"name"Oct-2013"14Objectid"2013-11"name"Nov-2013"15Objectid"2013-12"name"Dec-2013"16Objectid"2014-01"name"Jan-2014"17Objectid"2014-02"name"Feb-2014"18Objectid"2014-03"name"Mar-2014"19Objectid"2014-04"name"Apr-2014"20Objectid"2014-05"name"May-2014"21Objectid"2014-06"name"Jun-2014"22Objectid"2014-07"name"Jul-2014"23Objectid"2014-08"name"Aug-2014"24Objectid"2014-09"name"Sep-2014"25Objectid"2014-10"name"Oct-2014"26Objectid"2014-11"name"Nov-2014"27Objectid"2014-12"name"Dec-2014"28Objectid"2015-01"name"Jan-2015"29Objectid"2015-02"name"Feb-2015"30Objectid"2015-03"name"Mar-2015"31Objectid"2015-04"name"Apr-2015"32Objectid"2015-05"name"May-2015"33Objectid"2015-06"name"Jun-2015"34Objectid"2015-07"name"Jul-2015"35Objectid"2015-08"name"Aug-2015"36Objectid"2015-09"name"Sep-2015"37Objectid"2015-10"name"Oct-2015"38Objectid"2015-11"name"Nov-2015"39Objectid"2015-12"name"Dec-2015"40Objectid"2016-01"name"Jan-2016"41Objectid"2016-02"name"Feb-2016"42Objectid"2016-03"name"Mar-2016"43Objectid"2016-04"name"Apr-2016"44Objectid"2016-05"name"May-2016"45Objectid"2016-06"name"Jun-2016"46Objectid"2016-07"name"Jul-2016"47Objectid"2016-08"name"Aug-2016"48Objectid"2016-09"name"Sep-2016"49Objectid"2016-10"name"Oct-2016"50Objectid"2016-11"name"Nov-2016"51Objectid"2016-12"name"Dec-2016"52Objectid"2017-01"name"Jan-2017"53Objectid"2017-02"name"Feb-2017"54Objectid"2017-03"name"Mar-2017"55Objectid"2017-04"name"Apr-2017"56Objectid"2017-05"name"May-2017"57Objectid"2017-06"name"Jun-2017"58Objectid"2017-07"name"Jul-2017"59Objectid"2017-08"name"Aug-2017"60Objectid"2017-09"name"Sep-2017"61Objectid"2017-10"name"Oct-2017"62Objectid"2017-11"name"Nov-2017"63Objectid"2017-12"name"Dec-2017"64Objectid"2018-01"name"Jan-2018"65Objectid"2018-02"name"Feb-2018"66Objectid"2018-03"name"Mar-2018"67Objectid"2018-04"name"Apr-2018"68Objectid"2018-05"name"May-2018"69Objectid"2018-06"name"Jun-2018"70Objectid"2018-07"name"Jul-2018"71Objectid"2018-08"name"Aug-2018"72Objectid"2018-09"name"Sep-2018"73Objectid"2018-10"name"Oct-2018"74Objectid"2018-11"name"Nov-2018"75Objectid"2018-12"name"Dec-2018"76Objectid"2019-01"name"Jan-2019"77Objectid"2019-02"name"Feb-2019"78Objectid"2019-03"name"Mar-2019"79Objectid"2019-04"name"Apr-2019"80Objectid"2019-05"name"May-2019"81Objectid"2019-06"name"Jun-2019"82Objectid"2019-07"name"Jul-2019"83Objectid"2019-08"name"Aug-2019"84Objectid"2019-09"name"Sep-2019"85Objectid"2019-10"name"Oct-2019"86Objectid"2019-11"name"Nov-2019"87Objectid"2019-12"name"Dec-2019"88Objectid"2020-01"name"Jan-2020"89Objectid"2020-02"name"Feb-2020"90Objectid"2020-03"name"Mar-2020"91Objectid"2020-04"name"Apr-2020"92Objectid"2020-05"name"May-2020"93Objectid"2020-06"name"Jun-2020"94Objectid"2020-07"name"Jul-2020"95Objectid"2020-08"name"Aug-2020"96Objectid"2020-09"name"Sep-2020"97Objectid"2020-10"name"Oct-2020"98Objectid"2020-11"name"Nov-2020"99Objectid"2020-12"name"Dec-2020"100Objectid"2021-01"name"Jan-2021"101Objectid"2021-02"name"Feb-2021"102Objectid"2021-03"name"Mar-2021"103Objectid"2021-04"name"Apr-2021"104Objectid"2021-05"name"May-2021"105Objectid"2021-06"name"Jun-2021"106Objectid"2021-07"name"Jul-2021"107Objectid"2021-08"name"Aug-2021"108Objectid"2021-09"name"Sep-2021"109Objectid"2021-10"name"Oct-2021"110Objectid"2021-11"name"Nov-2021"111Objectid"2021-12"name"Dec-2021"112Objectid"2022-01"name"Jan-2022"113Objectid"2022-02"name"Feb-2022"114Objectid"2022-03"name"Mar-2022"115Objectid"2022-04"name"Apr-2022"116Objectid"2022-05"name"May-2022"117Objectid"2022-06"name"Jun-2022"118Objectid"2022-07"name"Jul-2022"119Objectid"2022-08"name"Aug-2022"120Objectid"2022-09"name"Sep-2022"121Objectid"2022-10"name"Oct-2022"122Objectid"2022-11"name"Nov-2022"123Objectid"2022-12"name"Dec-2022"124Objectid"2023-01"name"Jan-2023"125Objectid"2023-02"name"Feb-2023"126Objectid"2023-03"name"Mar-2023"127Objectid"2023-04"name"Apr-2023"128Objectid"2023-05"name"May-2023"129Objectid"2023-06"name"Jun-2023"130Objectid"2023-07"name"Jul-2023"131Objectid"2023-08"name"Aug-2023"132Objectid"2023-09"name"Sep-2023"133Objectid"2023-10"name"Oct-2023"134Objectid"2023-11"name"Nov-2023"135Objectid"2023-12"name"Dec-2023"role"TIME_PERIOD"attributesObjectdataSetArray(empty)seriesArray(4)0Objectid"TIME_FORMAT"name"TimeFormat"valuesArray(1)0Objectid"P1M"name"Monthly"1Objectid"UNIT"name"Unit"valuesArray(1)0Objectid"IDX"name"Index"role"UNIT_MEASURE"2Objectid"POWERCODE"name"Unitmultiplier"default"0"valuesArray(1)0Objectid"0"name"Units"role"UNIT_MULT"3Objectid"REFERENCEPERIOD"name"Referenceperiod"valuesArray(empty)role"BASE_PER"observationArray(1)0Objectid"OBS_STATUS"name"ObservationStatus"valuesArray(empty)annotationsArray(5)0Objecttitle"CopyrightOECD-Allrightsreserved"uri""text""1Objecttitle"TermsandConditions"uri"http://www.oecd.org/termsandconditions/"text""2Objecttitle"PrivacyPolicy"uri"http://www.oecd.org/privacy/"text""3Objecttitle"MyOECD"uri"https://www.oecd.org/login"text""4Objecttitle"ContactUs"uri"http://www.oecd.org/contact/"text""]}
Query
db.orders.aggregate([{"$lookup":{"from":"inventory","localField":"item","foreignField":"sku","as":"inventory_docs"}}])