Untitled attachment

Notices where this attachment appears

1. Anirvan Chatterjee (anirvan@mastodon.social)'s status on Monday, 27-Feb-2023 07:35:07 JST Anirvan Chatterjee

   in reply to

   I've been testing @simon's amazing #Datasette tool, which makes it easy to explore CSV and JSON datasets: https://datasette.io

   Simon has a version that runs in your (desktop) web browser, so I pointed it at my dataset.

   Here's the link if you want to see for yourself:

   https://lite.datasette.io/?json=https%3A%2F%2Fraw.githubusercontent.com%2Fanirvan%2F1940-singh-census%2Fmaster%2F1940_singh_census_basic.json#/data/1940_singh_census_basic?_filter_column_1=&_filter_op_1=exact&_filter_value_1=%5B%22non-South+Asian+wife%22%5D&_filter_column_2=&_filter_op_2=exact&_filter_value_2=Black&_filter_column=&_filter_op=exact&_filter_value=&_sort=rowid&_facet=gender&_facet=inferredGroups&_facet=raceRecordedNormalized&_facet=censusLocationNormalized&_facet=birthPlaceNormalized

   I spent a few minutes exploring the facets, when I found three Black women with the last name of Singh in the 1940 U.S. Census (!!!)

   This is the exact query I ran:

   https://lite.datasette.io/?json=https%3A%2F%2Fraw.githubusercontent.com%2Fanirvan%2F1940-singh-census%2Fmaster%2F1940_singh_census_basic.json#/data/1940_singh_census_basic?_sort=rowid&_facet=gender&_facet=inferredGroups&_facet=raceRecordedNormalized&_facet=censusLocationNormalized&_facet=birthPlaceNormalized&raceRecordedNormalized=Black&inferredGroups=[%22non-South+Asian+wife%22

   4/n