ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 48381 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 |
---|---|---|---|---|---|---|---|
2502398 | 2502398 | 2022-05-13 | Randall | Texas | 48381 | 38234 | 516 |
2499140 | 2499140 | 2022-05-12 | Randall | Texas | 48381 | 38231 | 516 |
2495882 | 2495882 | 2022-05-11 | Randall | Texas | 48381 | 38228 | 516 |
2492624 | 2492624 | 2022-05-10 | Randall | Texas | 48381 | 38225 | 516 |
2489366 | 2489366 | 2022-05-09 | Randall | Texas | 48381 | 38220 | 516 |
2486108 | 2486108 | 2022-05-08 | Randall | Texas | 48381 | 38219 | 516 |
2482850 | 2482850 | 2022-05-07 | Randall | Texas | 48381 | 38219 | 516 |
2479592 | 2479592 | 2022-05-06 | Randall | Texas | 48381 | 38219 | 516 |
2476334 | 2476334 | 2022-05-05 | Randall | Texas | 48381 | 38219 | 516 |
2473077 | 2473077 | 2022-05-04 | Randall | Texas | 48381 | 38217 | 516 |
2469821 | 2469821 | 2022-05-03 | Randall | Texas | 48381 | 38213 | 516 |
2466565 | 2466565 | 2022-05-02 | Randall | Texas | 48381 | 38207 | 516 |
2463310 | 2463310 | 2022-05-01 | Randall | Texas | 48381 | 38201 | 516 |
2460054 | 2460054 | 2022-04-30 | Randall | Texas | 48381 | 38201 | 516 |
2456798 | 2456798 | 2022-04-29 | Randall | Texas | 48381 | 38201 | 516 |
2453542 | 2453542 | 2022-04-28 | Randall | Texas | 48381 | 38201 | 516 |
2450286 | 2450286 | 2022-04-27 | Randall | Texas | 48381 | 38200 | 516 |
2447029 | 2447029 | 2022-04-26 | Randall | Texas | 48381 | 38196 | 516 |
2443774 | 2443774 | 2022-04-25 | Randall | Texas | 48381 | 38193 | 516 |
2440518 | 2440518 | 2022-04-24 | Randall | Texas | 48381 | 38191 | 516 |
2437262 | 2437262 | 2022-04-23 | Randall | Texas | 48381 | 38191 | 516 |
2434006 | 2434006 | 2022-04-22 | Randall | Texas | 48381 | 38191 | 516 |
2430750 | 2430750 | 2022-04-21 | Randall | Texas | 48381 | 38189 | 516 |
2427494 | 2427494 | 2022-04-20 | Randall | Texas | 48381 | 38182 | 516 |
2424238 | 2424238 | 2022-04-19 | Randall | Texas | 48381 | 38179 | 509 |
2420982 | 2420982 | 2022-04-18 | Randall | Texas | 48381 | 38176 | 507 |
2417726 | 2417726 | 2022-04-17 | Randall | Texas | 48381 | 38165 | 505 |
2414470 | 2414470 | 2022-04-16 | Randall | Texas | 48381 | 38165 | 505 |
2411214 | 2411214 | 2022-04-15 | Randall | Texas | 48381 | 38165 | 505 |
2407958 | 2407958 | 2022-04-14 | Randall | Texas | 48381 | 38153 | 505 |
2404702 | 2404702 | 2022-04-13 | Randall | Texas | 48381 | 38152 | 503 |
2401447 | 2401447 | 2022-04-12 | Randall | Texas | 48381 | 38150 | 500 |
2398192 | 2398192 | 2022-04-11 | Randall | Texas | 48381 | 38148 | 500 |
2394937 | 2394937 | 2022-04-10 | Randall | Texas | 48381 | 38147 | 497 |
2391681 | 2391681 | 2022-04-09 | Randall | Texas | 48381 | 38147 | 497 |
2388425 | 2388425 | 2022-04-08 | Randall | Texas | 48381 | 38147 | 497 |
2385170 | 2385170 | 2022-04-07 | Randall | Texas | 48381 | 38142 | 497 |
2381915 | 2381915 | 2022-04-06 | Randall | Texas | 48381 | 38136 | 497 |
2378660 | 2378660 | 2022-04-05 | Randall | Texas | 48381 | 38134 | 497 |
2375406 | 2375406 | 2022-04-04 | Randall | Texas | 48381 | 38126 | 495 |
2372154 | 2372154 | 2022-04-03 | Randall | Texas | 48381 | 38126 | 491 |
2368901 | 2368901 | 2022-04-02 | Randall | Texas | 48381 | 38126 | 491 |
2365648 | 2365648 | 2022-04-01 | Randall | Texas | 48381 | 38126 | 491 |
2362395 | 2362395 | 2022-03-31 | Randall | Texas | 48381 | 38124 | 491 |
2359141 | 2359141 | 2022-03-30 | Randall | Texas | 48381 | 38116 | 490 |
2355887 | 2355887 | 2022-03-29 | Randall | Texas | 48381 | 38116 | 489 |
2352634 | 2352634 | 2022-03-28 | Randall | Texas | 48381 | 38109 | 488 |
2349382 | 2349382 | 2022-03-27 | Randall | Texas | 48381 | 38107 | 488 |
2346129 | 2346129 | 2022-03-26 | Randall | Texas | 48381 | 38107 | 488 |
2342876 | 2342876 | 2022-03-25 | Randall | Texas | 48381 | 38107 | 488 |
2339623 | 2339623 | 2022-03-24 | Randall | Texas | 48381 | 38098 | 487 |
2336369 | 2336369 | 2022-03-23 | Randall | Texas | 48381 | 38095 | 487 |
2333115 | 2333115 | 2022-03-22 | Randall | Texas | 48381 | 38147 | 487 |
2329862 | 2329862 | 2022-03-21 | Randall | Texas | 48381 | 38140 | 487 |
2326610 | 2326610 | 2022-03-20 | Randall | Texas | 48381 | 37608 | 487 |
2323357 | 2323357 | 2022-03-19 | Randall | Texas | 48381 | 37608 | 487 |
2320103 | 2320103 | 2022-03-18 | Randall | Texas | 48381 | 37608 | 485 |
2316849 | 2316849 | 2022-03-17 | Randall | Texas | 48381 | 37603 | 485 |
2313596 | 2313596 | 2022-03-16 | Randall | Texas | 48381 | 37603 | 485 |
2310343 | 2310343 | 2022-03-15 | Randall | Texas | 48381 | 37593 | 485 |
2307090 | 2307090 | 2022-03-14 | Randall | Texas | 48381 | 37580 | 483 |
2303839 | 2303839 | 2022-03-13 | Randall | Texas | 48381 | 37580 | 482 |
2300587 | 2300587 | 2022-03-12 | Randall | Texas | 48381 | 37580 | 481 |
2297335 | 2297335 | 2022-03-11 | Randall | Texas | 48381 | 37580 | 479 |
2294083 | 2294083 | 2022-03-10 | Randall | Texas | 48381 | 37575 | 479 |
2290831 | 2290831 | 2022-03-09 | Randall | Texas | 48381 | 37573 | 478 |
2287579 | 2287579 | 2022-03-08 | Randall | Texas | 48381 | 37568 | 478 |
2284327 | 2284327 | 2022-03-07 | Randall | Texas | 48381 | 37554 | 478 |
2281075 | 2281075 | 2022-03-06 | Randall | Texas | 48381 | 37548 | 478 |
2277822 | 2277822 | 2022-03-05 | Randall | Texas | 48381 | 37548 | 478 |
2274569 | 2274569 | 2022-03-04 | Randall | Texas | 48381 | 37548 | 475 |
2271316 | 2271316 | 2022-03-03 | Randall | Texas | 48381 | 37536 | 474 |
2268064 | 2268064 | 2022-03-02 | Randall | Texas | 48381 | 37525 | 473 |
2264811 | 2264811 | 2022-03-01 | Randall | Texas | 48381 | 37487 | 470 |
2261561 | 2261561 | 2022-02-28 | Randall | Texas | 48381 | 37487 | 469 |
2258310 | 2258310 | 2022-02-27 | Randall | Texas | 48381 | 37478 | 469 |
2255059 | 2255059 | 2022-02-26 | Randall | Texas | 48381 | 37478 | 469 |
2251808 | 2251808 | 2022-02-25 | Randall | Texas | 48381 | 37478 | 468 |
2248557 | 2248557 | 2022-02-24 | Randall | Texas | 48381 | 37470 | 468 |
2245306 | 2245306 | 2022-02-23 | Randall | Texas | 48381 | 37457 | 468 |
2242055 | 2242055 | 2022-02-22 | Randall | Texas | 48381 | 37445 | 468 |
2238804 | 2238804 | 2022-02-21 | Randall | Texas | 48381 | 37423 | 468 |
2235553 | 2235553 | 2022-02-20 | Randall | Texas | 48381 | 37399 | 468 |
2232302 | 2232302 | 2022-02-19 | Randall | Texas | 48381 | 37399 | 468 |
2229051 | 2229051 | 2022-02-18 | Randall | Texas | 48381 | 37399 | 467 |
2225800 | 2225800 | 2022-02-17 | Randall | Texas | 48381 | 37383 | 464 |
2222549 | 2222549 | 2022-02-16 | Randall | Texas | 48381 | 37347 | 460 |
2219298 | 2219298 | 2022-02-15 | Randall | Texas | 48381 | 37324 | 457 |
2216047 | 2216047 | 2022-02-14 | Randall | Texas | 48381 | 37256 | 455 |
2212796 | 2212796 | 2022-02-13 | Randall | Texas | 48381 | 37226 | 454 |
2209543 | 2209543 | 2022-02-12 | Randall | Texas | 48381 | 37226 | 454 |
2206290 | 2206290 | 2022-02-11 | Randall | Texas | 48381 | 37226 | 454 |
2203037 | 2203037 | 2022-02-10 | Randall | Texas | 48381 | 37119 | 453 |
2199783 | 2199783 | 2022-02-09 | Randall | Texas | 48381 | 37021 | 452 |
2196529 | 2196529 | 2022-02-08 | Randall | Texas | 48381 | 36898 | 451 |
2193275 | 2193275 | 2022-02-07 | Randall | Texas | 48381 | 36749 | 450 |
2190021 | 2190021 | 2022-02-06 | Randall | Texas | 48381 | 36539 | 450 |
2186768 | 2186768 | 2022-02-05 | Randall | Texas | 48381 | 36539 | 450 |
2183516 | 2183516 | 2022-02-04 | Randall | Texas | 48381 | 36539 | 444 |
2180264 | 2180264 | 2022-02-03 | Randall | Texas | 48381 | 36335 | 442 |
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);