Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/censusreporter/census-api

The home for the API that powers the Census Reporter project.
https://github.com/censusreporter/census-api

Split the columns in the result by table requested.

15c95b2f8625e76c47daf99a5bffe76f6873834f authored about 11 years ago by Ian Dees <[email protected]>
Protect against unknown table and geo IDs.

2b850d31de1113c32d4832daaa816f480081ea0c authored about 11 years ago by Ian Dees <[email protected]>
Add a show data endpoint.

94871207dcefeeebd7a091480c0be6eb23651946 authored about 11 years ago by Ian Dees <[email protected]>
Removeing stale code.

7cb8430eb56c70307aeb0eb8039d3f3dfef14771 authored about 11 years ago by Ian Dees <[email protected]>
Fix the child geo names.

f3f215af1f2c3b04a3e9181b805b86ec61763eec authored about 11 years ago by Ian Dees <[email protected]>
Only add child geographies to the comparison if they have data.

002a72eeec7da6c3a027c0096b87ae5b48f7c8f2 authored about 11 years ago by Ian Dees <[email protected]>
Add a healthcheck for use in a potential ELB.

9b0dff0d1d809e04c55864ce207190ea5445ff92 authored about 11 years ago by Ian Dees <[email protected]>
Add MOE to the comparison API response.

eaef95a56cc40dab05d70e59d00e3c17e5045d0b authored about 11 years ago by Ian Dees <[email protected]>
Add a separate error dict for each geo in the comparison response.

a52063e4e59137ea95d286cc52f58e3250a3c0f1 authored about 11 years ago by Ian Dees <[email protected]>
Trim off extra decimals in the ST_AsGeoJSON calls.

b338f07c45a1f03954d2aa7914da1cd09ca18433 authored about 11 years ago by Ian Dees <[email protected]>
identify age range for fertility universe

82cfcd0ac1d57c0f5b4deee83d02b2b2dfd0af79 authored about 11 years ago by Ryan Pitts <[email protected]>
change birth rate to fertility, because survey doesn't ask number of births

f4020468d994246f4fc533e77a746c4fce7bcaad authored about 11 years ago by Ryan Pitts <[email protected]>
profile response objects package metadata into its own dict

ae16c9627671d2a667087a2ae3520d08bb70d1cb authored about 11 years ago by Ryan Pitts <[email protected]>
More consistent rounding for RPN answers.

78e1fa3a90604c18293b66b7a399b8f5ff0f139c authored about 11 years ago by Ian Dees <[email protected]>
Handle small geographies/small populations better.

0ef6aa0045fab922fc1df0b8f5a813a9537df912 authored about 11 years ago by Ian Dees <[email protected]>
Add numerator, fix last two MOE calcs, remove cruft.

5da87f550a0841ce70d295df83d79eb26079aa0a authored about 11 years ago by Ian Dees <[email protected]>
Make the tiger2012 endpoint return geojson always.

bbb1c4aaaa4810f334c791be7033e3fbc62c57ae authored about 11 years ago by Ian Dees <[email protected]>
fix birth rate category to 45-50

055d6a032054c5c2963c0cc2204ced3fcac5c28d authored about 11 years ago by Ryan Pitts <[email protected]>
Fix the column names in a couple of the RPN lines.

de029d76d5bdb50dd8be6d3f47e516efa6678193 authored about 11 years ago by Ian Dees <[email protected]>
Fixing the poverty RPN strings.

f3048c1855de6f9533b1be2c4dd7c0ee20f522de authored about 11 years ago by Ian Dees <[email protected]>
Switch to using a RPN string to compute profile MOE and estimate.

ae95804de112afaa3dd4b1085108f3411eefb08b authored about 11 years ago by Ian Dees <[email protected]>
Add 2012 3yr data to the API.

63d45dfe80e6442cc2251ac5b8ad53474ef90425 authored about 11 years ago by Ian Dees <[email protected]>
move acs release info for grouped data

3b0c4c84e4586e3147fca2df61bd689199a1d2cf authored about 11 years ago by Ryan Pitts <[email protected]>
Stick the comparative geo metadata in the geography section of the API.

c97716ff28b9e36e61e00fb4e9fa72578bcb2c2d authored about 11 years ago by Ian Dees <[email protected]>
clean up marital status response

9e923187e75069c3b2ba7920fa011e8e0af2d240 authored about 11 years ago by Ryan Pitts <[email protected]>
add test data structure to profile for grouped column chart

206f52a95f4c5040cc5c22f12333dfd615138fcb authored about 11 years ago by Ryan Pitts <[email protected]>
Check for set value of none, not just if geo is there.

3c8b97a8787ce4982aa639e6270317282b892938 authored about 11 years ago by Ian Dees <[email protected]>
Only add the nation comparison if we're not comparing against the nation already.

30d00075589b757d3631252bd22953008108feee authored about 11 years ago by Ian Dees <[email protected]>
More broadly replace json with simplejson.

aba58ee7a1b67eafce7742608f4a3e4b72712c94 authored about 11 years ago by Ian Dees <[email protected]>
Add display and simple name to the profile response.

8ddae31891dd524bedc6f4582d6acb8d07b979e0 authored about 11 years ago by Ian Dees <[email protected]>
Don't add two sums together because it breaks nullchecks.

135a6a7eeb98efb490632f9fcbe9ceb3b7814d08 authored about 11 years ago by Ian Dees <[email protected]>
Account for multiple rows w/ same geoid.

7856fc247c78f1f3766f4e750bd8954e48fff78a authored about 11 years ago by Ian Dees <[email protected]>
Sort by population.

5f3bfd6500be346822b0dd3d03687c8df26043cc authored about 11 years ago by Ian Dees <[email protected]>
Add more data to profile response.

34e0ff6f9df5abdd3c4951befa845a4f2f9a7015 authored about 11 years ago by Ian Dees <[email protected]>
Fix the geo search by referencing the lookup table built last night.

2e78372d73accecc1b84de71089c4adc3575d873 authored about 11 years ago by Ian Dees <[email protected]>
A quick fix for geo search prefix match.

1d5a2888a48a76c9bd605d11412f58364748d578 authored about 11 years ago by Ian Dees <[email protected]>
Use jsonify and return results in an object instead of array.

fbd1d57b78d4d7bedf496d7b578f3df72a45899a authored about 11 years ago by Ian Dees <[email protected]>
Switch back to using prefix match for search. Strip out parts of search response.

2c8eb6dbd658faf4ebbfc4ed57f0870bfe00a2ff authored about 11 years ago by Ian Dees <[email protected]>
Don't log the validation errors.

2d491c57a9f9ce11be22fe56975dd242b7ddfbd1 authored about 11 years ago by Ian Dees <[email protected]>
Revert "No need to re-calculate child GEOIDs for each ACS."

This reverts commit 99be1f9d42067c1eb47612e2646e2319ee3e2292.

5f0d9b62d6da79ce477379da29ccfec5302637ce authored about 11 years ago by Ian Dees <[email protected]>
No need to re-calculate child GEOIDs for each ACS.

99be1f9d42067c1eb47612e2646e2319ee3e2292 authored about 11 years ago by Ian Dees <[email protected]>
Fallback to older releases should work better now.

79be68f9d9bead29c466d25db5625ab52accc48f authored about 11 years ago by Ian Dees <[email protected]>
Rejigger the profile stuff to support querying for multiple geoid.

faa0615f99138e3804bdd657c92de046f37039a6 authored about 11 years ago by Ian Dees <[email protected]>
Move all profile data manipulation to the lambda.

This is so that when we add parent geom data to the mix the same calculations can be performed o...

e9cf1a7b6f5262302dc0c1c86057bc99bcad906b authored about 11 years ago by Ian Dees <[email protected]>
Allow child_geoids gis queries to return no results.

aa4ae574644974f0d1f0adf662bc51d68b6a7913 authored about 11 years ago by Ian Dees <[email protected]>
Try to keep the order of the data from the database instead of inverting it.

9fb14486dcb8628105b40c2f4fa3fa7170129c86 authored over 11 years ago by Ian Dees <[email protected]>
Let the view specify sort order for census_names.

e7bc056f445863cbee508244ce7ede939fa8856a authored over 11 years ago by Ian Dees <[email protected]>
Use the full text search column for geo search.

63991630abe6e07992900baf73bd32372d2936d8 authored over 11 years ago by Ian Dees <[email protected]>
allow rowcounts endpoint to take multiple years

1d622753dbc8726760ec9d0600162efe467812d8 authored over 11 years ago by Ryan Pitts <[email protected]>
add get_data_fallback method for when requested release doesn't have data for geography

18910aa3e6ee94dda06b387dee6c9fdf4d51cfff authored over 11 years ago by Ryan Pitts <[email protected]>
add space around some hyphens for label breaks

5051261670e02cd02272e0d56cd6a963235beb3f authored over 11 years ago by Ryan Pitts <[email protected]>
Missed a couple spots where child_geoids wasn't used.

6a2b1a8b41a726b3f42dc100e228274bc13c1ebc authored over 11 years ago by Ian Dees <[email protected]>
Pop the geoid off the results from the database data views.

cdc6197f02a226f995a364bb61a702c558c9746b authored over 11 years ago by Ian Dees <[email protected]>
Sequence number is not needed for table metadata now.

b573536f17fdfb9a5f98ab38dad72609e86956a0 authored over 11 years ago by Ian Dees <[email protected]>
Switch to using geoid instead of stusab,logrecno.

1529d9becb4239f48b83f7c579a1ab56c055956a authored over 11 years ago by Ian Dees <[email protected]>
Add acs2012 1yr to the api.py stuff.

75073ffad3d79af63d57aa1ce6b0c757b2cd7859 authored over 11 years ago by Ian Dees <[email protected]>
oops naming conflict

e09823353356eb566368a3d5235178e6e4004035 authored over 11 years ago by Ryan Pitts <[email protected]>
calculate birth rate in standard per 1000 fashion

10237c2eeae33e6b39a4a2d41e5d8a71b64ffe62 authored over 11 years ago by Ryan Pitts <[email protected]>
add birth rate by age

7be469dc580ba0e593df207ab4899031e06e4687 authored over 11 years ago by Ryan Pitts <[email protected]>
add family types with children

7d26041f0fcb1da84b19fb72e34ae7660cac3329 authored over 11 years ago by Ryan Pitts <[email protected]>
add marital status by sex

ab7eeab0e91700e4f7ebf13eae1ff96bd378daed authored over 11 years ago by Ryan Pitts <[email protected]>
add place of birth distribution data

c678955540db186b4a488085017a2134ef4ca29d authored over 11 years ago by Ryan Pitts <[email protected]>
swap order of veteran service data

44c3c6deebc82fab74e3bf87619ed37dba0fec8d authored over 11 years ago by Ryan Pitts <[email protected]>
shorter war names

266b66f620861282abf45ebae7425e5163904386 authored over 11 years ago by Ryan Pitts <[email protected]>
tweak veteran category names

42c5f7283b47268de22a69e39744322f348ae149 authored over 11 years ago by Ryan Pitts <[email protected]>
add veteran service, veterans by sex

b6ba3ee5c3546e3210df743d60efbcc060aa5b27 authored over 11 years ago by Ryan Pitts <[email protected]>
derp wrong column

16921977e0acf21c98f53f10e00c968dda2191a5 authored over 11 years ago by Ryan Pitts <[email protected]>
add language at home for children vs. adults

dd34e8b4b9c0473e5f4f78481667583da452cd82 authored over 11 years ago by Ryan Pitts <[email protected]>
add means of transport to work

c2812c15f3876980320d7b26caec7bda47f46b8a authored over 11 years ago by Ryan Pitts <[email protected]>
add structure distribution, remove vacancy distribution

d87b49f526c09ab1a90d3cad071e7413cb77d16f authored over 11 years ago by Ryan Pitts <[email protected]>
add length of tenure

925dd09fec81c40f20cf505ab86a105dc1949b7f authored over 11 years ago by Ryan Pitts <[email protected]>
add aggregate migration figure

ca07068213f866b72cef9f25eeca33b1a77393eb authored over 11 years ago by Ryan Pitts <[email protected]>
add housing vacancy distribution

cf2fac015e836bce89e03bf1e1f300e76edc0178 authored over 11 years ago by Ryan Pitts <[email protected]>
add occupancy distribution

919446839825fbf2b32775ac5f69f88f6ab29366 authored over 11 years ago by Ryan Pitts <[email protected]>
add ownership distribution, migration distribution

28fb2cd9b648f5b9d052444ad1b25a462a4c9924 authored over 11 years ago by Ryan Pitts <[email protected]>
oops, need to build that total value item

06809d1b2135a75da982922a67131c8ce9d5fec0 authored over 11 years ago by Ryan Pitts <[email protected]>
add distribution of home values

423f093245edb9c311809a072e21f014d88f5d3d authored over 11 years ago by Ryan Pitts <[email protected]>
shorter labels for education chart

a88de4132c4200dc2e59e9341c77d3157c322ca3 authored over 11 years ago by Ryan Pitts <[email protected]>
add population by household type

3137e90fad22d526bfa001a96218158585dd30cf authored over 11 years ago by Ryan Pitts <[email protected]>
combine "some college" and "associate degree"

be3ba3018be2e241df7c6c09fc0c6bd8cc1087fb authored over 11 years ago by Ryan Pitts <[email protected]>
oops, consistent names

e93409802b8d5736f493824f76815a18a193ba16 authored over 11 years ago by Ryan Pitts <[email protected]>
add educational attainment distribution dict

3c43505c7334b32b7797d3e2d91b5e404ca65d97 authored over 11 years ago by Ryan Pitts <[email protected]>
tweak income labels

d9f46899f9ea6f34a911e008f907f4d77a880fa9 authored over 11 years ago by Ryan Pitts <[email protected]>
add household income distribution

6c3ddfdaed31c58ce554ee3d3519cb9d5400d9a0 authored over 11 years ago by Ryan Pitts <[email protected]>
shorter category titles in poverty dict

fed21c3e2ff3bdc63f3e7b7234904a84e3b65e55 authored over 11 years ago by Ryan Pitts <[email protected]>
fix the math on total children, seniors

823652f9556d7d983b4d9f102b69447c11b42ae8 authored over 11 years ago by Ryan Pitts <[email protected]>
fix poverty dict

a212749ff60bdbd8f9008ac0a9f9b685458deb15 authored over 11 years ago by Ryan Pitts <[email protected]>
add some more poverty into for viz purposes

1b0b892b48c11f618827ef58f436bb6770bb6109 authored over 11 years ago by Ryan Pitts <[email protected]>
use table B03002 for race data in profile response

ecac49b38e2078ebcd8d7b8d0043a8b703a34ac7 authored over 11 years ago by Ryan Pitts <[email protected]>
percentify age histogram data, add hispanic value to race_dict

64fe714ebfa0f8a52dccc6b079c82e77837effd4 authored over 11 years ago by Ryan Pitts <[email protected]>
profile response provides age histogram data

48da95b98925cc185305c63547c62a6962fa368e authored over 11 years ago by Ryan Pitts <[email protected]>
Remove the percentile from the rank endpoint for now.

e2f3511d1b2fff2fcb832322f55536638c9feb1c authored over 11 years ago by Ian Dees <[email protected]>
Adding cousubs to the sumlev names dict.

0d93d27bf28562eb55363ba22249ff05f7fd2d43 authored over 11 years ago by Ian Dees <[email protected]>
Reduce simplification a bit.

8fd5eeb077348730538697c5b971fe858fdf8dc4 authored over 11 years ago by Ian Dees <[email protected]>
Change readme after rename.

9502dc00a68acf495c41b7495e9220d9828ff074 authored over 11 years ago by Ian Dees <[email protected]>
Add a first pass at a ranking endpoint.

db11132f7f4864d813826be19debb89d9504dcc4 authored over 11 years ago by Ian Dees <[email protected]>
Protect against comparing on a table that doesn't exist.

4615e3468fc8af6627dc65b16fc1b33dd1d3466d authored over 11 years ago by Ian Dees <[email protected]>
Order geo search for compare by name and filter for geocomponent.

7985f045d38937cf75c9cb9d910b08fde4e21e1b authored over 11 years ago by Ian Dees <[email protected]>
Update the api to recognize the topic text[] in the database.

e5d9e3af442b49753146308065f17dfb590a154f authored over 11 years ago by Ian Dees <[email protected]>
Special case the 010 parent sumlevel to grab everything.

389c34fc75c454a3967d773e349a0e40016bc970 authored over 11 years ago by Ian Dees <[email protected]>