ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,457 rows where county = "Franklin" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 25
- Kansas 791
- Ohio 791
- Indiana 788
- Washington 788
- Kentucky 787
- Massachusetts 787
- Mississippi 785
- North Carolina 785
- Pennsylvania 785
- Vermont 784
- Virginia 784
- Tennessee 783
- Alabama 782
- Missouri 781
- New York 780
- Georgia 779
- Illinois 779
- Maine 779
- Louisiana 777
- Texas 776
- Florida 771
- Arkansas 768
- Iowa 768
- Nebraska 764
- Idaho 715
fips 25
county 1
- Franklin · 19,457 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2065 | 2065 | 2020-03-14 | Franklin | Kansas | 20059 | 1 | 0 |
2189 | 2189 | 2020-03-14 | Franklin | Ohio | 39049 | 1 | 0 |
2461 | 2461 | 2020-03-15 | Franklin | Kansas | 20059 | 1 | 0 |
2906 | 2906 | 2020-03-16 | Franklin | Kansas | 20059 | 1 | 0 |
3401 | 3401 | 2020-03-17 | Franklin | Kansas | 20059 | 1 | 0 |
3725 | 3725 | 2020-03-17 | Franklin | Washington | 53021 | 1 | 0 |
3977 | 3977 | 2020-03-18 | Franklin | Kansas | 20059 | 1 | 0 |
3984 | 3984 | 2020-03-18 | Franklin | Kentucky | 21073 | 1 | 0 |
4029 | 4029 | 2020-03-18 | Franklin | Massachusetts | 25011 | 1 | 0 |
4360 | 4360 | 2020-03-18 | Franklin | Washington | 53021 | 1 | 0 |
4659 | 4659 | 2020-03-19 | Franklin | Kansas | 20059 | 1 | 0 |
4671 | 4671 | 2020-03-19 | Franklin | Kentucky | 21073 | 1 | 0 |
4733 | 4733 | 2020-03-19 | Franklin | Massachusetts | 25011 | 1 | 0 |
5117 | 5117 | 2020-03-19 | Franklin | Washington | 53021 | 1 | 0 |
5470 | 5470 | 2020-03-20 | Franklin | Kansas | 20059 | 1 | 0 |
5485 | 5485 | 2020-03-20 | Franklin | Kentucky | 21073 | 1 | 0 |
5552 | 5552 | 2020-03-20 | Franklin | Massachusetts | 25011 | 1 | 0 |
5608 | 5608 | 2020-03-20 | Franklin | Mississippi | 28037 | 1 | 0 |
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6019 | 6019 | 2020-03-20 | Franklin | Washington | 53021 | 1 | 0 |
6415 | 6415 | 2020-03-21 | Franklin | Kansas | 20059 | 1 | 0 |
6431 | 6431 | 2020-03-21 | Franklin | Kentucky | 21073 | 1 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7022 | 7022 | 2020-03-21 | Franklin | Virginia | 51067 | 1 | 0 |
7050 | 7050 | 2020-03-21 | Franklin | Washington | 53021 | 1 | 0 |
7482 | 7482 | 2020-03-22 | Franklin | Kansas | 20059 | 1 | 0 |
7502 | 7502 | 2020-03-22 | Franklin | Kentucky | 21073 | 1 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
8050 | 8050 | 2020-03-22 | Franklin | Tennessee | 47051 | 1 | 0 |
8156 | 8156 | 2020-03-22 | Franklin | Virginia | 51067 | 1 | 0 |
8260 | 8260 | 2020-03-23 | Franklin | Alabama | 1059 | 1 | 0 |
8643 | 8643 | 2020-03-23 | Franklin | Kansas | 20059 | 1 | 0 |
9188 | 9188 | 2020-03-23 | Franklin | Pennsylvania | 42055 | 1 | 0 |
9268 | 9268 | 2020-03-23 | Franklin | Tennessee | 47051 | 1 | 0 |
9378 | 9378 | 2020-03-23 | Franklin | Virginia | 51067 | 1 | 0 |
9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
9924 | 9924 | 2020-03-24 | Franklin | Kansas | 20059 | 1 | 0 |
10203 | 10203 | 2020-03-24 | Franklin | Missouri | 29071 | 1 | 0 |
10597 | 10597 | 2020-03-24 | Franklin | Tennessee | 47051 | 1 | 0 |
10725 | 10725 | 2020-03-24 | Franklin | Virginia | 51067 | 1 | 0 |
11322 | 11322 | 2020-03-25 | Franklin | Kansas | 20059 | 1 | 0 |
11747 | 11747 | 2020-03-25 | Franklin | New York | 36033 | 1 | 0 |
12074 | 12074 | 2020-03-25 | Franklin | Tennessee | 47051 | 1 | 0 |
12237 | 12237 | 2020-03-25 | Franklin | Virginia | 51067 | 1 | 0 |
12660 | 12660 | 2020-03-26 | Franklin | Georgia | 13119 | 1 | 0 |
12757 | 12757 | 2020-03-26 | Franklin | Illinois | 17055 | 1 | 0 |
12889 | 12889 | 2020-03-26 | Franklin | Kansas | 20059 | 1 | 0 |
13005 | 13005 | 2020-03-26 | Franklin | Maine | 23007 | 1 | 0 |
13350 | 13350 | 2020-03-26 | Franklin | New York | 36033 | 1 | 0 |
13875 | 13875 | 2020-03-26 | Franklin | Virginia | 51067 | 1 | 0 |
14332 | 14332 | 2020-03-27 | Franklin | Georgia | 13119 | 1 | 0 |
14433 | 14433 | 2020-03-27 | Franklin | Illinois | 17055 | 1 | 0 |
14713 | 14713 | 2020-03-27 | Franklin | Maine | 23007 | 1 | 0 |
15642 | 15642 | 2020-03-27 | Franklin | Virginia | 51067 | 1 | 0 |
16228 | 16228 | 2020-03-28 | Franklin | Illinois | 17055 | 1 | 0 |
17516 | 17516 | 2020-03-28 | Franklin | Virginia | 51067 | 1 | 0 |
19346 | 19346 | 2020-03-29 | Franklin | Texas | 48159 | 1 | 0 |
20129 | 20129 | 2020-03-30 | Franklin | Illinois | 17055 | 1 | 0 |
21405 | 21405 | 2020-03-30 | Franklin | Texas | 48159 | 1 | 0 |
22221 | 22221 | 2020-03-31 | Franklin | Illinois | 17055 | 1 | 0 |
23544 | 23544 | 2020-03-31 | Franklin | Texas | 48159 | 1 | 0 |
24389 | 24389 | 2020-04-01 | Franklin | Illinois | 17055 | 1 | 0 |
25752 | 25752 | 2020-04-01 | Franklin | Texas | 48159 | 1 | 0 |
26622 | 26622 | 2020-04-02 | Franklin | Illinois | 17055 | 1 | 0 |
28033 | 28033 | 2020-04-02 | Franklin | Texas | 48159 | 1 | 0 |
28684 | 28684 | 2020-04-03 | Franklin | Florida | 12037 | 1 | 0 |
28931 | 28931 | 2020-04-03 | Franklin | Illinois | 17055 | 1 | 0 |
30368 | 30368 | 2020-04-03 | Franklin | Texas | 48159 | 1 | 0 |
31043 | 31043 | 2020-04-04 | Franklin | Florida | 12037 | 1 | 0 |
31293 | 31293 | 2020-04-04 | Franklin | Illinois | 17055 | 1 | 0 |
32761 | 32761 | 2020-04-04 | Franklin | Texas | 48159 | 1 | 0 |
33702 | 33702 | 2020-04-05 | Franklin | Illinois | 17055 | 1 | 0 |
35199 | 35199 | 2020-04-05 | Franklin | Texas | 48159 | 1 | 0 |
35709 | 35709 | 2020-04-06 | Franklin | Arkansas | 5047 | 1 | 0 |
36320 | 36320 | 2020-04-06 | Franklin | Iowa | 19069 | 1 | 0 |
37675 | 37675 | 2020-04-06 | Franklin | Texas | 48159 | 1 | 0 |
38198 | 38198 | 2020-04-07 | Franklin | Arkansas | 5047 | 1 | 0 |
38820 | 38820 | 2020-04-07 | Franklin | Iowa | 19069 | 1 | 0 |
40200 | 40200 | 2020-04-07 | Franklin | Texas | 48159 | 1 | 0 |
40741 | 40741 | 2020-04-08 | Franklin | Arkansas | 5047 | 1 | 0 |
41366 | 41366 | 2020-04-08 | Franklin | Iowa | 19069 | 1 | 0 |
42766 | 42766 | 2020-04-08 | Franklin | Texas | 48159 | 1 | 0 |
43313 | 43313 | 2020-04-09 | Franklin | Arkansas | 5047 | 1 | 0 |
43942 | 43942 | 2020-04-09 | Franklin | Iowa | 19069 | 1 | 0 |
45355 | 45355 | 2020-04-09 | Franklin | Texas | 48159 | 1 | 0 |
45912 | 45912 | 2020-04-10 | Franklin | Arkansas | 5047 | 1 | 0 |
46547 | 46547 | 2020-04-10 | Franklin | Iowa | 19069 | 1 | 0 |
47975 | 47975 | 2020-04-10 | Franklin | Texas | 48159 | 1 | 0 |
48542 | 48542 | 2020-04-11 | Franklin | Arkansas | 5047 | 1 | 0 |
49181 | 49181 | 2020-04-11 | Franklin | Iowa | 19069 | 1 | 0 |
50633 | 50633 | 2020-04-11 | Franklin | Texas | 48159 | 1 | 0 |
51204 | 51204 | 2020-04-12 | Franklin | Arkansas | 5047 | 1 | 0 |
51845 | 51845 | 2020-04-12 | Franklin | Iowa | 19069 | 1 | 0 |
53308 | 53308 | 2020-04-12 | Franklin | Texas | 48159 | 1 | 0 |
54527 | 54527 | 2020-04-13 | Franklin | Iowa | 19069 | 1 | 0 |
55996 | 55996 | 2020-04-13 | Franklin | Texas | 48159 | 1 | 0 |
57220 | 57220 | 2020-04-14 | Franklin | Iowa | 19069 | 1 | 0 |
58701 | 58701 | 2020-04-14 | Franklin | Texas | 48159 | 1 | 0 |
59282 | 59282 | 2020-04-15 | Franklin | Arkansas | 5047 | 1 | 0 |
59928 | 59928 | 2020-04-15 | Franklin | Iowa | 19069 | 1 | 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);