ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where county = "Fayette" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
36319 | 36319 | 2020-04-06 | Fayette | Iowa | 19065 | 3 | 0 |
38646 | 38646 | 2020-04-07 | Fayette | Illinois | 17051 | 3 | 0 |
38819 | 38819 | 2020-04-07 | Fayette | Iowa | 19065 | 3 | 0 |
41365 | 41365 | 2020-04-08 | Fayette | Iowa | 19065 | 3 | 0 |
43941 | 43941 | 2020-04-09 | Fayette | Iowa | 19065 | 3 | 0 |
48455 | 48455 | 2020-04-11 | Fayette | Alabama | 1057 | 3 | 0 |
72924 | 72924 | 2020-04-20 | Fayette | Alabama | 1057 | 3 | 0 |
1460 | 1460 | 2020-03-12 | Fayette | Kentucky | 21067 | 4 | 0 |
1733 | 1733 | 2020-03-13 | Fayette | Kentucky | 21067 | 4 | 0 |
2026 | 2026 | 2020-03-14 | Fayette | Georgia | 13113 | 4 | 0 |
11972 | 11972 | 2020-03-25 | Fayette | Pennsylvania | 42051 | 4 | 0 |
16275 | 16275 | 2020-03-28 | Fayette | Indiana | 18041 | 4 | 1 |
17310 | 17310 | 2020-03-28 | Fayette | Tennessee | 47047 | 4 | 0 |
25750 | 25750 | 2020-04-01 | Fayette | Texas | 48149 | 4 | 0 |
28031 | 28031 | 2020-04-02 | Fayette | Texas | 48149 | 4 | 0 |
41190 | 41190 | 2020-04-08 | Fayette | Illinois | 17051 | 4 | 0 |
42322 | 42322 | 2020-04-08 | Fayette | Ohio | 39047 | 4 | 0 |
46546 | 46546 | 2020-04-10 | Fayette | Iowa | 19065 | 4 | 0 |
49180 | 49180 | 2020-04-11 | Fayette | Iowa | 19065 | 4 | 0 |
51116 | 51116 | 2020-04-12 | Fayette | Alabama | 1057 | 4 | 0 |
51844 | 51844 | 2020-04-12 | Fayette | Iowa | 19065 | 4 | 0 |
53794 | 53794 | 2020-04-13 | Fayette | Alabama | 1057 | 4 | 0 |
56486 | 56486 | 2020-04-14 | Fayette | Alabama | 1057 | 4 | 0 |
59194 | 59194 | 2020-04-15 | Fayette | Alabama | 1057 | 4 | 0 |
61912 | 61912 | 2020-04-16 | Fayette | Alabama | 1057 | 4 | 0 |
64645 | 64645 | 2020-04-17 | Fayette | Alabama | 1057 | 4 | 0 |
67237 | 67237 | 2020-04-17 | Fayette | West Virginia | 54019 | 4 | 0 |
67393 | 67393 | 2020-04-18 | Fayette | Alabama | 1057 | 4 | 0 |
69999 | 69999 | 2020-04-18 | Fayette | West Virginia | 54019 | 4 | 0 |
70155 | 70155 | 2020-04-19 | Fayette | Alabama | 1057 | 4 | 0 |
75700 | 75700 | 2020-04-21 | Fayette | Alabama | 1057 | 4 | 0 |
78483 | 78483 | 2020-04-22 | Fayette | Alabama | 1057 | 4 | 0 |
81276 | 81276 | 2020-04-23 | Fayette | Alabama | 1057 | 4 | 0 |
84077 | 84077 | 2020-04-24 | Fayette | Alabama | 1057 | 4 | 0 |
2069 | 2069 | 2020-03-14 | Fayette | Kentucky | 21067 | 5 | 0 |
2413 | 2413 | 2020-03-15 | Fayette | Georgia | 13113 | 5 | 0 |
2466 | 2466 | 2020-03-15 | Fayette | Kentucky | 21067 | 5 | 0 |
2850 | 2850 | 2020-03-16 | Fayette | Georgia | 13113 | 5 | 0 |
2911 | 2911 | 2020-03-16 | Fayette | Kentucky | 21067 | 5 | 0 |
3335 | 3335 | 2020-03-17 | Fayette | Georgia | 13113 | 5 | 0 |
3406 | 3406 | 2020-03-17 | Fayette | Kentucky | 21067 | 5 | 0 |
18177 | 18177 | 2020-03-29 | Fayette | Indiana | 18041 | 5 | 1 |
44907 | 44907 | 2020-04-09 | Fayette | Ohio | 39047 | 5 | 0 |
47522 | 47522 | 2020-04-10 | Fayette | Ohio | 39047 | 5 | 0 |
54526 | 54526 | 2020-04-13 | Fayette | Iowa | 19065 | 5 | 0 |
57219 | 57219 | 2020-04-14 | Fayette | Iowa | 19065 | 5 | 0 |
59927 | 59927 | 2020-04-15 | Fayette | Iowa | 19065 | 5 | 0 |
62648 | 62648 | 2020-04-16 | Fayette | Iowa | 19065 | 5 | 0 |
72768 | 72768 | 2020-04-19 | Fayette | West Virginia | 54019 | 5 | 0 |
75544 | 75544 | 2020-04-20 | Fayette | West Virginia | 54019 | 5 | 0 |
78327 | 78327 | 2020-04-21 | Fayette | West Virginia | 54019 | 5 | 0 |
81120 | 81120 | 2020-04-22 | Fayette | West Virginia | 54019 | 5 | 0 |
86885 | 86885 | 2020-04-25 | Fayette | Alabama | 1057 | 5 | 0 |
89701 | 89701 | 2020-04-26 | Fayette | Alabama | 1057 | 5 | 0 |
92519 | 92519 | 2020-04-27 | Fayette | Alabama | 1057 | 5 | 0 |
95349 | 95349 | 2020-04-28 | Fayette | Alabama | 1057 | 5 | 0 |
3983 | 3983 | 2020-03-18 | Fayette | Kentucky | 21067 | 6 | 0 |
65382 | 65382 | 2020-04-17 | Fayette | Iowa | 19065 | 6 | 0 |
68131 | 68131 | 2020-04-18 | Fayette | Iowa | 19065 | 6 | 0 |
70893 | 70893 | 2020-04-19 | Fayette | Iowa | 19065 | 6 | 0 |
73664 | 73664 | 2020-04-20 | Fayette | Iowa | 19065 | 6 | 0 |
98194 | 98194 | 2020-04-29 | Fayette | Alabama | 1057 | 6 | 0 |
101044 | 101044 | 2020-04-30 | Fayette | Alabama | 1057 | 6 | 0 |
103899 | 103899 | 2020-05-01 | Fayette | Alabama | 1057 | 6 | 0 |
106764 | 106764 | 2020-05-02 | Fayette | Alabama | 1057 | 6 | 0 |
109633 | 109633 | 2020-05-03 | Fayette | Alabama | 1057 | 6 | 0 |
112508 | 112508 | 2020-05-04 | Fayette | Alabama | 1057 | 6 | 0 |
115391 | 115391 | 2020-05-05 | Fayette | Alabama | 1057 | 6 | 0 |
118350 | 118350 | 2020-05-06 | Fayette | Alabama | 1057 | 6 | 0 |
3896 | 3896 | 2020-03-18 | Fayette | Georgia | 13113 | 7 | 0 |
4670 | 4670 | 2020-03-19 | Fayette | Kentucky | 21067 | 7 | 0 |
43764 | 43764 | 2020-04-09 | Fayette | Illinois | 17051 | 7 | 0 |
46366 | 46366 | 2020-04-10 | Fayette | Illinois | 17051 | 7 | 0 |
50177 | 50177 | 2020-04-11 | Fayette | Ohio | 39047 | 7 | 0 |
76442 | 76442 | 2020-04-21 | Fayette | Iowa | 19065 | 7 | 0 |
79226 | 79226 | 2020-04-22 | Fayette | Iowa | 19065 | 7 | 0 |
82019 | 82019 | 2020-04-23 | Fayette | Iowa | 19065 | 7 | 0 |
121316 | 121316 | 2020-05-07 | Fayette | Alabama | 1057 | 7 | 0 |
124296 | 124296 | 2020-05-08 | Fayette | Alabama | 1057 | 7 | 0 |
127281 | 127281 | 2020-05-09 | Fayette | Alabama | 1057 | 7 | 0 |
130271 | 130271 | 2020-05-10 | Fayette | Alabama | 1057 | 7 | 0 |
133261 | 133261 | 2020-05-11 | Fayette | Alabama | 1057 | 7 | 0 |
4568 | 4568 | 2020-03-19 | Fayette | Georgia | 13113 | 8 | 1 |
5352 | 5352 | 2020-03-20 | Fayette | Georgia | 13113 | 8 | 1 |
13592 | 13592 | 2020-03-26 | Fayette | Pennsylvania | 42051 | 8 | 0 |
20183 | 20183 | 2020-03-30 | Fayette | Indiana | 18041 | 8 | 1 |
83921 | 83921 | 2020-04-23 | Fayette | West Virginia | 54019 | 8 | 0 |
6285 | 6285 | 2020-03-21 | Fayette | Georgia | 13113 | 9 | 2 |
7331 | 7331 | 2020-03-22 | Fayette | Georgia | 13113 | 9 | 2 |
15338 | 15338 | 2020-03-27 | Fayette | Pennsylvania | 42051 | 9 | 0 |
22277 | 22277 | 2020-03-31 | Fayette | Indiana | 18041 | 9 | 1 |
48997 | 48997 | 2020-04-11 | Fayette | Illinois | 17051 | 9 | 0 |
52850 | 52850 | 2020-04-12 | Fayette | Ohio | 39047 | 9 | 0 |
86728 | 86728 | 2020-04-24 | Fayette | West Virginia | 54019 | 9 | 0 |
89543 | 89543 | 2020-04-25 | Fayette | West Virginia | 54019 | 9 | 0 |
92361 | 92361 | 2020-04-26 | Fayette | West Virginia | 54019 | 9 | 0 |
136251 | 136251 | 2020-05-12 | Fayette | Alabama | 1057 | 9 | 0 |
139242 | 139242 | 2020-05-13 | Fayette | Alabama | 1057 | 9 | 0 |
145237 | 145237 | 2020-05-15 | Fayette | Alabama | 1057 | 9 | 0 |
148240 | 148240 | 2020-05-16 | Fayette | Alabama | 1057 | 9 | 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);