ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 480 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417538 | 2417538 | 2022-04-17 | Angelina | Texas | 48005 | 15415 | 480 |
2414282 | 2414282 | 2022-04-16 | Angelina | Texas | 48005 | 15415 | 480 |
2411026 | 2411026 | 2022-04-15 | Angelina | Texas | 48005 | 15415 | 480 |
2407770 | 2407770 | 2022-04-14 | Angelina | Texas | 48005 | 15415 | 480 |
2404514 | 2404514 | 2022-04-13 | Angelina | Texas | 48005 | 15405 | 480 |
2401259 | 2401259 | 2022-04-12 | Angelina | Texas | 48005 | 15403 | 480 |
2398004 | 2398004 | 2022-04-11 | Angelina | Texas | 48005 | 15388 | 480 |
2394749 | 2394749 | 2022-04-10 | Angelina | Texas | 48005 | 15388 | 480 |
2391493 | 2391493 | 2022-04-09 | Angelina | Texas | 48005 | 15372 | 480 |
2388237 | 2388237 | 2022-04-08 | Angelina | Texas | 48005 | 15371 | 480 |
2384982 | 2384982 | 2022-04-07 | Angelina | Texas | 48005 | 15362 | 480 |
2381727 | 2381727 | 2022-04-06 | Angelina | Texas | 48005 | 15362 | 480 |
2378472 | 2378472 | 2022-04-05 | Angelina | Texas | 48005 | 15359 | 480 |
2375218 | 2375218 | 2022-04-04 | Angelina | Texas | 48005 | 15359 | 480 |
2371966 | 2371966 | 2022-04-03 | Angelina | Texas | 48005 | 15350 | 480 |
2368713 | 2368713 | 2022-04-02 | Angelina | Texas | 48005 | 15344 | 480 |
2365460 | 2365460 | 2022-04-01 | Angelina | Texas | 48005 | 15343 | 480 |
2362207 | 2362207 | 2022-03-31 | Angelina | Texas | 48005 | 15338 | 480 |
2358953 | 2358953 | 2022-03-30 | Angelina | Texas | 48005 | 15336 | 480 |
2355699 | 2355699 | 2022-03-29 | Angelina | Texas | 48005 | 15326 | 480 |
2352446 | 2352446 | 2022-03-28 | Angelina | Texas | 48005 | 15304 | 480 |
2349194 | 2349194 | 2022-03-27 | Angelina | Texas | 48005 | 15304 | 480 |
2345941 | 2345941 | 2022-03-26 | Angelina | Texas | 48005 | 15304 | 480 |
2342688 | 2342688 | 2022-03-25 | Angelina | Texas | 48005 | 15297 | 480 |
2339435 | 2339435 | 2022-03-24 | Angelina | Texas | 48005 | 15294 | 480 |
2264785 | 2264785 | 2022-03-01 | Midland | Texas | 48329 | 37023 | 480 |
1975298 | 1975298 | 2021-12-02 | Ellis | Texas | 48139 | 34133 | 480 |
1972049 | 1972049 | 2021-12-01 | Ellis | Texas | 48139 | 34118 | 480 |
1968799 | 1968799 | 2021-11-30 | Ellis | Texas | 48139 | 34108 | 480 |
1965548 | 1965548 | 2021-11-29 | Ellis | Texas | 48139 | 34071 | 480 |
1851822 | 1851822 | 2021-10-25 | Grayson | Texas | 48181 | 16104 | 480 |
1848572 | 1848572 | 2021-10-24 | Grayson | Texas | 48181 | 16104 | 480 |
1845322 | 1845322 | 2021-10-23 | Grayson | Texas | 48181 | 16104 | 480 |
1822730 | 1822730 | 2021-10-16 | Wichita | Texas | 48485 | 21692 | 480 |
1757726 | 1757726 | 2021-09-26 | Taylor | Texas | 48441 | 21277 | 480 |
1754478 | 1754478 | 2021-09-25 | Taylor | Texas | 48441 | 21277 | 480 |
1751230 | 1751230 | 2021-09-24 | Taylor | Texas | 48441 | 21277 | 480 |
1747828 | 1747828 | 2021-09-23 | Ector | Texas | 48135 | 24367 | 480 |
1617834 | 1617834 | 2021-08-14 | Bell | Texas | 48027 | 29221 | 480 |
1397279 | 1397279 | 2021-06-07 | Williamson | Texas | 48491 | 47206 | 480 |
1394032 | 1394032 | 2021-06-06 | Williamson | Texas | 48491 | 47083 | 480 |
1390787 | 1390787 | 2021-06-05 | Williamson | Texas | 48491 | 47083 | 480 |
1355051 | 1355051 | 2021-05-25 | Smith | Texas | 48423 | 20424 | 480 |
1250963 | 1250963 | 2021-04-23 | Brazoria | Texas | 48039 | 36880 | 480 |
988046 | 988046 | 2021-02-01 | Fort Bend | Texas | 48157 | 50368 | 480 |
984799 | 984799 | 2021-01-31 | Fort Bend | Texas | 48157 | 49992 | 480 |
858393 | 858393 | 2020-12-23 | Webb | Texas | 48479 | 24915 | 480 |
855148 | 855148 | 2020-12-22 | Webb | Texas | 48479 | 24915 | 480 |
777196 | 777196 | 2020-11-28 | Nueces | Texas | 48355 | 23995 | 480 |
773951 | 773951 | 2020-11-27 | Nueces | Texas | 48355 | 23795 | 480 |
430608 | 430608 | 2020-08-13 | Tarrant | Texas | 48439 | 35129 | 480 |
375682 | 375682 | 2020-07-27 | Bexar | Texas | 48029 | 36450 | 480 |
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);