Ecosyste.ms: OpenCollective

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

Census Reporter

Make it easier to understand Census data.
Collective - Host: opensource - https://opencollective.com/censusreporter - Website: https://censusreporter.org/ - Code: https://github.com/censusreporter

lol mysterious "titlecase table names" task

github.com/censusreporter/censusreporter - 72c7499a2101ba023480218a0a81453de4f2a087 authored over 11 years ago by Ryan Pitts <[email protected]>
make_table_values_by_geo handles nondata headers and percentify. also, document all the things!

github.com/censusreporter/censusreporter - 7399227106a3bd88a9e603528b4c45ff2c55a75d authored over 11 years ago by Ryan Pitts <[email protected]>
nudge some spacing, tap some margins. the ocd must be appeased

github.com/censusreporter/censusreporter - bac9d79913076835c384465db7f8cd9895fe7f2b authored over 11 years ago by Ryan Pitts <[email protected]>
handle non-data headers and percentify in distribution charts

github.com/censusreporter/censusreporter - b8346bd505a8b0ff0145b519c900a69f876073e8 authored over 11 years ago by Ryan Pitts <[email protected]>
Sort the table search by len(table_id) then alpha.

github.com/censusreporter/census-api - dae6563916dc6781135bb5183a3caaf7682cdd2c authored over 11 years ago by Ian Dees <[email protected]>
Add denominator column ID to the compare API results.

github.com/censusreporter/census-api - dc4249a400579b04bb65cc2bda634d122da1068c authored over 11 years ago by Ian Dees <[email protected]>
compare templates swap to standardized var names

github.com/censusreporter/censusreporter - fa4a5bcfb523dfb1313c687c7173634decc9cc9b authored over 11 years ago by Ryan Pitts <[email protected]>
rock out with non-percentified distribution charts and standardized var names

github.com/censusreporter/censusreporter - f119cc2d2b8a9654f1ed652dec02f4d876ab7e44 authored over 11 years ago by Ryan Pitts <[email protected]>
refactor methods that shape api data for our compare viz pages, add clean table method

github.com/censusreporter/censusreporter - 9a38b95a32c32417df7e298c529096b504c6fc45 authored over 11 years ago by Ryan Pitts <[email protected]>
set release data apart

github.com/censusreporter/censusreporter - 769389cc2db8082cdc6a1c8afff31be21a22dfa5 authored over 11 years ago by Ryan Pitts <[email protected]>
Add simple table name to the table search API.

github.com/censusreporter/census-api - 716bd240b1cbcd2222a015bbf8ba4381b9c3f8c6 authored over 11 years ago by Ian Dees <[email protected]>
Build the autocomplete URL differently.

github.com/censusreporter/censusreporter - 33d759456f7de6bd00875c3a008d8d2f5015df52 authored over 11 years ago by Ian Dees <[email protected]>
Trim trailing whitespace.

github.com/censusreporter/censusreporter - 0b7170f3af7553d15e82e7297be9ce3f3c5245b4 authored over 11 years ago by Ian Dees <[email protected]>
Join the column and table metadata based on the new schema.

github.com/censusreporter/census-api - 7bb3fe22329b6e9bab7ad080ca7f5e38acb9d439 authored over 11 years ago by Ian Dees <[email protected]>
Add topics to the table/column search results.

github.com/censusreporter/census-api - de8e8bcb579f54800e852e76ae07635e27dc4c1b authored over 11 years ago by Ian Dees <[email protected]>
Commit the new precomputed stuff after switching to slug IDs for topics.

github.com/censusreporter/census-table-metadata - 5497850c82d444c676f16296c62244553b3c01db authored over 11 years ago by Ian Dees <[email protected]>
Ditch topic_ids and let the topic slug be the ID.

github.com/censusreporter/census-table-metadata - e6a0713a9f753bfbea8d6cc452f5a8c4fc530c9f authored over 11 years ago by Ian Dees <[email protected]>
Add a clean step for the makefile.

github.com/censusreporter/census-table-metadata - fca5e347ffec9c36e1b8d3905df2ff8ce1c8fba9 authored over 11 years ago by Ian Dees <[email protected]>
Add text pattern indexes for the table and column names.

github.com/censusreporter/census-table-metadata - 6e2581aeeaa46bcaea056250e1a2d7a9d52c9e71 authored over 11 years ago by Ian Dees <[email protected]>
Add details about how to get the data into the database.

github.com/censusreporter/census-table-metadata - 3fe7bb7c94db424b197e951bb39f4f6b51ed213a authored over 11 years ago by Ian Dees <[email protected]>
Add sequence number to the column_id index.

There can be multiple of the same column_id.

github.com/censusreporter/census-table-metadata - 8c9b8ef5ddfccf915d256a28108a287b976e0d0a authored over 11 years ago by Ian Dees <[email protected]>
Add a non-unique index to the table_topics table.

github.com/censusreporter/census-table-metadata - 7edaeda9f490fd1408f90f939b80d6098d1b2399 authored over 11 years ago by Ian Dees <[email protected]>
Ditch the foreign key stuff because we're not adding to these tables.

github.com/censusreporter/census-table-metadata - 76c73959c2b3a5f85fca853d45a8630c4e6c3568 authored over 11 years ago by Ian Dees <[email protected]>
Add cascade to get around foreign key specifications.

github.com/censusreporter/census-table-metadata - a4f1ae219b2514db063d09fa314a8bcdf5511085 authored over 11 years ago by Ian Dees <[email protected]>
Fixing an extraneous character that got in there.

github.com/censusreporter/census-table-metadata - 7e5447e25e5cf723e22d1547e3af5cc3e2e3f64b authored over 11 years ago by Ian Dees <[email protected]>
Add schema references to the foreign keys.

github.com/censusreporter/census-table-metadata - 38a11fdec6aa8ace4c34b4472f7f01bb9e1aa2ed authored over 11 years ago by Ian Dees <[email protected]>
Add a drop script for the metadata tables.

github.com/censusreporter/census-table-metadata - 8516c8ea7c69a820fd05704c4e21635414a58328 authored over 11 years ago by Ian Dees <[email protected]>
Format the example commands consistently.

github.com/censusreporter/census-table-metadata - 77e672cf35d1a89024eaf0cfa7221ebedf15bbc1 authored over 11 years ago by Ian Dees <[email protected]>
Add a sentence about the precomputed data to the README.

github.com/censusreporter/census-table-metadata - f1b0b7ddfd76b933332b27d022dcbe84887b8d34 authored over 11 years ago by Ian Dees <[email protected]>
Commit fixed 2007 precomputed data.

github.com/censusreporter/census-table-metadata - 0a4fa9b46a116ac1c55596a31f69c191459ce612 authored over 11 years ago by Ian Dees <[email protected]>
Fix the Makefile so files download in the right spot.

github.com/censusreporter/census-table-metadata - 7b36c0cf31c6604602f2b9a675f5223ab2c26557 authored over 11 years ago by Ian Dees <[email protected]>
Add new 'built' CSV files.

github.com/censusreporter/census-table-metadata - 5ee0e1f214a85ac05bbf04e6f16c663376ea3226 authored over 11 years ago by Ian Dees <[email protected]>
Move the download steps to a Makefile.

github.com/censusreporter/census-table-metadata - cb43b785eb6aa816e942370814c3056f6322e9e8 authored over 11 years ago by Ian Dees <[email protected]>
Cleaning up older files whose functionality is now subsumed by newer stuff.

github.com/censusreporter/census-table-metadata - f36552229f509f4acaad3b6f2527c92ffba7ee8f authored over 11 years ago by Ian Dees <[email protected]>
Separate out the schema creation and loading steps.

github.com/censusreporter/census-table-metadata - afc9913079e04d6336dab879555ab2e88dda9185 authored over 11 years ago by Ian Dees <[email protected]>
Normalize the census column/table metadata tables.

github.com/censusreporter/census-table-metadata - 8b64e14e428adf656ec6a94e0a4de657400895ee authored over 11 years ago by Ian Dees <[email protected]>
Add dsstore to gitignore.

github.com/censusreporter/census-table-metadata - 74a2bede4ad10920ff7eabddd127e727e306420c authored over 11 years ago by Ian Dees <[email protected]>
handle percentify on map pages

github.com/censusreporter/censusreporter - 27d9c928181e86393f6db09f90135ee59378038d authored over 11 years ago by Ryan Pitts <[email protected]>
start handling percentify on tables

github.com/censusreporter/censusreporter - 7e0d691fc1bac8f145fa5020119036242019a02b authored over 11 years ago by Ryan Pitts <[email protected]>
move table ID, release info into aside tab

github.com/censusreporter/censusreporter - 989ddf87d93417d9a5f5cf79dac083c24731447e authored over 11 years ago by Ryan Pitts <[email protected]>
Find the denominator column for each table.

github.com/censusreporter/census-table-metadata - 5a0af66f1d1c376a9b1c3acc106aeee5950a6674 authored over 11 years ago by Ian Dees <[email protected]>
Compute and write out topics to separate CSV files.

github.com/censusreporter/census-table-metadata - cb7c7d082822d067d53cf35cbb3cbe803807df3f authored over 11 years ago by Ian Dees <[email protected]>
Handle the case where the 2008 shells use spaces for indent.

github.com/censusreporter/census-table-metadata - a47137e95f49c6856c2dc37b51998e44edc9b640 authored over 11 years ago by Ian Dees <[email protected]>
Titlecase the universe text.

github.com/censusreporter/census-table-metadata - 55dc2b19964e46ebdce4b1f28a6416ddb8dc9a6f authored over 11 years ago by Ian Dees <[email protected]>
Add the simple table title.

github.com/censusreporter/census-table-metadata - ab527091e6bbaf680c68fc6931dcd1193bf371c8 authored over 11 years ago by Ian Dees <[email protected]>
Titlecase and other cleanups to the table title.

github.com/censusreporter/census-table-metadata - 0228674a17d847c5d41ceb7ccf23a7b381f15841 authored over 11 years ago by Ian Dees <[email protected]>
More robust handling of universe string.

github.com/censusreporter/census-table-metadata - 034ddfbc6d20a7f7b8bf506c0f301c372830658e authored over 11 years ago by Ian Dees <[email protected]>
Separate out the table and column metadata outputs.

github.com/censusreporter/census-table-metadata - d9cdec0abfc9299655af77c6e81bb5950f51427a authored over 11 years ago by Ian Dees <[email protected]>
add Google Analytics

github.com/censusreporter/censusreporter - 4a35ac485e0ffdb1bc07f02ec7c27018074a75e0 authored over 11 years ago by Joe Germuska <[email protected]>
Add a script to download the shells and merge files.

github.com/censusreporter/census-table-metadata - e71480c7bb86bb1be725584a64a519c04af32a81 authored over 11 years ago by Ian Dees <[email protected]>
resubmit parent autocomplete on child sumlev change

github.com/censusreporter/censusreporter - dd4b4f7db3df5f93324ca35bfeab63aa83a5c852 authored over 11 years ago by Ryan Pitts <[email protected]>
add min/max to choropleth legends

github.com/censusreporter/censusreporter - 5b8b33104410643edb2304b82742582bf4cdd12d authored over 11 years ago by Ryan Pitts <[email protected]>
tighten up compare templates

github.com/censusreporter/censusreporter - b04fb205b145237332c7f23c501a0979e7db02cc authored over 11 years ago by Ryan Pitts <[email protected]>
move release, universe info. add viz descriptions on compare pages

github.com/censusreporter/censusreporter - ad75f0c004ec61abad1ab779d1baf6ada1250ccc authored over 11 years ago by Ryan Pitts <[email protected]>
add 010 to PARENT_CHILD_CONTAINMENT

github.com/censusreporter/census-api - 94ce1cf68ecb9f9d88ccfdf1a2f3dee6507aad2c authored over 11 years ago by Ryan Pitts <[email protected]>
rowcount and compare endpoints account for sumlevs with zero results

github.com/censusreporter/census-api - 45cf5bdc05cb67c264d8caeb32ce11532c6c6a14 authored over 11 years ago by Ryan Pitts <[email protected]>
reset autocomplete query if chosen item is changed

github.com/censusreporter/censusreporter - bab76a77bdb64a78387324ff5b93a897c818be46 authored over 11 years ago by Ryan Pitts <[email protected]>
Join on the census_names view to use the normalized geoid column.

github.com/censusreporter/census-api - 8026d1d6df447e6001a22ba2d63dd466770b59ea authored over 11 years ago by Ian Dees <[email protected]>
fix search path in rowcount

github.com/censusreporter/census-api - bee1142e721c5a4c1d3f3ed812a8caa5c12ecf3d authored over 11 years ago by Ryan Pitts <[email protected]>
add Ian's geo prefix/GIS method to rowcount endpoint

github.com/censusreporter/census-api - 390510bf26b5d30b7d2249a44492d22f0600bdb3 authored over 11 years ago by Ryan Pitts <[email protected]>
I suck at Python.

github.com/censusreporter/census-api - 6d96db576dad759c8714909290a10b205143c7be authored over 11 years ago by Ian Dees <[email protected]>
Add native area sumlevel and use the full census view instead of the simplified one.

github.com/censusreporter/census-api - 0f1cf5f412084cd210ecb2af9e932a37071ee9d1 authored over 11 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/censusreporter

github.com/censusreporter/censusreporter - 6c5f3d17751ec27a84500728000cfbbc53414faf authored over 11 years ago by Ryan Pitts <[email protected]>
geo autocomplete calls real API

github.com/censusreporter/censusreporter - 528584107112a0b8749380b7bf95ea6467f5db01 authored over 11 years ago by Ryan Pitts <[email protected]>
match qwarg name for sumlev

github.com/censusreporter/census-api - cb0d5cd4b9ebee53bfadb0ae29cc2f1a16eba76a authored over 11 years ago by Ryan Pitts <[email protected]>
Not all geoids have geometries in TIGER.

github.com/censusreporter/censusreporter - 6394ae29e2c1bd8a83aaa3b19d78adb099f873d9 authored over 11 years ago by Ian Dees <[email protected]>
Trim trailing whitespace.

github.com/censusreporter/censusreporter - 8c73b43a0699989ac6c65c7655fdad83b1e84ee0 authored over 11 years ago by Ian Dees <[email protected]>
Used the wrong variable name here.

github.com/censusreporter/census-api - 937470d73e13f00445f360a39b55ca4a366f09fa authored over 11 years ago by Ian Dees <[email protected]>
Use Joe's parent/child containment dict.

github.com/censusreporter/census-api - 70f7360d3d36e8d5d79b651fb20309a63da14f59 authored over 11 years ago by Ian Dees <[email protected]>
CDPs can be bounded by states.

github.com/censusreporter/census-api - ae054814c8603ff334e7f909d4db08354e31d37d authored over 11 years ago by Ian Dees <[email protected]>
Remove trailing whitespace.

github.com/censusreporter/censusreporter - 595a03fac336ebc4611851c48985f7b7dfb71e88 authored over 11 years ago by Ian Dees <[email protected]>
Apply some interpolation on the projection.

github.com/censusreporter/censusreporter - db88d40b59335a1dccbe8ca165b8ef350aa39939 authored over 11 years ago by Ian Dees <[email protected]>
clean up compare map js

github.com/censusreporter/censusreporter - e705a8241e170fae3038e19705a78bae4ec0d565 authored over 11 years ago by Ryan Pitts <[email protected]>
flexible maps! no more harsh regime of counties and states only!

github.com/censusreporter/censusreporter - 1733491533ee011cfb3ab438e2a0e08e06c7bb68 authored over 11 years ago by Ryan Pitts <[email protected]>
Build a full name for the geo search response.

github.com/censusreporter/census-api - b5dce1c8705241bfb87fa38fba9cb44aa401b02c authored over 11 years ago by Ian Dees <[email protected]>
get parent geo from api only

github.com/censusreporter/censusreporter - a1726f8c492355c21ffdb4d1c89788f60b67f8c3 authored over 11 years ago by Ryan Pitts <[email protected]>
big cleanup on table methods and column matching

github.com/censusreporter/censusreporter - 1b01b826f75144d5427a32af5b0a70b135ce1d38 authored over 11 years ago by Ryan Pitts <[email protected]>
for parents too

github.com/censusreporter/census-api - d97538d27dfc49aed5c777ebc414ad8a2e52dd4a authored over 11 years ago by Ryan Pitts <[email protected]>
uppercase column IDs in child data

github.com/censusreporter/census-api - 685690ef8775b22e25adba3655b8178dcc059ab5 authored over 11 years ago by Ryan Pitts <[email protected]>
add download csv/json links to compare pages

github.com/censusreporter/censusreporter - f993264ffa3ecd787fc916ca699b807115506366 authored over 11 years ago by Ryan Pitts <[email protected]>
hook up json and csv formats

github.com/censusreporter/censusreporter - 874d092f7b5fa6f034591c50b3a9956080087905 authored over 11 years ago by Ryan Pitts <[email protected]>
toggle lock highlight rows

github.com/censusreporter/censusreporter - 65957ac368d752d8305fa9ab661517a1d46a5c4b authored over 11 years ago by Ryan Pitts <[email protected]>
move census release info into aside

github.com/censusreporter/censusreporter - db0d44544eaa73950cb303939fd6bfcaa84f5f63 authored over 11 years ago by Ryan Pitts <[email protected]>
flip islander/other in profile response

github.com/censusreporter/census-api - 91dc48a5880f0678770cca46cc6fc6c518395277 authored over 11 years ago by Ryan Pitts <[email protected]>
better coal chart labeling

github.com/censusreporter/censusreporter - ff40da5ae0f8531b29539e9a9227a2e8a613a0d2 authored over 11 years ago by Ryan Pitts <[email protected]>
the mere fact that you call it pop()pop() tells me you're ready for this

github.com/censusreporter/censusreporter - 3596b4ea90cadcab06fa82724bb4eeadfc9f0ba5 authored over 11 years ago by Ryan Pitts <[email protected]>
transpose data table presentation

github.com/censusreporter/censusreporter - 8a323a8ec65fcd6bf9738e86a8508f0b2d8f1086 authored over 11 years ago by Ryan Pitts <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-extractomatic

github.com/censusreporter/census-api - 1b7202d034dc96175515e84564683d1308c1887f authored over 11 years ago by Ryan Pitts <[email protected]>
order table columns in response

github.com/censusreporter/census-api - 497aeead3fe042c65fd236a32fcbe417640ee204 authored over 11 years ago by Ryan Pitts <[email protected]>
hold onto querystring when switching between viz types

github.com/censusreporter/censusreporter - ef1d853b671b3ec30e3f9de0163df6c07b738209 authored over 11 years ago by Ryan Pitts <[email protected]>
fix divide by zero in distribution chart

github.com/censusreporter/censusreporter - 76fb5a976b12bbf0afd3d0f726c1b6b22d8d50a7 authored over 11 years ago by Ryan Pitts <[email protected]>
d3 map quantile labels

github.com/censusreporter/censusreporter - ccdc91a0097a2f8271ecdff7e82493f8c4293537 authored over 11 years ago by Ryan Pitts <[email protected]>
map column IDs to column names on compare pages

github.com/censusreporter/censusreporter - 8509c978ed308a44ad77ff803363899092bba631 authored over 11 years ago by Ryan Pitts <[email protected]>
Don't make duplicate calls for parent geoheader info.

github.com/censusreporter/census-api - dfa1ac972fe3e5f9064fcb972005c59ea528bfa1 authored over 11 years ago by Ian Dees <[email protected]>
Fix the child geoid prefix building.

github.com/censusreporter/census-api - 3e18fc41cef30ef9a856cb292aee385644312c9b authored over 11 years ago by Ian Dees <[email protected]>
Clean up some pylint stuff.

github.com/censusreporter/census-api - 738fb50028cd8f59e5c51ec84ee6e1c0010df2d4 authored over 11 years ago by Ian Dees <[email protected]>
Try to optimize the parent/child relationship calculation when possible.

github.com/censusreporter/census-api - 0668cfe51bab72f2859d7e26978e844cba92e29f authored over 11 years ago by Ian Dees <[email protected]>