ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
387 rows where deaths = 99 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502265 | 2502265 | 2022-05-13 | DeWitt | Texas | 48123 | 6486 | 99 |
2502295 | 2502295 | 2022-05-13 | Gonzales | Texas | 48177 | 4736 | 99 |
2502383 | 2502383 | 2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 |
2499007 | 2499007 | 2022-05-12 | DeWitt | Texas | 48123 | 6486 | 99 |
2499037 | 2499037 | 2022-05-12 | Gonzales | Texas | 48177 | 4736 | 99 |
2499125 | 2499125 | 2022-05-12 | Nolan | Texas | 48353 | 3065 | 99 |
2495749 | 2495749 | 2022-05-11 | DeWitt | Texas | 48123 | 6484 | 99 |
2495779 | 2495779 | 2022-05-11 | Gonzales | Texas | 48177 | 4736 | 99 |
2495867 | 2495867 | 2022-05-11 | Nolan | Texas | 48353 | 3065 | 99 |
2492491 | 2492491 | 2022-05-10 | DeWitt | Texas | 48123 | 6484 | 99 |
2492521 | 2492521 | 2022-05-10 | Gonzales | Texas | 48177 | 4736 | 99 |
2492609 | 2492609 | 2022-05-10 | Nolan | Texas | 48353 | 3064 | 99 |
2489233 | 2489233 | 2022-05-09 | DeWitt | Texas | 48123 | 6481 | 99 |
2489263 | 2489263 | 2022-05-09 | Gonzales | Texas | 48177 | 4735 | 99 |
2489351 | 2489351 | 2022-05-09 | Nolan | Texas | 48353 | 3064 | 99 |
2485976 | 2485976 | 2022-05-08 | DeWitt | Texas | 48123 | 6481 | 99 |
2486006 | 2486006 | 2022-05-08 | Gonzales | Texas | 48177 | 4731 | 99 |
2486094 | 2486094 | 2022-05-08 | Nolan | Texas | 48353 | 3064 | 99 |
2482718 | 2482718 | 2022-05-07 | DeWitt | Texas | 48123 | 6481 | 99 |
2482748 | 2482748 | 2022-05-07 | Gonzales | Texas | 48177 | 4730 | 99 |
2482836 | 2482836 | 2022-05-07 | Nolan | Texas | 48353 | 3064 | 99 |
2479460 | 2479460 | 2022-05-06 | DeWitt | Texas | 48123 | 6480 | 99 |
2479490 | 2479490 | 2022-05-06 | Gonzales | Texas | 48177 | 4729 | 99 |
2479578 | 2479578 | 2022-05-06 | Nolan | Texas | 48353 | 3064 | 99 |
2476202 | 2476202 | 2022-05-05 | DeWitt | Texas | 48123 | 6479 | 99 |
2476232 | 2476232 | 2022-05-05 | Gonzales | Texas | 48177 | 4728 | 99 |
2476320 | 2476320 | 2022-05-05 | Nolan | Texas | 48353 | 3064 | 99 |
2472945 | 2472945 | 2022-05-04 | DeWitt | Texas | 48123 | 6478 | 99 |
2472975 | 2472975 | 2022-05-04 | Gonzales | Texas | 48177 | 4727 | 99 |
2473063 | 2473063 | 2022-05-04 | Nolan | Texas | 48353 | 3064 | 99 |
2469689 | 2469689 | 2022-05-03 | DeWitt | Texas | 48123 | 6478 | 99 |
2469719 | 2469719 | 2022-05-03 | Gonzales | Texas | 48177 | 4727 | 99 |
2469807 | 2469807 | 2022-05-03 | Nolan | Texas | 48353 | 3062 | 99 |
2466433 | 2466433 | 2022-05-02 | DeWitt | Texas | 48123 | 6478 | 99 |
2466463 | 2466463 | 2022-05-02 | Gonzales | Texas | 48177 | 4727 | 99 |
2466551 | 2466551 | 2022-05-02 | Nolan | Texas | 48353 | 3062 | 99 |
2463178 | 2463178 | 2022-05-01 | DeWitt | Texas | 48123 | 6477 | 99 |
2463208 | 2463208 | 2022-05-01 | Gonzales | Texas | 48177 | 4727 | 99 |
2463296 | 2463296 | 2022-05-01 | Nolan | Texas | 48353 | 3062 | 99 |
2459922 | 2459922 | 2022-04-30 | DeWitt | Texas | 48123 | 6477 | 99 |
2459952 | 2459952 | 2022-04-30 | Gonzales | Texas | 48177 | 4727 | 99 |
2460040 | 2460040 | 2022-04-30 | Nolan | Texas | 48353 | 3062 | 99 |
2456666 | 2456666 | 2022-04-29 | DeWitt | Texas | 48123 | 6477 | 99 |
2456696 | 2456696 | 2022-04-29 | Gonzales | Texas | 48177 | 4727 | 99 |
2456784 | 2456784 | 2022-04-29 | Nolan | Texas | 48353 | 3062 | 99 |
2453410 | 2453410 | 2022-04-28 | DeWitt | Texas | 48123 | 6475 | 99 |
2453440 | 2453440 | 2022-04-28 | Gonzales | Texas | 48177 | 4726 | 99 |
2453528 | 2453528 | 2022-04-28 | Nolan | Texas | 48353 | 3062 | 99 |
2450154 | 2450154 | 2022-04-27 | DeWitt | Texas | 48123 | 6475 | 99 |
2450184 | 2450184 | 2022-04-27 | Gonzales | Texas | 48177 | 4724 | 99 |
2450272 | 2450272 | 2022-04-27 | Nolan | Texas | 48353 | 3062 | 99 |
2446897 | 2446897 | 2022-04-26 | DeWitt | Texas | 48123 | 6475 | 99 |
2447015 | 2447015 | 2022-04-26 | Nolan | Texas | 48353 | 3062 | 99 |
2443642 | 2443642 | 2022-04-25 | DeWitt | Texas | 48123 | 6475 | 99 |
2443760 | 2443760 | 2022-04-25 | Nolan | Texas | 48353 | 3062 | 99 |
2440386 | 2440386 | 2022-04-24 | DeWitt | Texas | 48123 | 6475 | 99 |
2440504 | 2440504 | 2022-04-24 | Nolan | Texas | 48353 | 3061 | 99 |
2437130 | 2437130 | 2022-04-23 | DeWitt | Texas | 48123 | 6474 | 99 |
2437248 | 2437248 | 2022-04-23 | Nolan | Texas | 48353 | 3061 | 99 |
2433874 | 2433874 | 2022-04-22 | DeWitt | Texas | 48123 | 6473 | 99 |
2433992 | 2433992 | 2022-04-22 | Nolan | Texas | 48353 | 3061 | 99 |
2430618 | 2430618 | 2022-04-21 | DeWitt | Texas | 48123 | 6472 | 99 |
2430736 | 2430736 | 2022-04-21 | Nolan | Texas | 48353 | 3061 | 99 |
2427362 | 2427362 | 2022-04-20 | DeWitt | Texas | 48123 | 6468 | 99 |
2427480 | 2427480 | 2022-04-20 | Nolan | Texas | 48353 | 3061 | 99 |
2424106 | 2424106 | 2022-04-19 | DeWitt | Texas | 48123 | 6462 | 99 |
2424224 | 2424224 | 2022-04-19 | Nolan | Texas | 48353 | 3061 | 99 |
2420850 | 2420850 | 2022-04-18 | DeWitt | Texas | 48123 | 6462 | 99 |
2420968 | 2420968 | 2022-04-18 | Nolan | Texas | 48353 | 3061 | 99 |
2417594 | 2417594 | 2022-04-17 | DeWitt | Texas | 48123 | 6461 | 99 |
2417712 | 2417712 | 2022-04-17 | Nolan | Texas | 48353 | 3061 | 99 |
2414338 | 2414338 | 2022-04-16 | DeWitt | Texas | 48123 | 6461 | 99 |
2414456 | 2414456 | 2022-04-16 | Nolan | Texas | 48353 | 3061 | 99 |
2411082 | 2411082 | 2022-04-15 | DeWitt | Texas | 48123 | 6461 | 99 |
2411200 | 2411200 | 2022-04-15 | Nolan | Texas | 48353 | 3061 | 99 |
2407826 | 2407826 | 2022-04-14 | DeWitt | Texas | 48123 | 6461 | 99 |
2407944 | 2407944 | 2022-04-14 | Nolan | Texas | 48353 | 3061 | 99 |
2404688 | 2404688 | 2022-04-13 | Nolan | Texas | 48353 | 3061 | 99 |
2401433 | 2401433 | 2022-04-12 | Nolan | Texas | 48353 | 3061 | 99 |
2398178 | 2398178 | 2022-04-11 | Nolan | Texas | 48353 | 3061 | 99 |
2394923 | 2394923 | 2022-04-10 | Nolan | Texas | 48353 | 3061 | 99 |
2391667 | 2391667 | 2022-04-09 | Nolan | Texas | 48353 | 3060 | 99 |
2388411 | 2388411 | 2022-04-08 | Nolan | Texas | 48353 | 3060 | 99 |
2385156 | 2385156 | 2022-04-07 | Nolan | Texas | 48353 | 3060 | 99 |
2381901 | 2381901 | 2022-04-06 | Nolan | Texas | 48353 | 3059 | 99 |
2378646 | 2378646 | 2022-04-05 | Nolan | Texas | 48353 | 3058 | 99 |
2375392 | 2375392 | 2022-04-04 | Nolan | Texas | 48353 | 3058 | 99 |
2372140 | 2372140 | 2022-04-03 | Nolan | Texas | 48353 | 3058 | 99 |
2368887 | 2368887 | 2022-04-02 | Nolan | Texas | 48353 | 3058 | 99 |
2365634 | 2365634 | 2022-04-01 | Nolan | Texas | 48353 | 3058 | 99 |
2362381 | 2362381 | 2022-03-31 | Nolan | Texas | 48353 | 3057 | 99 |
2359127 | 2359127 | 2022-03-30 | Nolan | Texas | 48353 | 3057 | 99 |
2355873 | 2355873 | 2022-03-29 | Nolan | Texas | 48353 | 3057 | 99 |
2352620 | 2352620 | 2022-03-28 | Nolan | Texas | 48353 | 3055 | 99 |
2349368 | 2349368 | 2022-03-27 | Nolan | Texas | 48353 | 3055 | 99 |
2346115 | 2346115 | 2022-03-26 | Nolan | Texas | 48353 | 3055 | 99 |
2342862 | 2342862 | 2022-03-25 | Nolan | Texas | 48353 | 3055 | 99 |
2339609 | 2339609 | 2022-03-24 | Nolan | Texas | 48353 | 3055 | 99 |
2336355 | 2336355 | 2022-03-23 | Nolan | Texas | 48353 | 3055 | 99 |
2333101 | 2333101 | 2022-03-22 | Nolan | Texas | 48353 | 3054 | 99 |
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);