ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,259 rows where county = "Clark" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
306145 | 306145 | 2020-07-06 | Clark | Arkansas | 5019 | 59 | 0 |
306630 | 306630 | 2020-07-06 | Clark | Illinois | 17023 | 15 | 0 |
306731 | 306731 | 2020-07-06 | Clark | Indiana | 18019 | 667 | 51 |
306926 | 306926 | 2020-07-06 | Clark | Kansas | 20025 | 34 | 1 |
307036 | 307036 | 2020-07-06 | Clark | Kentucky | 21049 | 102 | 5 |
307529 | 307529 | 2020-07-06 | Clark | Missouri | 29045 | 2 | 0 |
307743 | 307743 | 2020-07-06 | Clark | Nevada | 32003 | 18818 | 439 |
308041 | 308041 | 2020-07-06 | Clark | Ohio | 39023 | 766 | 9 |
308437 | 308437 | 2020-07-06 | Clark | South Dakota | 46025 | 15 | 0 |
309014 | 309014 | 2020-07-06 | Clark | Washington | 53011 | 1008 | 30 |
309110 | 309110 | 2020-07-06 | Clark | Wisconsin | 55019 | 87 | 7 |
302981 | 302981 | 2020-07-05 | Clark | Arkansas | 5019 | 58 | 0 |
303465 | 303465 | 2020-07-05 | Clark | Illinois | 17023 | 15 | 0 |
303566 | 303566 | 2020-07-05 | Clark | Indiana | 18019 | 663 | 51 |
303761 | 303761 | 2020-07-05 | Clark | Kansas | 20025 | 34 | 1 |
303869 | 303869 | 2020-07-05 | Clark | Kentucky | 21049 | 99 | 5 |
304362 | 304362 | 2020-07-05 | Clark | Missouri | 29045 | 2 | 0 |
304576 | 304576 | 2020-07-05 | Clark | Nevada | 32003 | 18442 | 439 |
304874 | 304874 | 2020-07-05 | Clark | Ohio | 39023 | 765 | 9 |
305270 | 305270 | 2020-07-05 | Clark | South Dakota | 46025 | 15 | 0 |
305846 | 305846 | 2020-07-05 | Clark | Washington | 53011 | 922 | 30 |
305941 | 305941 | 2020-07-05 | Clark | Wisconsin | 55019 | 87 | 7 |
299817 | 299817 | 2020-07-04 | Clark | Arkansas | 5019 | 58 | 0 |
300301 | 300301 | 2020-07-04 | Clark | Illinois | 17023 | 15 | 0 |
300402 | 300402 | 2020-07-04 | Clark | Indiana | 18019 | 652 | 51 |
300597 | 300597 | 2020-07-04 | Clark | Kansas | 20025 | 34 | 0 |
300705 | 300705 | 2020-07-04 | Clark | Kentucky | 21049 | 99 | 5 |
301198 | 301198 | 2020-07-04 | Clark | Missouri | 29045 | 2 | 0 |
301413 | 301413 | 2020-07-04 | Clark | Nevada | 32003 | 17707 | 435 |
301711 | 301711 | 2020-07-04 | Clark | Ohio | 39023 | 765 | 9 |
302107 | 302107 | 2020-07-04 | Clark | South Dakota | 46025 | 15 | 0 |
302682 | 302682 | 2020-07-04 | Clark | Washington | 53011 | 920 | 30 |
302777 | 302777 | 2020-07-04 | Clark | Wisconsin | 55019 | 86 | 7 |
296655 | 296655 | 2020-07-03 | Clark | Arkansas | 5019 | 58 | 0 |
297139 | 297139 | 2020-07-03 | Clark | Illinois | 17023 | 15 | 0 |
297240 | 297240 | 2020-07-03 | Clark | Indiana | 18019 | 650 | 51 |
297435 | 297435 | 2020-07-03 | Clark | Kansas | 20025 | 34 | 0 |
297543 | 297543 | 2020-07-03 | Clark | Kentucky | 21049 | 99 | 5 |
298035 | 298035 | 2020-07-03 | Clark | Missouri | 29045 | 2 | 0 |
298250 | 298250 | 2020-07-03 | Clark | Nevada | 32003 | 17028 | 435 |
298548 | 298548 | 2020-07-03 | Clark | Ohio | 39023 | 761 | 9 |
298943 | 298943 | 2020-07-03 | Clark | South Dakota | 46025 | 15 | 0 |
299518 | 299518 | 2020-07-03 | Clark | Washington | 53011 | 901 | 30 |
299613 | 299613 | 2020-07-03 | Clark | Wisconsin | 55019 | 82 | 7 |
293499 | 293499 | 2020-07-02 | Clark | Arkansas | 5019 | 57 | 0 |
293982 | 293982 | 2020-07-02 | Clark | Illinois | 17023 | 14 | 0 |
294082 | 294082 | 2020-07-02 | Clark | Indiana | 18019 | 638 | 51 |
294277 | 294277 | 2020-07-02 | Clark | Kansas | 20025 | 34 | 0 |
294385 | 294385 | 2020-07-02 | Clark | Kentucky | 21049 | 98 | 5 |
294877 | 294877 | 2020-07-02 | Clark | Missouri | 29045 | 2 | 0 |
295090 | 295090 | 2020-07-02 | Clark | Nevada | 32003 | 16180 | 432 |
295388 | 295388 | 2020-07-02 | Clark | Ohio | 39023 | 739 | 9 |
295783 | 295783 | 2020-07-02 | Clark | South Dakota | 46025 | 15 | 0 |
296356 | 296356 | 2020-07-02 | Clark | Washington | 53011 | 901 | 30 |
296451 | 296451 | 2020-07-02 | Clark | Wisconsin | 55019 | 81 | 7 |
290345 | 290345 | 2020-07-01 | Clark | Arkansas | 5019 | 57 | 0 |
290828 | 290828 | 2020-07-01 | Clark | Illinois | 17023 | 14 | 0 |
290928 | 290928 | 2020-07-01 | Clark | Indiana | 18019 | 633 | 51 |
291123 | 291123 | 2020-07-01 | Clark | Kansas | 20025 | 34 | 0 |
291231 | 291231 | 2020-07-01 | Clark | Kentucky | 21049 | 98 | 5 |
291723 | 291723 | 2020-07-01 | Clark | Missouri | 29045 | 2 | 0 |
291935 | 291935 | 2020-07-01 | Clark | Nevada | 32003 | 15604 | 420 |
292233 | 292233 | 2020-07-01 | Clark | Ohio | 39023 | 739 | 9 |
292627 | 292627 | 2020-07-01 | Clark | South Dakota | 46025 | 15 | 0 |
293201 | 293201 | 2020-07-01 | Clark | Washington | 53011 | 883 | 30 |
293296 | 293296 | 2020-07-01 | Clark | Wisconsin | 55019 | 77 | 6 |
287194 | 287194 | 2020-06-30 | Clark | Arkansas | 5019 | 56 | 0 |
287678 | 287678 | 2020-06-30 | Clark | Illinois | 17023 | 14 | 0 |
287778 | 287778 | 2020-06-30 | Clark | Indiana | 18019 | 626 | 51 |
287973 | 287973 | 2020-06-30 | Clark | Kansas | 20025 | 34 | 0 |
288081 | 288081 | 2020-06-30 | Clark | Kentucky | 21049 | 98 | 5 |
288572 | 288572 | 2020-06-30 | Clark | Missouri | 29045 | 2 | 0 |
288783 | 288783 | 2020-06-30 | Clark | Nevada | 32003 | 15095 | 416 |
289081 | 289081 | 2020-06-30 | Clark | Ohio | 39023 | 729 | 8 |
289475 | 289475 | 2020-06-30 | Clark | South Dakota | 46025 | 15 | 0 |
290048 | 290048 | 2020-06-30 | Clark | Washington | 53011 | 843 | 30 |
290143 | 290143 | 2020-06-30 | Clark | Wisconsin | 55019 | 72 | 6 |
284048 | 284048 | 2020-06-29 | Clark | Arkansas | 5019 | 56 | 0 |
284529 | 284529 | 2020-06-29 | Clark | Illinois | 17023 | 15 | 0 |
284629 | 284629 | 2020-06-29 | Clark | Indiana | 18019 | 624 | 51 |
284824 | 284824 | 2020-06-29 | Clark | Kansas | 20025 | 34 | 0 |
284932 | 284932 | 2020-06-29 | Clark | Kentucky | 21049 | 98 | 5 |
285422 | 285422 | 2020-06-29 | Clark | Missouri | 29045 | 2 | 0 |
285633 | 285633 | 2020-06-29 | Clark | Nevada | 32003 | 14607 | 414 |
285931 | 285931 | 2020-06-29 | Clark | Ohio | 39023 | 728 | 8 |
286324 | 286324 | 2020-06-29 | Clark | South Dakota | 46025 | 14 | 0 |
286898 | 286898 | 2020-06-29 | Clark | Washington | 53011 | 826 | 30 |
286993 | 286993 | 2020-06-29 | Clark | Wisconsin | 55019 | 70 | 6 |
280902 | 280902 | 2020-06-28 | Clark | Arkansas | 5019 | 56 | 0 |
281384 | 281384 | 2020-06-28 | Clark | Illinois | 17023 | 15 | 0 |
281484 | 281484 | 2020-06-28 | Clark | Indiana | 18019 | 623 | 51 |
281679 | 281679 | 2020-06-28 | Clark | Kansas | 20025 | 34 | 0 |
281786 | 281786 | 2020-06-28 | Clark | Kentucky | 21049 | 98 | 5 |
282277 | 282277 | 2020-06-28 | Clark | Missouri | 29045 | 2 | 0 |
282488 | 282488 | 2020-06-28 | Clark | Nevada | 32003 | 13910 | 410 |
282786 | 282786 | 2020-06-28 | Clark | Ohio | 39023 | 727 | 8 |
283179 | 283179 | 2020-06-28 | Clark | South Dakota | 46025 | 14 | 0 |
283752 | 283752 | 2020-06-28 | Clark | Washington | 53011 | 758 | 30 |
283847 | 283847 | 2020-06-28 | Clark | Wisconsin | 55019 | 70 | 6 |
277755 | 277755 | 2020-06-27 | Clark | Arkansas | 5019 | 55 | 0 |
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);