ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 492 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502344 | 2502344 | 2022-05-13 | Knox | Texas | 48275 | 492 | 25 |
2499086 | 2499086 | 2022-05-12 | Knox | Texas | 48275 | 492 | 25 |
2495828 | 2495828 | 2022-05-11 | Knox | Texas | 48275 | 492 | 25 |
2492570 | 2492570 | 2022-05-10 | Knox | Texas | 48275 | 492 | 25 |
2489312 | 2489312 | 2022-05-09 | Knox | Texas | 48275 | 492 | 25 |
2486055 | 2486055 | 2022-05-08 | Knox | Texas | 48275 | 492 | 25 |
2482797 | 2482797 | 2022-05-07 | Knox | Texas | 48275 | 492 | 25 |
2479539 | 2479539 | 2022-05-06 | Knox | Texas | 48275 | 492 | 25 |
2476281 | 2476281 | 2022-05-05 | Knox | Texas | 48275 | 492 | 25 |
2473024 | 2473024 | 2022-05-04 | Knox | Texas | 48275 | 492 | 25 |
2469768 | 2469768 | 2022-05-03 | Knox | Texas | 48275 | 492 | 25 |
2466512 | 2466512 | 2022-05-02 | Knox | Texas | 48275 | 492 | 25 |
2463257 | 2463257 | 2022-05-01 | Knox | Texas | 48275 | 492 | 25 |
2460001 | 2460001 | 2022-04-30 | Knox | Texas | 48275 | 492 | 25 |
2456745 | 2456745 | 2022-04-29 | Knox | Texas | 48275 | 492 | 25 |
2453489 | 2453489 | 2022-04-28 | Knox | Texas | 48275 | 492 | 25 |
2450233 | 2450233 | 2022-04-27 | Knox | Texas | 48275 | 492 | 25 |
2446976 | 2446976 | 2022-04-26 | Knox | Texas | 48275 | 492 | 25 |
2443721 | 2443721 | 2022-04-25 | Knox | Texas | 48275 | 492 | 25 |
2440465 | 2440465 | 2022-04-24 | Knox | Texas | 48275 | 492 | 25 |
2437209 | 2437209 | 2022-04-23 | Knox | Texas | 48275 | 492 | 25 |
2433953 | 2433953 | 2022-04-22 | Knox | Texas | 48275 | 492 | 25 |
2430697 | 2430697 | 2022-04-21 | Knox | Texas | 48275 | 492 | 25 |
2427441 | 2427441 | 2022-04-20 | Knox | Texas | 48275 | 492 | 25 |
2424185 | 2424185 | 2022-04-19 | Knox | Texas | 48275 | 492 | 25 |
2420929 | 2420929 | 2022-04-18 | Knox | Texas | 48275 | 492 | 25 |
2287599 | 2287599 | 2022-03-08 | Sherman | Texas | 48421 | 492 | 16 |
2228866 | 2228866 | 2022-02-18 | Armstrong | Texas | 48011 | 492 | 8 |
2225615 | 2225615 | 2022-02-17 | Armstrong | Texas | 48011 | 492 | 8 |
2124942 | 2124942 | 2022-01-17 | Oldham | Texas | 48359 | 492 | 6 |
1975267 | 1975267 | 2021-12-02 | Cochran | Texas | 48079 | 492 | 19 |
1786884 | 1786884 | 2021-10-05 | Kinney | Texas | 48271 | 492 | 8 |
1786941 | 1786941 | 2021-10-05 | Real | Texas | 48385 | 492 | 17 |
1783635 | 1783635 | 2021-10-04 | Kinney | Texas | 48271 | 492 | 8 |
1783692 | 1783692 | 2021-10-04 | Real | Texas | 48385 | 492 | 16 |
1780386 | 1780386 | 2021-10-03 | Kinney | Texas | 48271 | 492 | 8 |
1780443 | 1780443 | 2021-10-03 | Real | Texas | 48385 | 492 | 16 |
1777136 | 1777136 | 2021-10-02 | Kinney | Texas | 48271 | 492 | 8 |
1777193 | 1777193 | 2021-10-02 | Real | Texas | 48385 | 492 | 16 |
1773886 | 1773886 | 2021-10-01 | Kinney | Texas | 48271 | 492 | 8 |
1773943 | 1773943 | 2021-10-01 | Real | Texas | 48385 | 492 | 16 |
1770636 | 1770636 | 2021-09-30 | Kinney | Texas | 48271 | 492 | 8 |
1770693 | 1770693 | 2021-09-30 | Real | Texas | 48385 | 492 | 16 |
1676389 | 1676389 | 2021-09-01 | Haskell | Texas | 48207 | 492 | 28 |
1332194 | 1332194 | 2021-05-18 | Garza | Texas | 48169 | 492 | 22 |
1085539 | 1085539 | 2021-03-03 | Sabine | Texas | 48403 | 492 | 38 |
1082293 | 1082293 | 2021-03-02 | Sabine | Texas | 48403 | 492 | 38 |
1079047 | 1079047 | 2021-03-01 | Sabine | Texas | 48403 | 492 | 38 |
1075802 | 1075802 | 2021-02-28 | Sabine | Texas | 48403 | 492 | 38 |
1072556 | 1072556 | 2021-02-27 | Sabine | Texas | 48403 | 492 | 38 |
1069310 | 1069310 | 2021-02-26 | Sabine | Texas | 48403 | 492 | 38 |
1066065 | 1066065 | 2021-02-25 | Sabine | Texas | 48403 | 492 | 38 |
920007 | 920007 | 2021-01-11 | Red River | Texas | 48387 | 492 | 27 |
907037 | 907037 | 2021-01-07 | San Jacinto | Texas | 48407 | 492 | 20 |
848470 | 848470 | 2020-12-20 | Crane | Texas | 48103 | 492 | 9 |
819228 | 819228 | 2020-12-11 | Brooks | Texas | 48047 | 492 | 26 |
793252 | 793252 | 2020-12-03 | Bailey | Texas | 48017 | 492 | 8 |
764235 | 764235 | 2020-11-24 | Robertson | Texas | 48395 | 492 | 7 |
679749 | 679749 | 2020-10-29 | Duval | Texas | 48131 | 492 | 21 |
618087 | 618087 | 2020-10-10 | Colorado | Texas | 48089 | 492 | 4 |
614845 | 614845 | 2020-10-09 | Colorado | Texas | 48089 | 492 | 4 |
592179 | 592179 | 2020-10-02 | Fayette | Texas | 48149 | 492 | 21 |
588939 | 588939 | 2020-10-01 | Fayette | Texas | 48149 | 492 | 21 |
472470 | 472470 | 2020-08-26 | Jackson | Texas | 48239 | 492 | 13 |
359822 | 359822 | 2020-07-22 | San Patricio | Texas | 48409 | 492 | 0 |
353372 | 353372 | 2020-07-20 | Medina | Texas | 48325 | 492 | 4 |
350170 | 350170 | 2020-07-19 | Medina | Texas | 48325 | 492 | 4 |
346970 | 346970 | 2020-07-18 | Medina | Texas | 48325 | 492 | 4 |
227214 | 227214 | 2020-06-10 | Hays | Texas | 48209 | 492 | 5 |
174979 | 174979 | 2020-05-24 | Jefferson | Texas | 48245 | 492 | 27 |
162929 | 162929 | 2020-05-20 | Webb | Texas | 48479 | 492 | 18 |
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);