ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Uvalde" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502439 | 2502439 | 2022-05-13 | Uvalde | Texas | 48463 | 10600 | 145 |
2499181 | 2499181 | 2022-05-12 | Uvalde | Texas | 48463 | 10598 | 145 |
2495923 | 2495923 | 2022-05-11 | Uvalde | Texas | 48463 | 10598 | 145 |
2492665 | 2492665 | 2022-05-10 | Uvalde | Texas | 48463 | 10598 | 145 |
2489407 | 2489407 | 2022-05-09 | Uvalde | Texas | 48463 | 10598 | 145 |
2486149 | 2486149 | 2022-05-08 | Uvalde | Texas | 48463 | 10598 | 145 |
2482891 | 2482891 | 2022-05-07 | Uvalde | Texas | 48463 | 10598 | 145 |
2479633 | 2479633 | 2022-05-06 | Uvalde | Texas | 48463 | 10597 | 145 |
2476375 | 2476375 | 2022-05-05 | Uvalde | Texas | 48463 | 10594 | 144 |
2473118 | 2473118 | 2022-05-04 | Uvalde | Texas | 48463 | 10594 | 144 |
2469862 | 2469862 | 2022-05-03 | Uvalde | Texas | 48463 | 10592 | 144 |
2466606 | 2466606 | 2022-05-02 | Uvalde | Texas | 48463 | 10592 | 144 |
2463351 | 2463351 | 2022-05-01 | Uvalde | Texas | 48463 | 10591 | 144 |
2460095 | 2460095 | 2022-04-30 | Uvalde | Texas | 48463 | 10589 | 144 |
2456839 | 2456839 | 2022-04-29 | Uvalde | Texas | 48463 | 10589 | 144 |
2453583 | 2453583 | 2022-04-28 | Uvalde | Texas | 48463 | 10589 | 144 |
2450327 | 2450327 | 2022-04-27 | Uvalde | Texas | 48463 | 10586 | 144 |
2447070 | 2447070 | 2022-04-26 | Uvalde | Texas | 48463 | 10586 | 143 |
2443815 | 2443815 | 2022-04-25 | Uvalde | Texas | 48463 | 10586 | 143 |
2440559 | 2440559 | 2022-04-24 | Uvalde | Texas | 48463 | 10585 | 143 |
2437303 | 2437303 | 2022-04-23 | Uvalde | Texas | 48463 | 10585 | 143 |
2434047 | 2434047 | 2022-04-22 | Uvalde | Texas | 48463 | 10585 | 143 |
2430791 | 2430791 | 2022-04-21 | Uvalde | Texas | 48463 | 10585 | 143 |
2427535 | 2427535 | 2022-04-20 | Uvalde | Texas | 48463 | 10580 | 143 |
2424279 | 2424279 | 2022-04-19 | Uvalde | Texas | 48463 | 10580 | 143 |
2421023 | 2421023 | 2022-04-18 | Uvalde | Texas | 48463 | 10579 | 143 |
2417767 | 2417767 | 2022-04-17 | Uvalde | Texas | 48463 | 10577 | 143 |
2414511 | 2414511 | 2022-04-16 | Uvalde | Texas | 48463 | 10577 | 143 |
2411255 | 2411255 | 2022-04-15 | Uvalde | Texas | 48463 | 10577 | 143 |
2407999 | 2407999 | 2022-04-14 | Uvalde | Texas | 48463 | 10577 | 143 |
2404743 | 2404743 | 2022-04-13 | Uvalde | Texas | 48463 | 10577 | 143 |
2401488 | 2401488 | 2022-04-12 | Uvalde | Texas | 48463 | 10575 | 143 |
2398233 | 2398233 | 2022-04-11 | Uvalde | Texas | 48463 | 10574 | 143 |
2394978 | 2394978 | 2022-04-10 | Uvalde | Texas | 48463 | 10574 | 143 |
2391722 | 2391722 | 2022-04-09 | Uvalde | Texas | 48463 | 10574 | 143 |
2388466 | 2388466 | 2022-04-08 | Uvalde | Texas | 48463 | 10574 | 143 |
2385211 | 2385211 | 2022-04-07 | Uvalde | Texas | 48463 | 10568 | 142 |
2381956 | 2381956 | 2022-04-06 | Uvalde | Texas | 48463 | 10568 | 142 |
2378701 | 2378701 | 2022-04-05 | Uvalde | Texas | 48463 | 10568 | 142 |
2375447 | 2375447 | 2022-04-04 | Uvalde | Texas | 48463 | 10567 | 142 |
2372195 | 2372195 | 2022-04-03 | Uvalde | Texas | 48463 | 10566 | 142 |
2368942 | 2368942 | 2022-04-02 | Uvalde | Texas | 48463 | 10566 | 142 |
2365689 | 2365689 | 2022-04-01 | Uvalde | Texas | 48463 | 10566 | 142 |
2362436 | 2362436 | 2022-03-31 | Uvalde | Texas | 48463 | 10565 | 142 |
2359182 | 2359182 | 2022-03-30 | Uvalde | Texas | 48463 | 10563 | 142 |
2355928 | 2355928 | 2022-03-29 | Uvalde | Texas | 48463 | 10563 | 142 |
2352675 | 2352675 | 2022-03-28 | Uvalde | Texas | 48463 | 10563 | 142 |
2349423 | 2349423 | 2022-03-27 | Uvalde | Texas | 48463 | 10562 | 142 |
2346170 | 2346170 | 2022-03-26 | Uvalde | Texas | 48463 | 10562 | 142 |
2342917 | 2342917 | 2022-03-25 | Uvalde | Texas | 48463 | 10561 | 141 |
2339664 | 2339664 | 2022-03-24 | Uvalde | Texas | 48463 | 10557 | 141 |
2336410 | 2336410 | 2022-03-23 | Uvalde | Texas | 48463 | 10557 | 141 |
2333156 | 2333156 | 2022-03-22 | Uvalde | Texas | 48463 | 10555 | 141 |
2329903 | 2329903 | 2022-03-21 | Uvalde | Texas | 48463 | 10555 | 141 |
2326651 | 2326651 | 2022-03-20 | Uvalde | Texas | 48463 | 10555 | 141 |
2323398 | 2323398 | 2022-03-19 | Uvalde | Texas | 48463 | 10554 | 141 |
2320144 | 2320144 | 2022-03-18 | Uvalde | Texas | 48463 | 10554 | 141 |
2316890 | 2316890 | 2022-03-17 | Uvalde | Texas | 48463 | 10554 | 141 |
2313637 | 2313637 | 2022-03-16 | Uvalde | Texas | 48463 | 10553 | 140 |
2310384 | 2310384 | 2022-03-15 | Uvalde | Texas | 48463 | 10551 | 140 |
2307131 | 2307131 | 2022-03-14 | Uvalde | Texas | 48463 | 10548 | 140 |
2303880 | 2303880 | 2022-03-13 | Uvalde | Texas | 48463 | 10548 | 140 |
2300628 | 2300628 | 2022-03-12 | Uvalde | Texas | 48463 | 10547 | 140 |
2297376 | 2297376 | 2022-03-11 | Uvalde | Texas | 48463 | 10544 | 139 |
2294124 | 2294124 | 2022-03-10 | Uvalde | Texas | 48463 | 10543 | 139 |
2290872 | 2290872 | 2022-03-09 | Uvalde | Texas | 48463 | 10540 | 139 |
2287620 | 2287620 | 2022-03-08 | Uvalde | Texas | 48463 | 10536 | 139 |
2284368 | 2284368 | 2022-03-07 | Uvalde | Texas | 48463 | 10532 | 138 |
2281116 | 2281116 | 2022-03-06 | Uvalde | Texas | 48463 | 10532 | 138 |
2277863 | 2277863 | 2022-03-05 | Uvalde | Texas | 48463 | 10530 | 138 |
2274610 | 2274610 | 2022-03-04 | Uvalde | Texas | 48463 | 10529 | 138 |
2271357 | 2271357 | 2022-03-03 | Uvalde | Texas | 48463 | 10526 | 138 |
2268105 | 2268105 | 2022-03-02 | Uvalde | Texas | 48463 | 10521 | 137 |
2264852 | 2264852 | 2022-03-01 | Uvalde | Texas | 48463 | 10515 | 134 |
2261602 | 2261602 | 2022-02-28 | Uvalde | Texas | 48463 | 10510 | 134 |
2258351 | 2258351 | 2022-02-27 | Uvalde | Texas | 48463 | 10510 | 134 |
2255100 | 2255100 | 2022-02-26 | Uvalde | Texas | 48463 | 10507 | 134 |
2251849 | 2251849 | 2022-02-25 | Uvalde | Texas | 48463 | 10504 | 134 |
2248598 | 2248598 | 2022-02-24 | Uvalde | Texas | 48463 | 10501 | 134 |
2245347 | 2245347 | 2022-02-23 | Uvalde | Texas | 48463 | 10498 | 133 |
2242096 | 2242096 | 2022-02-22 | Uvalde | Texas | 48463 | 10495 | 132 |
2238845 | 2238845 | 2022-02-21 | Uvalde | Texas | 48463 | 10493 | 132 |
2235594 | 2235594 | 2022-02-20 | Uvalde | Texas | 48463 | 10488 | 132 |
2232343 | 2232343 | 2022-02-19 | Uvalde | Texas | 48463 | 10485 | 132 |
2229092 | 2229092 | 2022-02-18 | Uvalde | Texas | 48463 | 10478 | 132 |
2225841 | 2225841 | 2022-02-17 | Uvalde | Texas | 48463 | 10463 | 132 |
2222590 | 2222590 | 2022-02-16 | Uvalde | Texas | 48463 | 10451 | 131 |
2219339 | 2219339 | 2022-02-15 | Uvalde | Texas | 48463 | 10447 | 130 |
2216088 | 2216088 | 2022-02-14 | Uvalde | Texas | 48463 | 10436 | 129 |
2212837 | 2212837 | 2022-02-13 | Uvalde | Texas | 48463 | 10427 | 129 |
2209584 | 2209584 | 2022-02-12 | Uvalde | Texas | 48463 | 10424 | 129 |
2206331 | 2206331 | 2022-02-11 | Uvalde | Texas | 48463 | 10413 | 129 |
2203078 | 2203078 | 2022-02-10 | Uvalde | Texas | 48463 | 10365 | 129 |
2199824 | 2199824 | 2022-02-09 | Uvalde | Texas | 48463 | 10353 | 126 |
2196570 | 2196570 | 2022-02-08 | Uvalde | Texas | 48463 | 10329 | 125 |
2193316 | 2193316 | 2022-02-07 | Uvalde | Texas | 48463 | 10312 | 125 |
2190063 | 2190063 | 2022-02-06 | Uvalde | Texas | 48463 | 10293 | 125 |
2186810 | 2186810 | 2022-02-05 | Uvalde | Texas | 48463 | 10278 | 125 |
2183557 | 2183557 | 2022-02-04 | Uvalde | Texas | 48463 | 10272 | 125 |
2180305 | 2180305 | 2022-02-03 | Uvalde | Texas | 48463 | 10244 | 125 |
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);