ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,883 rows where county = "Clarke" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434452 | 2434452 | 2022-04-23 | Clarke | Alabama | 1025 | 7142 | 100 |
2434859 | 2434859 | 2022-04-23 | Clarke | Georgia | 13059 | 29700 | 230 |
2435257 | 2435257 | 2022-04-23 | Clarke | Iowa | 19039 | 2264 | 37 |
2435869 | 2435869 | 2022-04-23 | Clarke | Mississippi | 28023 | 4231 | 108 |
2437400 | 2437400 | 2022-04-23 | Clarke | Virginia | 51043 | 2630 | 42 |
2431196 | 2431196 | 2022-04-22 | Clarke | Alabama | 1025 | 7142 | 100 |
2431603 | 2431603 | 2022-04-22 | Clarke | Georgia | 13059 | 29700 | 230 |
2432001 | 2432001 | 2022-04-22 | Clarke | Iowa | 19039 | 2264 | 37 |
2432613 | 2432613 | 2022-04-22 | Clarke | Mississippi | 28023 | 4231 | 108 |
2434144 | 2434144 | 2022-04-22 | Clarke | Virginia | 51043 | 2630 | 42 |
2427940 | 2427940 | 2022-04-21 | Clarke | Alabama | 1025 | 7142 | 100 |
2428347 | 2428347 | 2022-04-21 | Clarke | Georgia | 13059 | 29700 | 230 |
2428745 | 2428745 | 2022-04-21 | Clarke | Iowa | 19039 | 2264 | 37 |
2429357 | 2429357 | 2022-04-21 | Clarke | Mississippi | 28023 | 4231 | 108 |
2430888 | 2430888 | 2022-04-21 | Clarke | Virginia | 51043 | 2626 | 42 |
2424684 | 2424684 | 2022-04-20 | Clarke | Alabama | 1025 | 7142 | 100 |
2425091 | 2425091 | 2022-04-20 | Clarke | Georgia | 13059 | 29700 | 230 |
2425489 | 2425489 | 2022-04-20 | Clarke | Iowa | 19039 | 2264 | 37 |
2426101 | 2426101 | 2022-04-20 | Clarke | Mississippi | 28023 | 4231 | 108 |
2427632 | 2427632 | 2022-04-20 | Clarke | Virginia | 51043 | 2626 | 42 |
2421428 | 2421428 | 2022-04-19 | Clarke | Alabama | 1025 | 7142 | 100 |
2421835 | 2421835 | 2022-04-19 | Clarke | Georgia | 13059 | 29688 | 228 |
2422233 | 2422233 | 2022-04-19 | Clarke | Iowa | 19039 | 2263 | 37 |
2422845 | 2422845 | 2022-04-19 | Clarke | Mississippi | 28023 | 4231 | 108 |
2424376 | 2424376 | 2022-04-19 | Clarke | Virginia | 51043 | 2622 | 42 |
2418172 | 2418172 | 2022-04-18 | Clarke | Alabama | 1025 | 7141 | 100 |
2418579 | 2418579 | 2022-04-18 | Clarke | Georgia | 13059 | 29688 | 228 |
2418977 | 2418977 | 2022-04-18 | Clarke | Iowa | 19039 | 2263 | 37 |
2419589 | 2419589 | 2022-04-18 | Clarke | Mississippi | 28023 | 4231 | 108 |
2421120 | 2421120 | 2022-04-18 | Clarke | Virginia | 51043 | 2620 | 42 |
2414916 | 2414916 | 2022-04-17 | Clarke | Alabama | 1025 | 7141 | 100 |
2415323 | 2415323 | 2022-04-17 | Clarke | Georgia | 13059 | 29687 | 228 |
2415721 | 2415721 | 2022-04-17 | Clarke | Iowa | 19039 | 2263 | 37 |
2416333 | 2416333 | 2022-04-17 | Clarke | Mississippi | 28023 | 4230 | 108 |
2417864 | 2417864 | 2022-04-17 | Clarke | Virginia | 51043 | 2615 | 42 |
2411660 | 2411660 | 2022-04-16 | Clarke | Alabama | 1025 | 7141 | 100 |
2412067 | 2412067 | 2022-04-16 | Clarke | Georgia | 13059 | 29687 | 228 |
2412465 | 2412465 | 2022-04-16 | Clarke | Iowa | 19039 | 2263 | 37 |
2413077 | 2413077 | 2022-04-16 | Clarke | Mississippi | 28023 | 4230 | 108 |
2414608 | 2414608 | 2022-04-16 | Clarke | Virginia | 51043 | 2615 | 42 |
2408404 | 2408404 | 2022-04-15 | Clarke | Alabama | 1025 | 7141 | 100 |
2408811 | 2408811 | 2022-04-15 | Clarke | Georgia | 13059 | 29687 | 228 |
2409209 | 2409209 | 2022-04-15 | Clarke | Iowa | 19039 | 2263 | 37 |
2409821 | 2409821 | 2022-04-15 | Clarke | Mississippi | 28023 | 4230 | 108 |
2411352 | 2411352 | 2022-04-15 | Clarke | Virginia | 51043 | 2615 | 42 |
2405148 | 2405148 | 2022-04-14 | Clarke | Alabama | 1025 | 7141 | 100 |
2405555 | 2405555 | 2022-04-14 | Clarke | Georgia | 13059 | 29675 | 227 |
2405953 | 2405953 | 2022-04-14 | Clarke | Iowa | 19039 | 2263 | 37 |
2406565 | 2406565 | 2022-04-14 | Clarke | Mississippi | 28023 | 4230 | 108 |
2408096 | 2408096 | 2022-04-14 | Clarke | Virginia | 51043 | 2614 | 42 |
2401893 | 2401893 | 2022-04-13 | Clarke | Alabama | 1025 | 7140 | 100 |
2402300 | 2402300 | 2022-04-13 | Clarke | Georgia | 13059 | 29671 | 226 |
2402697 | 2402697 | 2022-04-13 | Clarke | Iowa | 19039 | 2263 | 37 |
2403309 | 2403309 | 2022-04-13 | Clarke | Mississippi | 28023 | 4230 | 108 |
2404840 | 2404840 | 2022-04-13 | Clarke | Virginia | 51043 | 2615 | 42 |
2398638 | 2398638 | 2022-04-12 | Clarke | Alabama | 1025 | 7140 | 99 |
2399045 | 2399045 | 2022-04-12 | Clarke | Georgia | 13059 | 29666 | 226 |
2399443 | 2399443 | 2022-04-12 | Clarke | Iowa | 19039 | 2262 | 37 |
2400055 | 2400055 | 2022-04-12 | Clarke | Mississippi | 28023 | 4230 | 108 |
2401585 | 2401585 | 2022-04-12 | Clarke | Virginia | 51043 | 2614 | 42 |
2395383 | 2395383 | 2022-04-11 | Clarke | Alabama | 1025 | 7140 | 99 |
2395790 | 2395790 | 2022-04-11 | Clarke | Georgia | 13059 | 29662 | 226 |
2396187 | 2396187 | 2022-04-11 | Clarke | Iowa | 19039 | 2262 | 37 |
2396799 | 2396799 | 2022-04-11 | Clarke | Mississippi | 28023 | 4227 | 108 |
2398330 | 2398330 | 2022-04-11 | Clarke | Virginia | 51043 | 2611 | 42 |
2392127 | 2392127 | 2022-04-10 | Clarke | Alabama | 1025 | 7141 | 99 |
2392534 | 2392534 | 2022-04-10 | Clarke | Georgia | 13059 | 29651 | 226 |
2392932 | 2392932 | 2022-04-10 | Clarke | Iowa | 19039 | 2262 | 37 |
2393544 | 2393544 | 2022-04-10 | Clarke | Mississippi | 28023 | 4227 | 108 |
2395075 | 2395075 | 2022-04-10 | Clarke | Virginia | 51043 | 2604 | 42 |
2388871 | 2388871 | 2022-04-09 | Clarke | Alabama | 1025 | 7141 | 99 |
2389278 | 2389278 | 2022-04-09 | Clarke | Georgia | 13059 | 29651 | 226 |
2389676 | 2389676 | 2022-04-09 | Clarke | Iowa | 19039 | 2262 | 37 |
2390288 | 2390288 | 2022-04-09 | Clarke | Mississippi | 28023 | 4227 | 108 |
2391819 | 2391819 | 2022-04-09 | Clarke | Virginia | 51043 | 2604 | 42 |
2385616 | 2385616 | 2022-04-08 | Clarke | Alabama | 1025 | 7141 | 99 |
2386023 | 2386023 | 2022-04-08 | Clarke | Georgia | 13059 | 29651 | 226 |
2386420 | 2386420 | 2022-04-08 | Clarke | Iowa | 19039 | 2262 | 37 |
2387032 | 2387032 | 2022-04-08 | Clarke | Mississippi | 28023 | 4227 | 108 |
2388563 | 2388563 | 2022-04-08 | Clarke | Virginia | 51043 | 2604 | 42 |
2382361 | 2382361 | 2022-04-07 | Clarke | Alabama | 1025 | 7141 | 99 |
2382768 | 2382768 | 2022-04-07 | Clarke | Georgia | 13059 | 29651 | 226 |
2383166 | 2383166 | 2022-04-07 | Clarke | Iowa | 19039 | 2262 | 37 |
2383777 | 2383777 | 2022-04-07 | Clarke | Mississippi | 28023 | 4227 | 108 |
2385308 | 2385308 | 2022-04-07 | Clarke | Virginia | 51043 | 2602 | 42 |
2379106 | 2379106 | 2022-04-06 | Clarke | Alabama | 1025 | 7127 | 99 |
2379513 | 2379513 | 2022-04-06 | Clarke | Georgia | 13059 | 29647 | 226 |
2379911 | 2379911 | 2022-04-06 | Clarke | Iowa | 19039 | 2262 | 37 |
2380522 | 2380522 | 2022-04-06 | Clarke | Mississippi | 28023 | 4227 | 108 |
2382053 | 2382053 | 2022-04-06 | Clarke | Virginia | 51043 | 2600 | 41 |
2375852 | 2375852 | 2022-04-05 | Clarke | Alabama | 1025 | 7123 | 99 |
2376259 | 2376259 | 2022-04-05 | Clarke | Georgia | 13059 | 29642 | 224 |
2376656 | 2376656 | 2022-04-05 | Clarke | Iowa | 19039 | 2258 | 37 |
2377267 | 2377267 | 2022-04-05 | Clarke | Mississippi | 28023 | 4227 | 108 |
2378798 | 2378798 | 2022-04-05 | Clarke | Virginia | 51043 | 2600 | 41 |
2372600 | 2372600 | 2022-04-04 | Clarke | Alabama | 1025 | 7119 | 99 |
2373007 | 2373007 | 2022-04-04 | Clarke | Georgia | 13059 | 29637 | 225 |
2373404 | 2373404 | 2022-04-04 | Clarke | Iowa | 19039 | 2258 | 37 |
2374015 | 2374015 | 2022-04-04 | Clarke | Mississippi | 28023 | 4227 | 108 |
2375544 | 2375544 | 2022-04-04 | Clarke | Virginia | 51043 | 2599 | 41 |
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);