ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Gray", deaths = 54 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1218559 | 1218559 | 2021-04-13 | Gray | Texas | 48179 | 2300 | 54 |
1215311 | 1215311 | 2021-04-12 | Gray | Texas | 48179 | 2252 | 54 |
1212064 | 1212064 | 2021-04-11 | Gray | Texas | 48179 | 2252 | 54 |
1208815 | 1208815 | 2021-04-10 | Gray | Texas | 48179 | 2252 | 54 |
1205567 | 1205567 | 2021-04-09 | Gray | Texas | 48179 | 2217 | 54 |
1202319 | 1202319 | 2021-04-08 | Gray | Texas | 48179 | 2213 | 54 |
1199070 | 1199070 | 2021-04-07 | Gray | Texas | 48179 | 2069 | 54 |
1195821 | 1195821 | 2021-04-06 | Gray | Texas | 48179 | 2048 | 54 |
1192573 | 1192573 | 2021-04-05 | Gray | Texas | 48179 | 2058 | 54 |
1189324 | 1189324 | 2021-04-04 | Gray | Texas | 48179 | 2058 | 54 |
1186077 | 1186077 | 2021-04-03 | Gray | Texas | 48179 | 2058 | 54 |
1182830 | 1182830 | 2021-04-02 | Gray | Texas | 48179 | 2058 | 54 |
1179583 | 1179583 | 2021-04-01 | Gray | Texas | 48179 | 2054 | 54 |
1176336 | 1176336 | 2021-03-31 | Gray | Texas | 48179 | 2053 | 54 |
1173089 | 1173089 | 2021-03-30 | Gray | Texas | 48179 | 2051 | 54 |
1169842 | 1169842 | 2021-03-29 | Gray | Texas | 48179 | 2049 | 54 |
1166594 | 1166594 | 2021-03-28 | Gray | Texas | 48179 | 2049 | 54 |
1163346 | 1163346 | 2021-03-27 | Gray | Texas | 48179 | 2049 | 54 |
1160097 | 1160097 | 2021-03-26 | Gray | Texas | 48179 | 2046 | 54 |
1156850 | 1156850 | 2021-03-25 | Gray | Texas | 48179 | 2039 | 54 |
1153603 | 1153603 | 2021-03-24 | Gray | Texas | 48179 | 2039 | 54 |
1150356 | 1150356 | 2021-03-23 | Gray | Texas | 48179 | 2023 | 54 |
1147109 | 1147109 | 2021-03-22 | Gray | Texas | 48179 | 2015 | 54 |
1143862 | 1143862 | 2021-03-21 | Gray | Texas | 48179 | 2015 | 54 |
1140615 | 1140615 | 2021-03-20 | Gray | Texas | 48179 | 2015 | 54 |
1137369 | 1137369 | 2021-03-19 | Gray | Texas | 48179 | 2016 | 54 |
1134123 | 1134123 | 2021-03-18 | Gray | Texas | 48179 | 2019 | 54 |
1130875 | 1130875 | 2021-03-17 | Gray | Texas | 48179 | 2024 | 54 |
1127628 | 1127628 | 2021-03-16 | Gray | Texas | 48179 | 2022 | 54 |
1124382 | 1124382 | 2021-03-15 | Gray | Texas | 48179 | 2021 | 54 |
1121136 | 1121136 | 2021-03-14 | Gray | Texas | 48179 | 2021 | 54 |
1117889 | 1117889 | 2021-03-13 | Gray | Texas | 48179 | 2021 | 54 |
1114642 | 1114642 | 2021-03-12 | Gray | Texas | 48179 | 2011 | 54 |
1111396 | 1111396 | 2021-03-11 | Gray | Texas | 48179 | 2010 | 54 |
1108150 | 1108150 | 2021-03-10 | Gray | Texas | 48179 | 2004 | 54 |
1104904 | 1104904 | 2021-03-09 | Gray | Texas | 48179 | 2006 | 54 |
1101658 | 1101658 | 2021-03-08 | Gray | Texas | 48179 | 1999 | 54 |
1098412 | 1098412 | 2021-03-07 | Gray | Texas | 48179 | 1999 | 54 |
1095164 | 1095164 | 2021-03-06 | Gray | Texas | 48179 | 1999 | 54 |
1091918 | 1091918 | 2021-03-05 | Gray | Texas | 48179 | 2001 | 54 |
1088672 | 1088672 | 2021-03-04 | Gray | Texas | 48179 | 1998 | 54 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);