ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 21145 and state = "Kentucky" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9958 | 9958 | 2020-03-24 | McCracken | Kentucky | 21145 | 2 | 0 |
11360 | 11360 | 2020-03-25 | McCracken | Kentucky | 21145 | 2 | 0 |
12932 | 12932 | 2020-03-26 | McCracken | Kentucky | 21145 | 2 | 0 |
14638 | 14638 | 2020-03-27 | McCracken | Kentucky | 21145 | 2 | 0 |
16453 | 16453 | 2020-03-28 | McCracken | Kentucky | 21145 | 3 | 0 |
18364 | 18364 | 2020-03-29 | McCracken | Kentucky | 21145 | 5 | 0 |
20380 | 20380 | 2020-03-30 | McCracken | Kentucky | 21145 | 5 | 0 |
22485 | 22485 | 2020-03-31 | McCracken | Kentucky | 21145 | 6 | 0 |
24661 | 24661 | 2020-04-01 | McCracken | Kentucky | 21145 | 6 | 0 |
26909 | 26909 | 2020-04-02 | McCracken | Kentucky | 21145 | 8 | 0 |
29225 | 29225 | 2020-04-03 | McCracken | Kentucky | 21145 | 8 | 0 |
31601 | 31601 | 2020-04-04 | McCracken | Kentucky | 21145 | 8 | 0 |
34023 | 34023 | 2020-04-05 | McCracken | Kentucky | 21145 | 10 | 0 |
36481 | 36481 | 2020-04-06 | McCracken | Kentucky | 21145 | 10 | 0 |
38988 | 38988 | 2020-04-07 | McCracken | Kentucky | 21145 | 13 | 1 |
41538 | 41538 | 2020-04-08 | McCracken | Kentucky | 21145 | 13 | 1 |
44114 | 44114 | 2020-04-09 | McCracken | Kentucky | 21145 | 13 | 1 |
46722 | 46722 | 2020-04-10 | McCracken | Kentucky | 21145 | 18 | 2 |
49362 | 49362 | 2020-04-11 | McCracken | Kentucky | 21145 | 21 | 2 |
52028 | 52028 | 2020-04-12 | McCracken | Kentucky | 21145 | 21 | 2 |
54709 | 54709 | 2020-04-13 | McCracken | Kentucky | 21145 | 23 | 2 |
57407 | 57407 | 2020-04-14 | McCracken | Kentucky | 21145 | 24 | 2 |
60116 | 60116 | 2020-04-15 | McCracken | Kentucky | 21145 | 25 | 2 |
62836 | 62836 | 2020-04-16 | McCracken | Kentucky | 21145 | 28 | 2 |
65575 | 65575 | 2020-04-17 | McCracken | Kentucky | 21145 | 27 | 2 |
68324 | 68324 | 2020-04-18 | McCracken | Kentucky | 21145 | 29 | 2 |
71087 | 71087 | 2020-04-19 | McCracken | Kentucky | 21145 | 29 | 2 |
73859 | 73859 | 2020-04-20 | McCracken | Kentucky | 21145 | 29 | 2 |
76640 | 76640 | 2020-04-21 | McCracken | Kentucky | 21145 | 30 | 2 |
79425 | 79425 | 2020-04-22 | McCracken | Kentucky | 21145 | 30 | 2 |
82222 | 82222 | 2020-04-23 | McCracken | Kentucky | 21145 | 30 | 2 |
85025 | 85025 | 2020-04-24 | McCracken | Kentucky | 21145 | 31 | 2 |
87834 | 87834 | 2020-04-25 | McCracken | Kentucky | 21145 | 34 | 2 |
90650 | 90650 | 2020-04-26 | McCracken | Kentucky | 21145 | 43 | 2 |
93471 | 93471 | 2020-04-27 | McCracken | Kentucky | 21145 | 44 | 2 |
96304 | 96304 | 2020-04-28 | McCracken | Kentucky | 21145 | 48 | 2 |
99150 | 99150 | 2020-04-29 | McCracken | Kentucky | 21145 | 48 | 2 |
102002 | 102002 | 2020-04-30 | McCracken | Kentucky | 21145 | 55 | 2 |
104863 | 104863 | 2020-05-01 | McCracken | Kentucky | 21145 | 58 | 2 |
107728 | 107728 | 2020-05-02 | McCracken | Kentucky | 21145 | 58 | 2 |
110599 | 110599 | 2020-05-03 | McCracken | Kentucky | 21145 | 59 | 2 |
113476 | 113476 | 2020-05-04 | McCracken | Kentucky | 21145 | 62 | 2 |
116358 | 116358 | 2020-05-05 | McCracken | Kentucky | 21145 | 63 | 2 |
119319 | 119319 | 2020-05-06 | McCracken | Kentucky | 21145 | 65 | 2 |
122290 | 122290 | 2020-05-07 | McCracken | Kentucky | 21145 | 68 | 2 |
125272 | 125272 | 2020-05-08 | McCracken | Kentucky | 21145 | 68 | 2 |
128260 | 128260 | 2020-05-09 | McCracken | Kentucky | 21145 | 69 | 2 |
131250 | 131250 | 2020-05-10 | McCracken | Kentucky | 21145 | 69 | 2 |
134241 | 134241 | 2020-05-11 | McCracken | Kentucky | 21145 | 72 | 2 |
137231 | 137231 | 2020-05-12 | McCracken | Kentucky | 21145 | 73 | 2 |
140224 | 140224 | 2020-05-13 | McCracken | Kentucky | 21145 | 73 | 2 |
143220 | 143220 | 2020-05-14 | McCracken | Kentucky | 21145 | 76 | 2 |
146220 | 146220 | 2020-05-15 | McCracken | Kentucky | 21145 | 80 | 2 |
149225 | 149225 | 2020-05-16 | McCracken | Kentucky | 21145 | 81 | 2 |
152236 | 152236 | 2020-05-17 | McCracken | Kentucky | 21145 | 81 | 2 |
155250 | 155250 | 2020-05-18 | McCracken | Kentucky | 21145 | 85 | 2 |
158267 | 158267 | 2020-05-19 | McCracken | Kentucky | 21145 | 85 | 2 |
161293 | 161293 | 2020-05-20 | McCracken | Kentucky | 21145 | 85 | 2 |
164322 | 164322 | 2020-05-21 | McCracken | Kentucky | 21145 | 85 | 2 |
167358 | 167358 | 2020-05-22 | McCracken | Kentucky | 21145 | 85 | 2 |
170396 | 170396 | 2020-05-23 | McCracken | Kentucky | 21145 | 87 | 2 |
173437 | 173437 | 2020-05-24 | McCracken | Kentucky | 21145 | 87 | 2 |
176481 | 176481 | 2020-05-25 | McCracken | Kentucky | 21145 | 87 | 2 |
179525 | 179525 | 2020-05-26 | McCracken | Kentucky | 21145 | 89 | 2 |
182570 | 182570 | 2020-05-27 | McCracken | Kentucky | 21145 | 89 | 2 |
185625 | 185625 | 2020-05-28 | McCracken | Kentucky | 21145 | 95 | 2 |
188683 | 188683 | 2020-05-29 | McCracken | Kentucky | 21145 | 95 | 2 |
191747 | 191747 | 2020-05-30 | McCracken | Kentucky | 21145 | 95 | 2 |
194815 | 194815 | 2020-05-31 | McCracken | Kentucky | 21145 | 95 | 2 |
197886 | 197886 | 2020-06-01 | McCracken | Kentucky | 21145 | 97 | 2 |
200958 | 200958 | 2020-06-02 | McCracken | Kentucky | 21145 | 97 | 2 |
204035 | 204035 | 2020-06-03 | McCracken | Kentucky | 21145 | 99 | 2 |
207116 | 207116 | 2020-06-04 | McCracken | Kentucky | 21145 | 107 | 2 |
210197 | 210197 | 2020-06-05 | McCracken | Kentucky | 21145 | 111 | 2 |
213282 | 213282 | 2020-06-06 | McCracken | Kentucky | 21145 | 112 | 2 |
216369 | 216369 | 2020-06-07 | McCracken | Kentucky | 21145 | 112 | 2 |
219461 | 219461 | 2020-06-08 | McCracken | Kentucky | 21145 | 112 | 2 |
222556 | 222556 | 2020-06-09 | McCracken | Kentucky | 21145 | 113 | 3 |
225652 | 225652 | 2020-06-10 | McCracken | Kentucky | 21145 | 113 | 3 |
228754 | 228754 | 2020-06-11 | McCracken | Kentucky | 21145 | 113 | 3 |
231858 | 231858 | 2020-06-12 | McCracken | Kentucky | 21145 | 116 | 3 |
234963 | 234963 | 2020-06-13 | McCracken | Kentucky | 21145 | 117 | 3 |
238070 | 238070 | 2020-06-14 | McCracken | Kentucky | 21145 | 117 | 3 |
241179 | 241179 | 2020-06-15 | McCracken | Kentucky | 21145 | 123 | 3 |
244290 | 244290 | 2020-06-16 | McCracken | Kentucky | 21145 | 123 | 3 |
247403 | 247403 | 2020-06-17 | McCracken | Kentucky | 21145 | 126 | 3 |
250515 | 250515 | 2020-06-18 | McCracken | Kentucky | 21145 | 129 | 3 |
253630 | 253630 | 2020-06-19 | McCracken | Kentucky | 21145 | 134 | 3 |
256750 | 256750 | 2020-06-20 | McCracken | Kentucky | 21145 | 134 | 3 |
259876 | 259876 | 2020-06-21 | McCracken | Kentucky | 21145 | 143 | 3 |
263005 | 263005 | 2020-06-22 | McCracken | Kentucky | 21145 | 148 | 3 |
266132 | 266132 | 2020-06-23 | McCracken | Kentucky | 21145 | 149 | 3 |
269265 | 269265 | 2020-06-24 | McCracken | Kentucky | 21145 | 150 | 3 |
272401 | 272401 | 2020-06-25 | McCracken | Kentucky | 21145 | 151 | 3 |
275544 | 275544 | 2020-06-26 | McCracken | Kentucky | 21145 | 153 | 3 |
278692 | 278692 | 2020-06-27 | McCracken | Kentucky | 21145 | 155 | 3 |
281840 | 281840 | 2020-06-28 | McCracken | Kentucky | 21145 | 159 | 3 |
284986 | 284986 | 2020-06-29 | McCracken | Kentucky | 21145 | 161 | 3 |
288135 | 288135 | 2020-06-30 | McCracken | Kentucky | 21145 | 166 | 3 |
291285 | 291285 | 2020-07-01 | McCracken | Kentucky | 21145 | 168 | 3 |
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);