ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,231 rows where county = "Randolph" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
- Georgia 785
- North Carolina 781
- Missouri 780
- Arkansas 779
- Alabama 778
- Indiana 778
- Illinois 775
- West Virginia 775
county 1
- Randolph · 6,231 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5377 | 5377 | 2020-03-20 | Randolph | Georgia | 13243 | 1 | 0 |
6311 | 6311 | 2020-03-21 | Randolph | Georgia | 13243 | 1 | 0 |
7357 | 7357 | 2020-03-22 | Randolph | Georgia | 13243 | 1 | 0 |
8510 | 8510 | 2020-03-23 | Randolph | Georgia | 13243 | 1 | 0 |
9769 | 9769 | 2020-03-24 | Randolph | Georgia | 13243 | 1 | 0 |
10384 | 10384 | 2020-03-24 | Randolph | North Carolina | 37151 | 2 | 0 |
11149 | 11149 | 2020-03-25 | Randolph | Georgia | 13243 | 1 | 0 |
11643 | 11643 | 2020-03-25 | Randolph | Missouri | 29175 | 1 | 0 |
11829 | 11829 | 2020-03-25 | Randolph | North Carolina | 37151 | 3 | 0 |
12467 | 12467 | 2020-03-26 | Randolph | Arkansas | 5121 | 2 | 0 |
12701 | 12701 | 2020-03-26 | Randolph | Georgia | 13243 | 2 | 0 |
13241 | 13241 | 2020-03-26 | Randolph | Missouri | 29175 | 1 | 0 |
13433 | 13433 | 2020-03-26 | Randolph | North Carolina | 37151 | 3 | 0 |
14068 | 14068 | 2020-03-27 | Randolph | Alabama | 1111 | 1 | 0 |
14131 | 14131 | 2020-03-27 | Randolph | Arkansas | 5121 | 2 | 0 |
14375 | 14375 | 2020-03-27 | Randolph | Georgia | 13243 | 3 | 0 |
14514 | 14514 | 2020-03-27 | Randolph | Indiana | 18135 | 1 | 0 |
14968 | 14968 | 2020-03-27 | Randolph | Missouri | 29175 | 1 | 0 |
15169 | 15169 | 2020-03-27 | Randolph | North Carolina | 37151 | 5 | 0 |
15847 | 15847 | 2020-03-28 | Randolph | Alabama | 1111 | 2 | 0 |
15912 | 15912 | 2020-03-28 | Randolph | Arkansas | 5121 | 2 | 0 |
16164 | 16164 | 2020-03-28 | Randolph | Georgia | 13243 | 3 | 0 |
16313 | 16313 | 2020-03-28 | Randolph | Indiana | 18135 | 1 | 0 |
16792 | 16792 | 2020-03-28 | Randolph | Missouri | 29175 | 1 | 0 |
17003 | 17003 | 2020-03-28 | Randolph | North Carolina | 37151 | 9 | 0 |
17731 | 17731 | 2020-03-29 | Randolph | Alabama | 1111 | 2 | 0 |
17801 | 17801 | 2020-03-29 | Randolph | Arkansas | 5121 | 2 | 0 |
18061 | 18061 | 2020-03-29 | Randolph | Georgia | 13243 | 3 | 0 |
18217 | 18217 | 2020-03-29 | Randolph | Indiana | 18135 | 1 | 0 |
18714 | 18714 | 2020-03-29 | Randolph | Missouri | 29175 | 1 | 0 |
18935 | 18935 | 2020-03-29 | Randolph | North Carolina | 37151 | 15 | 0 |
19703 | 19703 | 2020-03-30 | Randolph | Alabama | 1111 | 2 | 0 |
19776 | 19776 | 2020-03-30 | Randolph | Arkansas | 5121 | 2 | 0 |
20054 | 20054 | 2020-03-30 | Randolph | Georgia | 13243 | 3 | 0 |
20153 | 20153 | 2020-03-30 | Randolph | Illinois | 17157 | 2 | 0 |
20223 | 20223 | 2020-03-30 | Randolph | Indiana | 18135 | 1 | 0 |
20746 | 20746 | 2020-03-30 | Randolph | Missouri | 29175 | 1 | 0 |
20975 | 20975 | 2020-03-30 | Randolph | North Carolina | 37151 | 16 | 0 |
21660 | 21660 | 2020-03-30 | Randolph | West Virginia | 54083 | 1 | 0 |
21775 | 21775 | 2020-03-31 | Randolph | Alabama | 1111 | 2 | 0 |
21849 | 21849 | 2020-03-31 | Randolph | Arkansas | 5121 | 3 | 0 |
22137 | 22137 | 2020-03-31 | Randolph | Georgia | 13243 | 5 | 0 |
22246 | 22246 | 2020-03-31 | Randolph | Illinois | 17157 | 3 | 0 |
22318 | 22318 | 2020-03-31 | Randolph | Indiana | 18135 | 3 | 0 |
22865 | 22865 | 2020-03-31 | Randolph | Missouri | 29175 | 2 | 0 |
23102 | 23102 | 2020-03-31 | Randolph | North Carolina | 37151 | 17 | 0 |
23810 | 23810 | 2020-03-31 | Randolph | West Virginia | 54083 | 1 | 0 |
23931 | 23931 | 2020-04-01 | Randolph | Alabama | 1111 | 5 | 0 |
24007 | 24007 | 2020-04-01 | Randolph | Arkansas | 5121 | 3 | 0 |
24302 | 24302 | 2020-04-01 | Randolph | Georgia | 13243 | 5 | 0 |
24415 | 24415 | 2020-04-01 | Randolph | Illinois | 17157 | 7 | 0 |
24489 | 24489 | 2020-04-01 | Randolph | Indiana | 18135 | 3 | 0 |
25053 | 25053 | 2020-04-01 | Randolph | Missouri | 29175 | 2 | 0 |
25296 | 25296 | 2020-04-01 | Randolph | North Carolina | 37151 | 17 | 0 |
26028 | 26028 | 2020-04-01 | Randolph | West Virginia | 54083 | 1 | 0 |
26153 | 26153 | 2020-04-02 | Randolph | Alabama | 1111 | 6 | 0 |
26234 | 26234 | 2020-04-02 | Randolph | Arkansas | 5121 | 3 | 0 |
26533 | 26533 | 2020-04-02 | Randolph | Georgia | 13243 | 4 | 0 |
26653 | 26653 | 2020-04-02 | Randolph | Illinois | 17157 | 8 | 0 |
26728 | 26728 | 2020-04-02 | Randolph | Indiana | 18135 | 3 | 0 |
27310 | 27310 | 2020-04-02 | Randolph | Missouri | 29175 | 2 | 0 |
27561 | 27561 | 2020-04-02 | Randolph | North Carolina | 37151 | 19 | 0 |
28321 | 28321 | 2020-04-02 | Randolph | West Virginia | 54083 | 2 | 0 |
28450 | 28450 | 2020-04-03 | Randolph | Alabama | 1111 | 10 | 1 |
28533 | 28533 | 2020-04-03 | Randolph | Arkansas | 5121 | 3 | 0 |
28839 | 28839 | 2020-04-03 | Randolph | Georgia | 13243 | 11 | 0 |
28963 | 28963 | 2020-04-03 | Randolph | Illinois | 17157 | 12 | 0 |
29039 | 29039 | 2020-04-03 | Randolph | Indiana | 18135 | 4 | 1 |
29631 | 29631 | 2020-04-03 | Randolph | Missouri | 29175 | 4 | 0 |
29888 | 29888 | 2020-04-03 | Randolph | North Carolina | 37151 | 19 | 1 |
30675 | 30675 | 2020-04-03 | Randolph | West Virginia | 54083 | 2 | 0 |
30807 | 30807 | 2020-04-04 | Randolph | Alabama | 1111 | 11 | 1 |
30891 | 30891 | 2020-04-04 | Randolph | Arkansas | 5121 | 3 | 0 |
31199 | 31199 | 2020-04-04 | Randolph | Georgia | 13243 | 18 | 0 |
31329 | 31329 | 2020-04-04 | Randolph | Illinois | 17157 | 20 | 0 |
31406 | 31406 | 2020-04-04 | Randolph | Indiana | 18135 | 5 | 1 |
32012 | 32012 | 2020-04-04 | Randolph | Missouri | 29175 | 7 | 0 |
32275 | 32275 | 2020-04-04 | Randolph | North Carolina | 37151 | 26 | 1 |
33076 | 33076 | 2020-04-04 | Randolph | West Virginia | 54083 | 3 | 0 |
33211 | 33211 | 2020-04-05 | Randolph | Alabama | 1111 | 11 | 1 |
33296 | 33296 | 2020-04-05 | Randolph | Arkansas | 5121 | 3 | 0 |
33606 | 33606 | 2020-04-05 | Randolph | Georgia | 13243 | 18 | 0 |
33739 | 33739 | 2020-04-05 | Randolph | Illinois | 17157 | 24 | 0 |
33817 | 33817 | 2020-04-05 | Randolph | Indiana | 18135 | 5 | 1 |
34440 | 34440 | 2020-04-05 | Randolph | Missouri | 29175 | 7 | 0 |
34707 | 34707 | 2020-04-05 | Randolph | North Carolina | 37151 | 29 | 1 |
35514 | 35514 | 2020-04-05 | Randolph | West Virginia | 54083 | 3 | 0 |
35650 | 35650 | 2020-04-06 | Randolph | Alabama | 1111 | 12 | 1 |
35740 | 35740 | 2020-04-06 | Randolph | Arkansas | 5121 | 4 | 0 |
36056 | 36056 | 2020-04-06 | Randolph | Georgia | 13243 | 26 | 2 |
36191 | 36191 | 2020-04-06 | Randolph | Illinois | 17157 | 27 | 0 |
36271 | 36271 | 2020-04-06 | Randolph | Indiana | 18135 | 5 | 1 |
36906 | 36906 | 2020-04-06 | Randolph | Missouri | 29175 | 7 | 0 |
37176 | 37176 | 2020-04-06 | Randolph | North Carolina | 37151 | 33 | 1 |
37999 | 37999 | 2020-04-06 | Randolph | West Virginia | 54083 | 3 | 0 |
38138 | 38138 | 2020-04-07 | Randolph | Alabama | 1111 | 13 | 2 |
38229 | 38229 | 2020-04-07 | Randolph | Arkansas | 5121 | 6 | 0 |
38549 | 38549 | 2020-04-07 | Randolph | Georgia | 13243 | 83 | 4 |
38687 | 38687 | 2020-04-07 | Randolph | Illinois | 17157 | 29 | 0 |
38769 | 38769 | 2020-04-07 | Randolph | Indiana | 18135 | 7 | 1 |
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);