ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
700 rows where county = "Schleicher" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502414 | 2502414 | 2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 |
2499156 | 2499156 | 2022-05-12 | Schleicher | Texas | 48413 | 528 | 9 |
2495898 | 2495898 | 2022-05-11 | Schleicher | Texas | 48413 | 528 | 9 |
2492640 | 2492640 | 2022-05-10 | Schleicher | Texas | 48413 | 528 | 9 |
2489382 | 2489382 | 2022-05-09 | Schleicher | Texas | 48413 | 528 | 9 |
2486124 | 2486124 | 2022-05-08 | Schleicher | Texas | 48413 | 527 | 9 |
2482866 | 2482866 | 2022-05-07 | Schleicher | Texas | 48413 | 527 | 9 |
2479608 | 2479608 | 2022-05-06 | Schleicher | Texas | 48413 | 527 | 9 |
2476350 | 2476350 | 2022-05-05 | Schleicher | Texas | 48413 | 527 | 9 |
2473093 | 2473093 | 2022-05-04 | Schleicher | Texas | 48413 | 527 | 9 |
2469837 | 2469837 | 2022-05-03 | Schleicher | Texas | 48413 | 527 | 9 |
2466581 | 2466581 | 2022-05-02 | Schleicher | Texas | 48413 | 527 | 9 |
2463326 | 2463326 | 2022-05-01 | Schleicher | Texas | 48413 | 527 | 9 |
2460070 | 2460070 | 2022-04-30 | Schleicher | Texas | 48413 | 527 | 9 |
2456814 | 2456814 | 2022-04-29 | Schleicher | Texas | 48413 | 527 | 9 |
2453558 | 2453558 | 2022-04-28 | Schleicher | Texas | 48413 | 527 | 9 |
2450302 | 2450302 | 2022-04-27 | Schleicher | Texas | 48413 | 527 | 9 |
2447045 | 2447045 | 2022-04-26 | Schleicher | Texas | 48413 | 527 | 9 |
2443790 | 2443790 | 2022-04-25 | Schleicher | Texas | 48413 | 527 | 9 |
2440534 | 2440534 | 2022-04-24 | Schleicher | Texas | 48413 | 527 | 9 |
2437278 | 2437278 | 2022-04-23 | Schleicher | Texas | 48413 | 527 | 9 |
2434022 | 2434022 | 2022-04-22 | Schleicher | Texas | 48413 | 527 | 9 |
2430766 | 2430766 | 2022-04-21 | Schleicher | Texas | 48413 | 526 | 9 |
2427510 | 2427510 | 2022-04-20 | Schleicher | Texas | 48413 | 526 | 9 |
2424254 | 2424254 | 2022-04-19 | Schleicher | Texas | 48413 | 526 | 9 |
2420998 | 2420998 | 2022-04-18 | Schleicher | Texas | 48413 | 526 | 9 |
2417742 | 2417742 | 2022-04-17 | Schleicher | Texas | 48413 | 525 | 9 |
2414486 | 2414486 | 2022-04-16 | Schleicher | Texas | 48413 | 525 | 9 |
2411230 | 2411230 | 2022-04-15 | Schleicher | Texas | 48413 | 525 | 9 |
2407974 | 2407974 | 2022-04-14 | Schleicher | Texas | 48413 | 525 | 9 |
2404718 | 2404718 | 2022-04-13 | Schleicher | Texas | 48413 | 525 | 9 |
2401463 | 2401463 | 2022-04-12 | Schleicher | Texas | 48413 | 525 | 9 |
2398208 | 2398208 | 2022-04-11 | Schleicher | Texas | 48413 | 525 | 9 |
2394953 | 2394953 | 2022-04-10 | Schleicher | Texas | 48413 | 525 | 9 |
2391697 | 2391697 | 2022-04-09 | Schleicher | Texas | 48413 | 525 | 9 |
2388441 | 2388441 | 2022-04-08 | Schleicher | Texas | 48413 | 525 | 9 |
2385186 | 2385186 | 2022-04-07 | Schleicher | Texas | 48413 | 525 | 9 |
2381931 | 2381931 | 2022-04-06 | Schleicher | Texas | 48413 | 525 | 9 |
2378676 | 2378676 | 2022-04-05 | Schleicher | Texas | 48413 | 523 | 9 |
2375422 | 2375422 | 2022-04-04 | Schleicher | Texas | 48413 | 523 | 9 |
2372170 | 2372170 | 2022-04-03 | Schleicher | Texas | 48413 | 523 | 9 |
2368917 | 2368917 | 2022-04-02 | Schleicher | Texas | 48413 | 523 | 9 |
2365664 | 2365664 | 2022-04-01 | Schleicher | Texas | 48413 | 523 | 9 |
2362411 | 2362411 | 2022-03-31 | Schleicher | Texas | 48413 | 522 | 9 |
2359157 | 2359157 | 2022-03-30 | Schleicher | Texas | 48413 | 522 | 9 |
2355903 | 2355903 | 2022-03-29 | Schleicher | Texas | 48413 | 522 | 9 |
2352650 | 2352650 | 2022-03-28 | Schleicher | Texas | 48413 | 522 | 9 |
2349398 | 2349398 | 2022-03-27 | Schleicher | Texas | 48413 | 522 | 9 |
2346145 | 2346145 | 2022-03-26 | Schleicher | Texas | 48413 | 522 | 9 |
2342892 | 2342892 | 2022-03-25 | Schleicher | Texas | 48413 | 522 | 9 |
2339639 | 2339639 | 2022-03-24 | Schleicher | Texas | 48413 | 521 | 9 |
2336385 | 2336385 | 2022-03-23 | Schleicher | Texas | 48413 | 520 | 9 |
2333131 | 2333131 | 2022-03-22 | Schleicher | Texas | 48413 | 520 | 9 |
2329878 | 2329878 | 2022-03-21 | Schleicher | Texas | 48413 | 520 | 9 |
2326626 | 2326626 | 2022-03-20 | Schleicher | Texas | 48413 | 520 | 9 |
2323373 | 2323373 | 2022-03-19 | Schleicher | Texas | 48413 | 520 | 9 |
2320119 | 2320119 | 2022-03-18 | Schleicher | Texas | 48413 | 520 | 9 |
2316865 | 2316865 | 2022-03-17 | Schleicher | Texas | 48413 | 520 | 9 |
2313612 | 2313612 | 2022-03-16 | Schleicher | Texas | 48413 | 520 | 9 |
2310359 | 2310359 | 2022-03-15 | Schleicher | Texas | 48413 | 520 | 9 |
2307106 | 2307106 | 2022-03-14 | Schleicher | Texas | 48413 | 520 | 9 |
2303855 | 2303855 | 2022-03-13 | Schleicher | Texas | 48413 | 520 | 9 |
2300603 | 2300603 | 2022-03-12 | Schleicher | Texas | 48413 | 520 | 9 |
2297351 | 2297351 | 2022-03-11 | Schleicher | Texas | 48413 | 520 | 9 |
2294099 | 2294099 | 2022-03-10 | Schleicher | Texas | 48413 | 520 | 9 |
2290847 | 2290847 | 2022-03-09 | Schleicher | Texas | 48413 | 520 | 9 |
2287595 | 2287595 | 2022-03-08 | Schleicher | Texas | 48413 | 520 | 9 |
2284343 | 2284343 | 2022-03-07 | Schleicher | Texas | 48413 | 520 | 9 |
2281091 | 2281091 | 2022-03-06 | Schleicher | Texas | 48413 | 520 | 9 |
2277838 | 2277838 | 2022-03-05 | Schleicher | Texas | 48413 | 520 | 9 |
2274585 | 2274585 | 2022-03-04 | Schleicher | Texas | 48413 | 520 | 9 |
2271332 | 2271332 | 2022-03-03 | Schleicher | Texas | 48413 | 520 | 9 |
2268080 | 2268080 | 2022-03-02 | Schleicher | Texas | 48413 | 520 | 9 |
2264827 | 2264827 | 2022-03-01 | Schleicher | Texas | 48413 | 520 | 9 |
2261577 | 2261577 | 2022-02-28 | Schleicher | Texas | 48413 | 520 | 9 |
2258326 | 2258326 | 2022-02-27 | Schleicher | Texas | 48413 | 520 | 9 |
2255075 | 2255075 | 2022-02-26 | Schleicher | Texas | 48413 | 520 | 9 |
2251824 | 2251824 | 2022-02-25 | Schleicher | Texas | 48413 | 520 | 9 |
2248573 | 2248573 | 2022-02-24 | Schleicher | Texas | 48413 | 519 | 9 |
2245322 | 2245322 | 2022-02-23 | Schleicher | Texas | 48413 | 519 | 9 |
2242071 | 2242071 | 2022-02-22 | Schleicher | Texas | 48413 | 519 | 9 |
2238820 | 2238820 | 2022-02-21 | Schleicher | Texas | 48413 | 519 | 9 |
2235569 | 2235569 | 2022-02-20 | Schleicher | Texas | 48413 | 519 | 9 |
2232318 | 2232318 | 2022-02-19 | Schleicher | Texas | 48413 | 519 | 9 |
2229067 | 2229067 | 2022-02-18 | Schleicher | Texas | 48413 | 517 | 9 |
2225816 | 2225816 | 2022-02-17 | Schleicher | Texas | 48413 | 517 | 9 |
2222565 | 2222565 | 2022-02-16 | Schleicher | Texas | 48413 | 517 | 9 |
2219314 | 2219314 | 2022-02-15 | Schleicher | Texas | 48413 | 514 | 9 |
2216063 | 2216063 | 2022-02-14 | Schleicher | Texas | 48413 | 513 | 9 |
2212812 | 2212812 | 2022-02-13 | Schleicher | Texas | 48413 | 513 | 9 |
2209559 | 2209559 | 2022-02-12 | Schleicher | Texas | 48413 | 513 | 9 |
2206306 | 2206306 | 2022-02-11 | Schleicher | Texas | 48413 | 510 | 9 |
2203053 | 2203053 | 2022-02-10 | Schleicher | Texas | 48413 | 506 | 9 |
2199799 | 2199799 | 2022-02-09 | Schleicher | Texas | 48413 | 504 | 9 |
2196545 | 2196545 | 2022-02-08 | Schleicher | Texas | 48413 | 502 | 9 |
2193291 | 2193291 | 2022-02-07 | Schleicher | Texas | 48413 | 500 | 9 |
2190037 | 2190037 | 2022-02-06 | Schleicher | Texas | 48413 | 499 | 9 |
2186784 | 2186784 | 2022-02-05 | Schleicher | Texas | 48413 | 499 | 9 |
2183532 | 2183532 | 2022-02-04 | Schleicher | Texas | 48413 | 497 | 9 |
2180280 | 2180280 | 2022-02-03 | Schleicher | Texas | 48413 | 491 | 9 |
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);