ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where deaths = 54 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Lee 65
- Newton 56
- Madison 48
- Terry 42
- Gray 41
- Runnels 39
- Coleman 30
- Llano 26
- Kleberg 22
- Nolan 16
- Freestone 12
- Gillespie 12
- Colorado 11
- Zavala 11
- Gonzales 10
- Houston 10
- Comanche 9
- Frio 9
- Gaines 9
- Bandera 8
- Medina 8
- Navarro 8
- Aransas 7
- Grimes 7
- Pecos 7
- Washington 7
- Wilbarger 7
- Young 7
- Matagorda 6
- Potter 6
- …
state 1
- Texas · 739 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502360 | 2502360 | 2022-05-13 | Madison | Texas | 48313 | 3778 | 54 |
2499102 | 2499102 | 2022-05-12 | Madison | Texas | 48313 | 3777 | 54 |
2495844 | 2495844 | 2022-05-11 | Madison | Texas | 48313 | 3775 | 54 |
2492586 | 2492586 | 2022-05-10 | Madison | Texas | 48313 | 3775 | 54 |
2489328 | 2489328 | 2022-05-09 | Madison | Texas | 48313 | 3773 | 54 |
2486071 | 2486071 | 2022-05-08 | Madison | Texas | 48313 | 3770 | 54 |
2482813 | 2482813 | 2022-05-07 | Madison | Texas | 48313 | 3770 | 54 |
2479555 | 2479555 | 2022-05-06 | Madison | Texas | 48313 | 3751 | 54 |
2476297 | 2476297 | 2022-05-05 | Madison | Texas | 48313 | 3731 | 54 |
2473040 | 2473040 | 2022-05-04 | Madison | Texas | 48313 | 3731 | 54 |
2469784 | 2469784 | 2022-05-03 | Madison | Texas | 48313 | 3731 | 54 |
2466528 | 2466528 | 2022-05-02 | Madison | Texas | 48313 | 3730 | 54 |
2463273 | 2463273 | 2022-05-01 | Madison | Texas | 48313 | 3729 | 54 |
2460017 | 2460017 | 2022-04-30 | Madison | Texas | 48313 | 3727 | 54 |
2456761 | 2456761 | 2022-04-29 | Madison | Texas | 48313 | 3725 | 54 |
2453505 | 2453505 | 2022-04-28 | Madison | Texas | 48313 | 3724 | 54 |
2450249 | 2450249 | 2022-04-27 | Madison | Texas | 48313 | 3723 | 54 |
2446992 | 2446992 | 2022-04-26 | Madison | Texas | 48313 | 3721 | 54 |
2443737 | 2443737 | 2022-04-25 | Madison | Texas | 48313 | 3721 | 54 |
2440481 | 2440481 | 2022-04-24 | Madison | Texas | 48313 | 3721 | 54 |
2437225 | 2437225 | 2022-04-23 | Madison | Texas | 48313 | 3721 | 54 |
2433969 | 2433969 | 2022-04-22 | Madison | Texas | 48313 | 3719 | 54 |
2430713 | 2430713 | 2022-04-21 | Madison | Texas | 48313 | 3719 | 54 |
2427457 | 2427457 | 2022-04-20 | Madison | Texas | 48313 | 3719 | 54 |
2424201 | 2424201 | 2022-04-19 | Madison | Texas | 48313 | 3719 | 54 |
2420945 | 2420945 | 2022-04-18 | Madison | Texas | 48313 | 3719 | 54 |
2417689 | 2417689 | 2022-04-17 | Madison | Texas | 48313 | 3717 | 54 |
2414433 | 2414433 | 2022-04-16 | Madison | Texas | 48313 | 3717 | 54 |
2411177 | 2411177 | 2022-04-15 | Madison | Texas | 48313 | 3717 | 54 |
2407921 | 2407921 | 2022-04-14 | Madison | Texas | 48313 | 3717 | 54 |
2404665 | 2404665 | 2022-04-13 | Madison | Texas | 48313 | 3717 | 54 |
2401410 | 2401410 | 2022-04-12 | Madison | Texas | 48313 | 3717 | 54 |
2398155 | 2398155 | 2022-04-11 | Madison | Texas | 48313 | 3715 | 54 |
2394900 | 2394900 | 2022-04-10 | Madison | Texas | 48313 | 3713 | 54 |
2391644 | 2391644 | 2022-04-09 | Madison | Texas | 48313 | 3712 | 54 |
2388388 | 2388388 | 2022-04-08 | Madison | Texas | 48313 | 3711 | 54 |
2388487 | 2388487 | 2022-04-08 | Zapata | Texas | 48505 | 3674 | 54 |
2385133 | 2385133 | 2022-04-07 | Madison | Texas | 48313 | 3711 | 54 |
2385232 | 2385232 | 2022-04-07 | Zapata | Texas | 48505 | 3674 | 54 |
2381878 | 2381878 | 2022-04-06 | Madison | Texas | 48313 | 3711 | 54 |
2378623 | 2378623 | 2022-04-05 | Madison | Texas | 48313 | 3711 | 54 |
2375369 | 2375369 | 2022-04-04 | Madison | Texas | 48313 | 3710 | 54 |
2372117 | 2372117 | 2022-04-03 | Madison | Texas | 48313 | 3710 | 54 |
2368864 | 2368864 | 2022-04-02 | Madison | Texas | 48313 | 3710 | 54 |
2365611 | 2365611 | 2022-04-01 | Madison | Texas | 48313 | 3709 | 54 |
2362358 | 2362358 | 2022-03-31 | Madison | Texas | 48313 | 3709 | 54 |
2359104 | 2359104 | 2022-03-30 | Madison | Texas | 48313 | 3709 | 54 |
2355850 | 2355850 | 2022-03-29 | Madison | Texas | 48313 | 3708 | 54 |
2352597 | 2352597 | 2022-03-28 | Madison | Texas | 48313 | 3706 | 54 |
2349345 | 2349345 | 2022-03-27 | Madison | Texas | 48313 | 3706 | 54 |
2199782 | 2199782 | 2022-02-09 | Rains | Texas | 48379 | 1779 | 54 |
2196528 | 2196528 | 2022-02-08 | Rains | Texas | 48379 | 1777 | 54 |
2150911 | 2150911 | 2022-01-25 | Jackson | Texas | 48239 | 3065 | 54 |
2147659 | 2147659 | 2022-01-24 | Jackson | Texas | 48239 | 3060 | 54 |
2144405 | 2144405 | 2022-01-23 | Jackson | Texas | 48239 | 3053 | 54 |
2134593 | 2134593 | 2022-01-20 | Falls | Texas | 48145 | 3320 | 54 |
2131341 | 2131341 | 2022-01-19 | Falls | Texas | 48145 | 3283 | 54 |
2128087 | 2128087 | 2022-01-18 | Falls | Texas | 48145 | 3273 | 54 |
2124835 | 2124835 | 2022-01-17 | Falls | Texas | 48145 | 3265 | 54 |
2121583 | 2121583 | 2022-01-16 | Falls | Texas | 48145 | 3245 | 54 |
2115151 | 2115151 | 2022-01-14 | Lee | Texas | 48287 | 3428 | 54 |
2111899 | 2111899 | 2022-01-13 | Lee | Texas | 48287 | 3351 | 54 |
2108647 | 2108647 | 2022-01-12 | Lee | Texas | 48287 | 3324 | 54 |
2108679 | 2108679 | 2022-01-12 | Newton | Texas | 48351 | 1088 | 54 |
2105396 | 2105396 | 2022-01-11 | Lee | Texas | 48287 | 3314 | 54 |
2105428 | 2105428 | 2022-01-11 | Newton | Texas | 48351 | 1077 | 54 |
2102145 | 2102145 | 2022-01-10 | Lee | Texas | 48287 | 3298 | 54 |
2102177 | 2102177 | 2022-01-10 | Newton | Texas | 48351 | 1068 | 54 |
2098894 | 2098894 | 2022-01-09 | Lee | Texas | 48287 | 3292 | 54 |
2098926 | 2098926 | 2022-01-09 | Newton | Texas | 48351 | 1052 | 54 |
2095642 | 2095642 | 2022-01-08 | Lee | Texas | 48287 | 3281 | 54 |
2095674 | 2095674 | 2022-01-08 | Newton | Texas | 48351 | 1046 | 54 |
2092390 | 2092390 | 2022-01-07 | Lee | Texas | 48287 | 3248 | 54 |
2092422 | 2092422 | 2022-01-07 | Newton | Texas | 48351 | 1043 | 54 |
2089138 | 2089138 | 2022-01-06 | Lee | Texas | 48287 | 3201 | 54 |
2089170 | 2089170 | 2022-01-06 | Newton | Texas | 48351 | 1036 | 54 |
2085887 | 2085887 | 2022-01-05 | Lee | Texas | 48287 | 3177 | 54 |
2085919 | 2085919 | 2022-01-05 | Newton | Texas | 48351 | 1026 | 54 |
2082635 | 2082635 | 2022-01-04 | Lee | Texas | 48287 | 3108 | 54 |
2082667 | 2082667 | 2022-01-04 | Newton | Texas | 48351 | 1021 | 54 |
2079383 | 2079383 | 2022-01-03 | Lee | Texas | 48287 | 3092 | 54 |
2079415 | 2079415 | 2022-01-03 | Newton | Texas | 48351 | 1020 | 54 |
2076132 | 2076132 | 2022-01-02 | Lee | Texas | 48287 | 3057 | 54 |
2076164 | 2076164 | 2022-01-02 | Newton | Texas | 48351 | 987 | 54 |
2072881 | 2072881 | 2022-01-01 | Lee | Texas | 48287 | 3057 | 54 |
2072913 | 2072913 | 2022-01-01 | Newton | Texas | 48351 | 987 | 54 |
2069630 | 2069630 | 2021-12-31 | Lee | Texas | 48287 | 3057 | 54 |
2069662 | 2069662 | 2021-12-31 | Newton | Texas | 48351 | 987 | 54 |
2066379 | 2066379 | 2021-12-30 | Lee | Texas | 48287 | 3057 | 54 |
2066411 | 2066411 | 2021-12-30 | Newton | Texas | 48351 | 987 | 54 |
2063129 | 2063129 | 2021-12-29 | Lee | Texas | 48287 | 3044 | 54 |
2063161 | 2063161 | 2021-12-29 | Newton | Texas | 48351 | 983 | 54 |
2059879 | 2059879 | 2021-12-28 | Lee | Texas | 48287 | 3025 | 54 |
2059911 | 2059911 | 2021-12-28 | Newton | Texas | 48351 | 977 | 54 |
2056630 | 2056630 | 2021-12-27 | Lee | Texas | 48287 | 3023 | 54 |
2056662 | 2056662 | 2021-12-27 | Newton | Texas | 48351 | 977 | 54 |
2053381 | 2053381 | 2021-12-26 | Lee | Texas | 48287 | 3020 | 54 |
2053413 | 2053413 | 2021-12-26 | Newton | Texas | 48351 | 977 | 54 |
2050131 | 2050131 | 2021-12-25 | Lee | Texas | 48287 | 3020 | 54 |
2050163 | 2050163 | 2021-12-25 | Newton | Texas | 48351 | 977 | 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);