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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-07-19 12
- 2020-07-20 12
- 2020-07-21 12
- 2020-07-28 12
- 2020-07-29 12
- 2020-07-30 12
- 2020-07-31 12
- 2020-08-01 12
- 2020-08-02 12
- 2020-08-03 12
- 2020-08-04 12
- 2020-08-05 12
- 2020-08-06 12
- 2020-08-07 12
- 2020-08-08 12
- 2020-08-09 12
- 2020-08-10 12
- 2020-08-11 12
- 2020-08-12 12
- 2020-08-13 12
- 2020-08-14 12
- 2020-08-15 12
- 2020-08-16 12
- 2020-08-17 12
- 2020-08-18 12
- 2020-08-19 12
- 2020-08-20 12
- 2020-08-21 12
- 2020-08-22 12
- 2020-08-23 12
- …
state 12
fips 12
county 1
- Clark · 9,259 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
561 | 561 | 2020-03-05 | Clark | Nevada | 32003 | 1 | 0 |
622 | 622 | 2020-03-06 | Clark | Nevada | 32003 | 1 | 0 |
648 | 648 | 2020-03-06 | Clark | Washington | 53011 | 1 | 0 |
709 | 709 | 2020-03-07 | Clark | Nevada | 32003 | 1 | 0 |
742 | 742 | 2020-03-07 | Clark | Washington | 53011 | 1 | 0 |
813 | 813 | 2020-03-08 | Clark | Nevada | 32003 | 2 | 0 |
854 | 854 | 2020-03-08 | Clark | Washington | 53011 | 1 | 0 |
937 | 937 | 2020-03-09 | Clark | Nevada | 32003 | 2 | 0 |
985 | 985 | 2020-03-09 | Clark | Washington | 53011 | 1 | 0 |
1087 | 1087 | 2020-03-10 | Clark | Nevada | 32003 | 2 | 0 |
1148 | 1148 | 2020-03-10 | Clark | Washington | 53011 | 1 | 0 |
1269 | 1269 | 2020-03-11 | Clark | Nevada | 32003 | 5 | 0 |
1347 | 1347 | 2020-03-11 | Clark | Washington | 53011 | 1 | 0 |
1498 | 1498 | 2020-03-12 | Clark | Nevada | 32003 | 8 | 0 |
1599 | 1599 | 2020-03-12 | Clark | Washington | 53011 | 1 | 0 |
1790 | 1790 | 2020-03-13 | Clark | Nevada | 32003 | 16 | 0 |
1909 | 1909 | 2020-03-13 | Clark | Washington | 53011 | 3 | 0 |
2136 | 2136 | 2020-03-14 | Clark | Nevada | 32003 | 16 | 0 |
2282 | 2282 | 2020-03-14 | Clark | Washington | 53011 | 3 | 0 |
2465 | 2465 | 2020-03-15 | Clark | Kentucky | 21049 | 1 | 0 |
2543 | 2543 | 2020-03-15 | Clark | Nevada | 32003 | 16 | 0 |
2709 | 2709 | 2020-03-15 | Clark | Washington | 53011 | 3 | 0 |
2910 | 2910 | 2020-03-16 | Clark | Kentucky | 21049 | 1 | 0 |
2998 | 2998 | 2020-03-16 | Clark | Nevada | 32003 | 35 | 1 |
3183 | 3183 | 2020-03-16 | Clark | Washington | 53011 | 4 | 0 |
3405 | 3405 | 2020-03-17 | Clark | Kentucky | 21049 | 1 | 0 |
3510 | 3510 | 2020-03-17 | Clark | Nevada | 32003 | 42 | 1 |
3723 | 3723 | 2020-03-17 | Clark | Washington | 53011 | 4 | 2 |
3947 | 3947 | 2020-03-18 | Clark | Indiana | 18019 | 1 | 0 |
3982 | 3982 | 2020-03-18 | Clark | Kentucky | 21049 | 2 | 0 |
4103 | 4103 | 2020-03-18 | Clark | Nevada | 32003 | 69 | 1 |
4198 | 4198 | 2020-03-18 | Clark | Ohio | 39023 | 1 | 0 |
4358 | 4358 | 2020-03-18 | Clark | Washington | 53011 | 4 | 3 |
4431 | 4431 | 2020-03-19 | Clark | Arkansas | 5019 | 1 | 0 |
4623 | 4623 | 2020-03-19 | Clark | Indiana | 18019 | 1 | 0 |
4668 | 4668 | 2020-03-19 | Clark | Kentucky | 21049 | 2 | 0 |
4827 | 4827 | 2020-03-19 | Clark | Nevada | 32003 | 74 | 1 |
4929 | 4929 | 2020-03-19 | Clark | Ohio | 39023 | 1 | 0 |
5115 | 5115 | 2020-03-19 | Clark | Washington | 53011 | 4 | 3 |
5203 | 5203 | 2020-03-20 | Clark | Arkansas | 5019 | 1 | 0 |
5430 | 5430 | 2020-03-20 | Clark | Indiana | 18019 | 1 | 0 |
5482 | 5482 | 2020-03-20 | Clark | Kentucky | 21049 | 2 | 0 |
5668 | 5668 | 2020-03-20 | Clark | Nevada | 32003 | 126 | 2 |
5791 | 5791 | 2020-03-20 | Clark | Ohio | 39023 | 1 | 0 |
6016 | 6016 | 2020-03-20 | Clark | Washington | 53011 | 6 | 3 |
6122 | 6122 | 2020-03-21 | Clark | Arkansas | 5019 | 1 | 0 |
6365 | 6365 | 2020-03-21 | Clark | Indiana | 18019 | 4 | 0 |
6428 | 6428 | 2020-03-21 | Clark | Kentucky | 21049 | 2 | 0 |
6660 | 6660 | 2020-03-21 | Clark | Nevada | 32003 | 126 | 2 |
6788 | 6788 | 2020-03-21 | Clark | Ohio | 39023 | 1 | 0 |
7047 | 7047 | 2020-03-21 | Clark | Washington | 53011 | 9 | 3 |
7156 | 7156 | 2020-03-22 | Clark | Arkansas | 5019 | 1 | 0 |
7419 | 7419 | 2020-03-22 | Clark | Indiana | 18019 | 4 | 0 |
7499 | 7499 | 2020-03-22 | Clark | Kentucky | 21049 | 2 | 0 |
7750 | 7750 | 2020-03-22 | Clark | Nevada | 32003 | 126 | 2 |
7895 | 7895 | 2020-03-22 | Clark | Ohio | 39023 | 1 | 0 |
8184 | 8184 | 2020-03-22 | Clark | Washington | 53011 | 10 | 3 |
8299 | 8299 | 2020-03-23 | Clark | Arkansas | 5019 | 1 | 0 |
8576 | 8576 | 2020-03-23 | Clark | Indiana | 18019 | 5 | 0 |
8661 | 8661 | 2020-03-23 | Clark | Kentucky | 21049 | 3 | 0 |
8945 | 8945 | 2020-03-23 | Clark | Nevada | 32003 | 151 | 4 |
9098 | 9098 | 2020-03-23 | Clark | Ohio | 39023 | 1 | 0 |
9408 | 9408 | 2020-03-23 | Clark | Washington | 53011 | 13 | 4 |
9528 | 9528 | 2020-03-24 | Clark | Arkansas | 5019 | 6 | 0 |
9841 | 9841 | 2020-03-24 | Clark | Indiana | 18019 | 5 | 0 |
9944 | 9944 | 2020-03-24 | Clark | Kentucky | 21049 | 3 | 0 |
10249 | 10249 | 2020-03-24 | Clark | Nevada | 32003 | 249 | 6 |
10411 | 10411 | 2020-03-24 | Clark | Ohio | 39023 | 2 | 0 |
10757 | 10757 | 2020-03-24 | Clark | Washington | 53011 | 16 | 4 |
10898 | 10898 | 2020-03-25 | Clark | Arkansas | 5019 | 13 | 0 |
11234 | 11234 | 2020-03-25 | Clark | Indiana | 18019 | 6 | 0 |
11344 | 11344 | 2020-03-25 | Clark | Kentucky | 21049 | 3 | 0 |
11680 | 11680 | 2020-03-25 | Clark | Nevada | 32003 | 249 | 6 |
11858 | 11858 | 2020-03-25 | Clark | Ohio | 39023 | 2 | 0 |
12279 | 12279 | 2020-03-25 | Clark | Washington | 53011 | 16 | 4 |
12440 | 12440 | 2020-03-26 | Clark | Arkansas | 5019 | 15 | 0 |
12790 | 12790 | 2020-03-26 | Clark | Indiana | 18019 | 10 | 0 |
12914 | 12914 | 2020-03-26 | Clark | Kentucky | 21049 | 5 | 0 |
13283 | 13283 | 2020-03-26 | Clark | Nevada | 32003 | 350 | 10 |
13465 | 13465 | 2020-03-26 | Clark | Ohio | 39023 | 2 | 0 |
13929 | 13929 | 2020-03-26 | Clark | Washington | 53011 | 48 | 5 |
13981 | 13981 | 2020-03-26 | Clark | Wisconsin | 55019 | 1 | 0 |
14104 | 14104 | 2020-03-27 | Clark | Arkansas | 5019 | 17 | 0 |
14469 | 14469 | 2020-03-27 | Clark | Indiana | 18019 | 12 | 0 |
14619 | 14619 | 2020-03-27 | Clark | Kentucky | 21049 | 5 | 0 |
15015 | 15015 | 2020-03-27 | Clark | Nevada | 32003 | 443 | 10 |
15202 | 15202 | 2020-03-27 | Clark | Ohio | 39023 | 2 | 0 |
15697 | 15697 | 2020-03-27 | Clark | Washington | 53011 | 76 | 6 |
15753 | 15753 | 2020-03-27 | Clark | Wisconsin | 55019 | 3 | 0 |
15884 | 15884 | 2020-03-28 | Clark | Arkansas | 5019 | 18 | 0 |
16266 | 16266 | 2020-03-28 | Clark | Indiana | 18019 | 18 | 0 |
16432 | 16432 | 2020-03-28 | Clark | Kentucky | 21049 | 6 | 0 |
16843 | 16843 | 2020-03-28 | Clark | Nevada | 32003 | 528 | 14 |
17044 | 17044 | 2020-03-28 | Clark | Ohio | 39023 | 2 | 0 |
17577 | 17577 | 2020-03-28 | Clark | Washington | 53011 | 82 | 6 |
17633 | 17633 | 2020-03-28 | Clark | Wisconsin | 55019 | 3 | 0 |
17770 | 17770 | 2020-03-29 | Clark | Arkansas | 5019 | 18 | 0 |
18167 | 18167 | 2020-03-29 | Clark | Indiana | 18019 | 20 | 0 |
18342 | 18342 | 2020-03-29 | Clark | Kentucky | 21049 | 6 | 0 |
18767 | 18767 | 2020-03-29 | Clark | Nevada | 32003 | 528 | 14 |
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);