ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 734 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Texas · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489300 | 2489300 | 2022-05-09 | Johnson | Texas | 48251 | 43847 | 734 |
2486043 | 2486043 | 2022-05-08 | Johnson | Texas | 48251 | 43842 | 734 |
2482785 | 2482785 | 2022-05-07 | Johnson | Texas | 48251 | 43833 | 734 |
2479527 | 2479527 | 2022-05-06 | Johnson | Texas | 48251 | 43820 | 734 |
2476269 | 2476269 | 2022-05-05 | Johnson | Texas | 48251 | 43804 | 734 |
2473012 | 2473012 | 2022-05-04 | Johnson | Texas | 48251 | 43800 | 734 |
2469756 | 2469756 | 2022-05-03 | Johnson | Texas | 48251 | 43776 | 734 |
2466500 | 2466500 | 2022-05-02 | Johnson | Texas | 48251 | 43757 | 734 |
2463245 | 2463245 | 2022-05-01 | Johnson | Texas | 48251 | 43754 | 734 |
2459989 | 2459989 | 2022-04-30 | Johnson | Texas | 48251 | 43754 | 734 |
2456733 | 2456733 | 2022-04-29 | Johnson | Texas | 48251 | 43711 | 734 |
2453477 | 2453477 | 2022-04-28 | Johnson | Texas | 48251 | 43676 | 734 |
2450221 | 2450221 | 2022-04-27 | Johnson | Texas | 48251 | 43633 | 734 |
2446964 | 2446964 | 2022-04-26 | Johnson | Texas | 48251 | 43611 | 734 |
2443709 | 2443709 | 2022-04-25 | Johnson | Texas | 48251 | 43579 | 734 |
2440453 | 2440453 | 2022-04-24 | Johnson | Texas | 48251 | 43579 | 734 |
2437197 | 2437197 | 2022-04-23 | Johnson | Texas | 48251 | 43574 | 734 |
2433941 | 2433941 | 2022-04-22 | Johnson | Texas | 48251 | 43525 | 734 |
2430685 | 2430685 | 2022-04-21 | Johnson | Texas | 48251 | 43488 | 734 |
2427429 | 2427429 | 2022-04-20 | Johnson | Texas | 48251 | 43443 | 734 |
2424173 | 2424173 | 2022-04-19 | Johnson | Texas | 48251 | 43391 | 734 |
2102085 | 2102085 | 2022-01-10 | Galveston | Texas | 48167 | 80124 | 734 |
2098834 | 2098834 | 2022-01-09 | Galveston | Texas | 48167 | 79208 | 734 |
2095582 | 2095582 | 2022-01-08 | Galveston | Texas | 48167 | 78481 | 734 |
2092330 | 2092330 | 2022-01-07 | Galveston | Texas | 48167 | 77655 | 734 |
1972224 | 1972224 | 2021-12-01 | Williamson | Texas | 48491 | 78951 | 734 |
1942733 | 1942733 | 2021-11-22 | Bell | Texas | 48027 | 39510 | 734 |
1939483 | 1939483 | 2021-11-21 | Bell | Texas | 48027 | 39510 | 734 |
1936233 | 1936233 | 2021-11-20 | Bell | Texas | 48027 | 39510 | 734 |
1932983 | 1932983 | 2021-11-19 | Bell | Texas | 48027 | 39472 | 734 |
1215283 | 1215283 | 2021-04-12 | Denton | Texas | 48121 | 72779 | 734 |
1212036 | 1212036 | 2021-04-11 | Denton | Texas | 48121 | 72583 | 734 |
1208787 | 1208787 | 2021-04-10 | Denton | Texas | 48121 | 72583 | 734 |
1124470 | 1124470 | 2021-03-15 | Nueces | Texas | 48355 | 36383 | 734 |
602050 | 602050 | 2020-10-05 | Tarrant | Texas | 48439 | 52366 | 734 |
598807 | 598807 | 2020-10-04 | Tarrant | Texas | 48439 | 52100 | 734 |
595564 | 595564 | 2020-10-03 | Tarrant | Texas | 48439 | 51499 | 734 |
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);