ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

9,259 rows where county = "Clark" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 12

fips 12

county 1

  • Clark · 9,259 ✖
Link rowid date ▲ county state fips cases deaths
2499695 2499695 2022-05-13 Clark Arkansas 5019 5379 79
2500149 2500149 2022-05-13 Clark Idaho 16033 109 1
2500188 2500188 2022-05-13 Clark Illinois 17023 4887 60
2500289 2500289 2022-05-13 Clark Indiana 18019 31580 396
2500485 2500485 2022-05-13 Clark Kansas 20025 504 8
2500603 2500603 2022-05-13 Clark Kentucky 21049 10749 68
2501098 2501098 2022-05-13 Clark Missouri 29045 1597 37
2501345 2501345 2022-05-13 Clark Nevada 32003 543811 8458
2501655 2501655 2022-05-13 Clark Ohio 39023 35217 586
2502056 2502056 2022-05-13 Clark South Dakota 46025 804 9
2502648 2502648 2022-05-13 Clark Washington 53011 91435 804
2502747 2502747 2022-05-13 Clark Wisconsin 55019 7694 122
2496437 2496437 2022-05-12 Clark Arkansas 5019 5377 79
2496891 2496891 2022-05-12 Clark Idaho 16033 109 1
2496930 2496930 2022-05-12 Clark Illinois 17023 4885 60
2497031 2497031 2022-05-12 Clark Indiana 18019 31527 396
2497227 2497227 2022-05-12 Clark Kansas 20025 504 8
2497345 2497345 2022-05-12 Clark Kentucky 21049 10749 68
2497840 2497840 2022-05-12 Clark Missouri 29045 1593 37
2498087 2498087 2022-05-12 Clark Nevada 32003 543811 8458
2498397 2498397 2022-05-12 Clark Ohio 39023 35217 586
2498798 2498798 2022-05-12 Clark South Dakota 46025 804 9
2499390 2499390 2022-05-12 Clark Washington 53011 91106 801
2499489 2499489 2022-05-12 Clark Wisconsin 55019 7688 122
2493179 2493179 2022-05-11 Clark Arkansas 5019 5371 79
2493633 2493633 2022-05-11 Clark Idaho 16033 109 1
2493672 2493672 2022-05-11 Clark Illinois 17023 4881 60
2493773 2493773 2022-05-11 Clark Indiana 18019 31527 396
2493969 2493969 2022-05-11 Clark Kansas 20025 504 8
2494087 2494087 2022-05-11 Clark Kentucky 21049 10749 68
2494582 2494582 2022-05-11 Clark Missouri 29045 1593 37
2494829 2494829 2022-05-11 Clark Nevada 32003 543811 8458
2495139 2495139 2022-05-11 Clark Ohio 39023 35090 585
2495540 2495540 2022-05-11 Clark South Dakota 46025 804 9
2496132 2496132 2022-05-11 Clark Washington 53011 91106 801
2496231 2496231 2022-05-11 Clark Wisconsin 55019 7680 122
2489921 2489921 2022-05-10 Clark Arkansas 5019 5364 79
2490375 2490375 2022-05-10 Clark Idaho 16033 109 1
2490414 2490414 2022-05-10 Clark Illinois 17023 4881 60
2490515 2490515 2022-05-10 Clark Indiana 18019 31461 396
2490711 2490711 2022-05-10 Clark Kansas 20025 504 8
2490829 2490829 2022-05-10 Clark Kentucky 21049 10749 68
2491324 2491324 2022-05-10 Clark Missouri 29045 1593 37
2491571 2491571 2022-05-10 Clark Nevada 32003 541302 8445
2491881 2491881 2022-05-10 Clark Ohio 39023 35090 585
2492282 2492282 2022-05-10 Clark South Dakota 46025 804 9
2492874 2492874 2022-05-10 Clark Washington 53011 90793 800
2492973 2492973 2022-05-10 Clark Wisconsin 55019 7678 122
2486664 2486664 2022-05-09 Clark Arkansas 5019 5356 79
2487118 2487118 2022-05-09 Clark Idaho 16033 109 1
2487157 2487157 2022-05-09 Clark Illinois 17023 4875 60
2487258 2487258 2022-05-09 Clark Indiana 18019 31461 396
2487454 2487454 2022-05-09 Clark Kansas 20025 504 8
2487572 2487572 2022-05-09 Clark Kentucky 21049 10749 68
2488066 2488066 2022-05-09 Clark Missouri 29045 1593 37
2488313 2488313 2022-05-09 Clark Nevada 32003 541302 8445
2488623 2488623 2022-05-09 Clark Ohio 39023 35090 585
2489024 2489024 2022-05-09 Clark South Dakota 46025 804 9
2489616 2489616 2022-05-09 Clark Washington 53011 90793 800
2489715 2489715 2022-05-09 Clark Wisconsin 55019 7670 122
2483406 2483406 2022-05-08 Clark Arkansas 5019 5357 79
2483860 2483860 2022-05-08 Clark Idaho 16033 109 1
2483899 2483899 2022-05-08 Clark Illinois 17023 4870 60
2484000 2484000 2022-05-08 Clark Indiana 18019 31369 396
2484196 2484196 2022-05-08 Clark Kansas 20025 504 8
2484314 2484314 2022-05-08 Clark Kentucky 21049 10690 67
2484809 2484809 2022-05-08 Clark Missouri 29045 1593 37
2485056 2485056 2022-05-08 Clark Nevada 32003 541302 8445
2485366 2485366 2022-05-08 Clark Ohio 39023 35090 585
2485767 2485767 2022-05-08 Clark South Dakota 46025 804 9
2486359 2486359 2022-05-08 Clark Washington 53011 90331 799
2486458 2486458 2022-05-08 Clark Wisconsin 55019 7667 122
2480148 2480148 2022-05-07 Clark Arkansas 5019 5354 79
2480602 2480602 2022-05-07 Clark Idaho 16033 109 1
2480641 2480641 2022-05-07 Clark Illinois 17023 4870 60
2480742 2480742 2022-05-07 Clark Indiana 18019 31369 396
2480938 2480938 2022-05-07 Clark Kansas 20025 504 8
2481056 2481056 2022-05-07 Clark Kentucky 21049 10690 67
2481551 2481551 2022-05-07 Clark Missouri 29045 1593 37
2481798 2481798 2022-05-07 Clark Nevada 32003 541302 8445
2482108 2482108 2022-05-07 Clark Ohio 39023 35090 585
2482509 2482509 2022-05-07 Clark South Dakota 46025 804 9
2483101 2483101 2022-05-07 Clark Washington 53011 90331 799
2483200 2483200 2022-05-07 Clark Wisconsin 55019 7667 122
2476890 2476890 2022-05-06 Clark Arkansas 5019 5349 79
2477344 2477344 2022-05-06 Clark Idaho 16033 109 1
2477383 2477383 2022-05-06 Clark Illinois 17023 4870 60
2477484 2477484 2022-05-06 Clark Indiana 18019 31369 396
2477680 2477680 2022-05-06 Clark Kansas 20025 504 8
2477798 2477798 2022-05-06 Clark Kentucky 21049 10690 67
2478293 2478293 2022-05-06 Clark Missouri 29045 1593 37
2478540 2478540 2022-05-06 Clark Nevada 32003 541302 8445
2478850 2478850 2022-05-06 Clark Ohio 39023 35090 585
2479251 2479251 2022-05-06 Clark South Dakota 46025 804 9
2479843 2479843 2022-05-06 Clark Washington 53011 90331 799
2479942 2479942 2022-05-06 Clark Wisconsin 55019 7667 122
2473632 2473632 2022-05-05 Clark Arkansas 5019 5347 79
2474086 2474086 2022-05-05 Clark Idaho 16033 109 1
2474125 2474125 2022-05-05 Clark Illinois 17023 4870 60
2474226 2474226 2022-05-05 Clark Indiana 18019 31369 396

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);