ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 22 and fips = 48237 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 |
---|---|---|---|---|---|---|---|
2105371 | 2105371 | 2022-01-11 | Jack | Texas | 48237 | 1142 | 22 |
2102120 | 2102120 | 2022-01-10 | Jack | Texas | 48237 | 1136 | 22 |
2098869 | 2098869 | 2022-01-09 | Jack | Texas | 48237 | 1127 | 22 |
2095617 | 2095617 | 2022-01-08 | Jack | Texas | 48237 | 1124 | 22 |
2092365 | 2092365 | 2022-01-07 | Jack | Texas | 48237 | 1121 | 22 |
2089113 | 2089113 | 2022-01-06 | Jack | Texas | 48237 | 1099 | 22 |
2085862 | 2085862 | 2022-01-05 | Jack | Texas | 48237 | 1094 | 22 |
2082610 | 2082610 | 2022-01-04 | Jack | Texas | 48237 | 1091 | 22 |
2079358 | 2079358 | 2022-01-03 | Jack | Texas | 48237 | 1086 | 22 |
2076107 | 2076107 | 2022-01-02 | Jack | Texas | 48237 | 1068 | 22 |
2072856 | 2072856 | 2022-01-01 | Jack | Texas | 48237 | 1068 | 22 |
2069605 | 2069605 | 2021-12-31 | Jack | Texas | 48237 | 1068 | 22 |
2066354 | 2066354 | 2021-12-30 | Jack | Texas | 48237 | 1068 | 22 |
2063104 | 2063104 | 2021-12-29 | Jack | Texas | 48237 | 1066 | 22 |
2059854 | 2059854 | 2021-12-28 | Jack | Texas | 48237 | 1065 | 22 |
2056605 | 2056605 | 2021-12-27 | Jack | Texas | 48237 | 1065 | 22 |
2053356 | 2053356 | 2021-12-26 | Jack | Texas | 48237 | 1058 | 22 |
2050106 | 2050106 | 2021-12-25 | Jack | Texas | 48237 | 1058 | 22 |
2046856 | 2046856 | 2021-12-24 | Jack | Texas | 48237 | 1058 | 22 |
2043606 | 2043606 | 2021-12-23 | Jack | Texas | 48237 | 1058 | 22 |
2040357 | 2040357 | 2021-12-22 | Jack | Texas | 48237 | 1054 | 22 |
2037107 | 2037107 | 2021-12-21 | Jack | Texas | 48237 | 1054 | 22 |
2033857 | 2033857 | 2021-12-20 | Jack | Texas | 48237 | 1053 | 22 |
2030607 | 2030607 | 2021-12-19 | Jack | Texas | 48237 | 1051 | 22 |
2027356 | 2027356 | 2021-12-18 | Jack | Texas | 48237 | 1051 | 22 |
2024105 | 2024105 | 2021-12-17 | Jack | Texas | 48237 | 1033 | 22 |
2020854 | 2020854 | 2021-12-16 | Jack | Texas | 48237 | 1032 | 22 |
2017603 | 2017603 | 2021-12-15 | Jack | Texas | 48237 | 1030 | 22 |
2014353 | 2014353 | 2021-12-14 | Jack | Texas | 48237 | 1028 | 22 |
2011102 | 2011102 | 2021-12-13 | Jack | Texas | 48237 | 1026 | 22 |
2007851 | 2007851 | 2021-12-12 | Jack | Texas | 48237 | 1024 | 22 |
2004600 | 2004600 | 2021-12-11 | Jack | Texas | 48237 | 1024 | 22 |
2001349 | 2001349 | 2021-12-10 | Jack | Texas | 48237 | 1021 | 22 |
1998099 | 1998099 | 2021-12-09 | Jack | Texas | 48237 | 1016 | 22 |
1994848 | 1994848 | 2021-12-08 | Jack | Texas | 48237 | 1008 | 22 |
1991597 | 1991597 | 2021-12-07 | Jack | Texas | 48237 | 1007 | 22 |
1988346 | 1988346 | 2021-12-06 | Jack | Texas | 48237 | 1006 | 22 |
1985096 | 1985096 | 2021-12-05 | Jack | Texas | 48237 | 1006 | 22 |
1981846 | 1981846 | 2021-12-04 | Jack | Texas | 48237 | 1006 | 22 |
1978596 | 1978596 | 2021-12-03 | Jack | Texas | 48237 | 1005 | 22 |
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);