ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,515 rows where county = "Ward" 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 |
---|---|---|---|---|---|---|---|
2501637 | 2501637 | 2022-05-13 | Ward | North Dakota | 38101 | 20887 | 251 |
2502445 | 2502445 | 2022-05-13 | Ward | Texas | 48475 | 2830 | 44 |
2498379 | 2498379 | 2022-05-12 | Ward | North Dakota | 38101 | 20847 | 251 |
2499187 | 2499187 | 2022-05-12 | Ward | Texas | 48475 | 2830 | 44 |
2495121 | 2495121 | 2022-05-11 | Ward | North Dakota | 38101 | 20847 | 251 |
2495929 | 2495929 | 2022-05-11 | Ward | Texas | 48475 | 2829 | 44 |
2491863 | 2491863 | 2022-05-10 | Ward | North Dakota | 38101 | 20847 | 251 |
2492671 | 2492671 | 2022-05-10 | Ward | Texas | 48475 | 2829 | 44 |
2488605 | 2488605 | 2022-05-09 | Ward | North Dakota | 38101 | 20847 | 251 |
2489413 | 2489413 | 2022-05-09 | Ward | Texas | 48475 | 2829 | 43 |
2485348 | 2485348 | 2022-05-08 | Ward | North Dakota | 38101 | 20847 | 251 |
2486155 | 2486155 | 2022-05-08 | Ward | Texas | 48475 | 2829 | 43 |
2482090 | 2482090 | 2022-05-07 | Ward | North Dakota | 38101 | 20847 | 251 |
2482897 | 2482897 | 2022-05-07 | Ward | Texas | 48475 | 2829 | 43 |
2478832 | 2478832 | 2022-05-06 | Ward | North Dakota | 38101 | 20847 | 251 |
2479639 | 2479639 | 2022-05-06 | Ward | Texas | 48475 | 2829 | 43 |
2475574 | 2475574 | 2022-05-05 | Ward | North Dakota | 38101 | 20821 | 251 |
2476381 | 2476381 | 2022-05-05 | Ward | Texas | 48475 | 2829 | 43 |
2472317 | 2472317 | 2022-05-04 | Ward | North Dakota | 38101 | 20821 | 251 |
2473124 | 2473124 | 2022-05-04 | Ward | Texas | 48475 | 2829 | 43 |
2469061 | 2469061 | 2022-05-03 | Ward | North Dakota | 38101 | 20821 | 251 |
2469868 | 2469868 | 2022-05-03 | Ward | Texas | 48475 | 2829 | 43 |
2465805 | 2465805 | 2022-05-02 | Ward | North Dakota | 38101 | 20821 | 251 |
2466612 | 2466612 | 2022-05-02 | Ward | Texas | 48475 | 2829 | 43 |
2462550 | 2462550 | 2022-05-01 | Ward | North Dakota | 38101 | 20821 | 251 |
2463357 | 2463357 | 2022-05-01 | Ward | Texas | 48475 | 2829 | 43 |
2459294 | 2459294 | 2022-04-30 | Ward | North Dakota | 38101 | 20821 | 251 |
2460101 | 2460101 | 2022-04-30 | Ward | Texas | 48475 | 2829 | 43 |
2456038 | 2456038 | 2022-04-29 | Ward | North Dakota | 38101 | 20821 | 251 |
2456845 | 2456845 | 2022-04-29 | Ward | Texas | 48475 | 2829 | 43 |
2452782 | 2452782 | 2022-04-28 | Ward | North Dakota | 38101 | 20802 | 251 |
2453589 | 2453589 | 2022-04-28 | Ward | Texas | 48475 | 2829 | 43 |
2449526 | 2449526 | 2022-04-27 | Ward | North Dakota | 38101 | 20802 | 251 |
2450333 | 2450333 | 2022-04-27 | Ward | Texas | 48475 | 2828 | 43 |
2446269 | 2446269 | 2022-04-26 | Ward | North Dakota | 38101 | 20802 | 251 |
2447076 | 2447076 | 2022-04-26 | Ward | Texas | 48475 | 2828 | 43 |
2443014 | 2443014 | 2022-04-25 | Ward | North Dakota | 38101 | 20802 | 251 |
2443821 | 2443821 | 2022-04-25 | Ward | Texas | 48475 | 2828 | 43 |
2439758 | 2439758 | 2022-04-24 | Ward | North Dakota | 38101 | 20802 | 251 |
2440565 | 2440565 | 2022-04-24 | Ward | Texas | 48475 | 2828 | 43 |
2436502 | 2436502 | 2022-04-23 | Ward | North Dakota | 38101 | 20802 | 251 |
2437309 | 2437309 | 2022-04-23 | Ward | Texas | 48475 | 2828 | 43 |
2433246 | 2433246 | 2022-04-22 | Ward | North Dakota | 38101 | 20802 | 251 |
2434053 | 2434053 | 2022-04-22 | Ward | Texas | 48475 | 2828 | 43 |
2429990 | 2429990 | 2022-04-21 | Ward | North Dakota | 38101 | 20784 | 251 |
2430797 | 2430797 | 2022-04-21 | Ward | Texas | 48475 | 2828 | 43 |
2426734 | 2426734 | 2022-04-20 | Ward | North Dakota | 38101 | 20784 | 251 |
2427541 | 2427541 | 2022-04-20 | Ward | Texas | 48475 | 2827 | 43 |
2423478 | 2423478 | 2022-04-19 | Ward | North Dakota | 38101 | 20784 | 251 |
2424285 | 2424285 | 2022-04-19 | Ward | Texas | 48475 | 2827 | 43 |
2420221 | 2420221 | 2022-04-18 | Ward | North Dakota | 38101 | 20784 | 251 |
2421029 | 2421029 | 2022-04-18 | Ward | Texas | 48475 | 2827 | 43 |
2416966 | 2416966 | 2022-04-17 | Ward | North Dakota | 38101 | 20784 | 251 |
2417773 | 2417773 | 2022-04-17 | Ward | Texas | 48475 | 2822 | 43 |
2413710 | 2413710 | 2022-04-16 | Ward | North Dakota | 38101 | 20784 | 251 |
2414517 | 2414517 | 2022-04-16 | Ward | Texas | 48475 | 2822 | 43 |
2410454 | 2410454 | 2022-04-15 | Ward | North Dakota | 38101 | 20784 | 251 |
2411261 | 2411261 | 2022-04-15 | Ward | Texas | 48475 | 2822 | 43 |
2407198 | 2407198 | 2022-04-14 | Ward | North Dakota | 38101 | 20770 | 251 |
2408005 | 2408005 | 2022-04-14 | Ward | Texas | 48475 | 2822 | 43 |
2403942 | 2403942 | 2022-04-13 | Ward | North Dakota | 38101 | 20770 | 251 |
2404749 | 2404749 | 2022-04-13 | Ward | Texas | 48475 | 2822 | 43 |
2400687 | 2400687 | 2022-04-12 | Ward | North Dakota | 38101 | 20770 | 251 |
2401494 | 2401494 | 2022-04-12 | Ward | Texas | 48475 | 2822 | 43 |
2397432 | 2397432 | 2022-04-11 | Ward | North Dakota | 38101 | 20770 | 251 |
2398239 | 2398239 | 2022-04-11 | Ward | Texas | 48475 | 2821 | 43 |
2394177 | 2394177 | 2022-04-10 | Ward | North Dakota | 38101 | 20770 | 251 |
2394984 | 2394984 | 2022-04-10 | Ward | Texas | 48475 | 2821 | 43 |
2390921 | 2390921 | 2022-04-09 | Ward | North Dakota | 38101 | 20770 | 251 |
2391728 | 2391728 | 2022-04-09 | Ward | Texas | 48475 | 2820 | 43 |
2387665 | 2387665 | 2022-04-08 | Ward | North Dakota | 38101 | 20770 | 251 |
2388472 | 2388472 | 2022-04-08 | Ward | Texas | 48475 | 2820 | 43 |
2384410 | 2384410 | 2022-04-07 | Ward | North Dakota | 38101 | 20740 | 251 |
2385217 | 2385217 | 2022-04-07 | Ward | Texas | 48475 | 2819 | 43 |
2381155 | 2381155 | 2022-04-06 | Ward | North Dakota | 38101 | 20740 | 251 |
2381962 | 2381962 | 2022-04-06 | Ward | Texas | 48475 | 2818 | 43 |
2377900 | 2377900 | 2022-04-05 | Ward | North Dakota | 38101 | 20740 | 251 |
2378707 | 2378707 | 2022-04-05 | Ward | Texas | 48475 | 2818 | 43 |
2374647 | 2374647 | 2022-04-04 | Ward | North Dakota | 38101 | 20740 | 251 |
2375453 | 2375453 | 2022-04-04 | Ward | Texas | 48475 | 2818 | 43 |
2371395 | 2371395 | 2022-04-03 | Ward | North Dakota | 38101 | 20740 | 251 |
2372201 | 2372201 | 2022-04-03 | Ward | Texas | 48475 | 2818 | 43 |
2368142 | 2368142 | 2022-04-02 | Ward | North Dakota | 38101 | 20740 | 251 |
2368948 | 2368948 | 2022-04-02 | Ward | Texas | 48475 | 2818 | 43 |
2364889 | 2364889 | 2022-04-01 | Ward | North Dakota | 38101 | 20740 | 251 |
2365695 | 2365695 | 2022-04-01 | Ward | Texas | 48475 | 2818 | 43 |
2361635 | 2361635 | 2022-03-31 | Ward | North Dakota | 38101 | 20716 | 251 |
2362442 | 2362442 | 2022-03-31 | Ward | Texas | 48475 | 2818 | 43 |
2358381 | 2358381 | 2022-03-30 | Ward | North Dakota | 38101 | 20716 | 251 |
2359188 | 2359188 | 2022-03-30 | Ward | Texas | 48475 | 2818 | 43 |
2355127 | 2355127 | 2022-03-29 | Ward | North Dakota | 38101 | 20716 | 251 |
2355934 | 2355934 | 2022-03-29 | Ward | Texas | 48475 | 2818 | 43 |
2351874 | 2351874 | 2022-03-28 | Ward | North Dakota | 38101 | 20716 | 251 |
2352681 | 2352681 | 2022-03-28 | Ward | Texas | 48475 | 2818 | 43 |
2348622 | 2348622 | 2022-03-27 | Ward | North Dakota | 38101 | 20716 | 251 |
2349429 | 2349429 | 2022-03-27 | Ward | Texas | 48475 | 2817 | 43 |
2345369 | 2345369 | 2022-03-26 | Ward | North Dakota | 38101 | 20716 | 251 |
2346176 | 2346176 | 2022-03-26 | Ward | Texas | 48475 | 2817 | 43 |
2342116 | 2342116 | 2022-03-25 | Ward | North Dakota | 38101 | 20716 | 251 |
2342923 | 2342923 | 2022-03-25 | Ward | Texas | 48475 | 2815 | 43 |
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);