ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and fips = 39049 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2189 | 2189 | 2020-03-14 | Franklin | Ohio | 39049 | 1 | 0 |
2603 | 2603 | 2020-03-15 | Franklin | Ohio | 39049 | 3 | 0 |
3065 | 3065 | 2020-03-16 | Franklin | Ohio | 39049 | 3 | 0 |
3590 | 3590 | 2020-03-17 | Franklin | Ohio | 39049 | 4 | 0 |
4203 | 4203 | 2020-03-18 | Franklin | Ohio | 39049 | 7 | 0 |
4934 | 4934 | 2020-03-19 | Franklin | Ohio | 39049 | 10 | 0 |
5797 | 5797 | 2020-03-20 | Franklin | Ohio | 39049 | 14 | 0 |
6797 | 6797 | 2020-03-21 | Franklin | Ohio | 39049 | 21 | 0 |
7905 | 7905 | 2020-03-22 | Franklin | Ohio | 39049 | 34 | 0 |
9108 | 9108 | 2020-03-23 | Franklin | Ohio | 39049 | 46 | 2 |
10423 | 10423 | 2020-03-24 | Franklin | Ohio | 39049 | 75 | 2 |
11871 | 11871 | 2020-03-25 | Franklin | Ohio | 39049 | 88 | 2 |
13478 | 13478 | 2020-03-26 | Franklin | Ohio | 39049 | 109 | 2 |
15215 | 15215 | 2020-03-27 | Franklin | Ohio | 39049 | 152 | 2 |
17057 | 17057 | 2020-03-28 | Franklin | Ohio | 39049 | 222 | 2 |
18991 | 18991 | 2020-03-29 | Franklin | Ohio | 39049 | 247 | 2 |
21035 | 21035 | 2020-03-30 | Franklin | Ohio | 39049 | 281 | 2 |
23167 | 23167 | 2020-03-31 | Franklin | Ohio | 39049 | 325 | 3 |
25362 | 25362 | 2020-04-01 | Franklin | Ohio | 39049 | 391 | 4 |
27628 | 27628 | 2020-04-02 | Franklin | Ohio | 39049 | 441 | 5 |
29957 | 29957 | 2020-04-03 | Franklin | Ohio | 39049 | 503 | 5 |
32346 | 32346 | 2020-04-04 | Franklin | Ohio | 39049 | 557 | 6 |
34779 | 34779 | 2020-04-05 | Franklin | Ohio | 39049 | 597 | 8 |
37248 | 37248 | 2020-04-06 | Franklin | Ohio | 39049 | 644 | 9 |
39765 | 39765 | 2020-04-07 | Franklin | Ohio | 39049 | 703 | 12 |
42323 | 42323 | 2020-04-08 | Franklin | Ohio | 39049 | 761 | 12 |
44908 | 44908 | 2020-04-09 | Franklin | Ohio | 39049 | 802 | 14 |
47523 | 47523 | 2020-04-10 | Franklin | Ohio | 39049 | 850 | 14 |
50178 | 50178 | 2020-04-11 | Franklin | Ohio | 39049 | 894 | 14 |
52851 | 52851 | 2020-04-12 | Franklin | Ohio | 39049 | 943 | 14 |
55535 | 55535 | 2020-04-13 | Franklin | Ohio | 39049 | 1012 | 15 |
58236 | 58236 | 2020-04-14 | Franklin | Ohio | 39049 | 1053 | 18 |
60950 | 60950 | 2020-04-15 | Franklin | Ohio | 39049 | 1102 | 19 |
63676 | 63676 | 2020-04-16 | Franklin | Ohio | 39049 | 1212 | 19 |
66419 | 66419 | 2020-04-17 | Franklin | Ohio | 39049 | 1320 | 22 |
69176 | 69176 | 2020-04-18 | Franklin | Ohio | 39049 | 1403 | 27 |
74718 | 74718 | 2020-04-20 | Franklin | Ohio | 39049 | 1510 | 35 |
71943 | 71943 | 2020-04-19 | Franklin | Ohio | 39049 | 1513 | 29 |
77499 | 77499 | 2020-04-21 | Franklin | Ohio | 39049 | 1557 | 37 |
80289 | 80289 | 2020-04-22 | Franklin | Ohio | 39049 | 1598 | 42 |
83088 | 83088 | 2020-04-23 | Franklin | Ohio | 39049 | 1673 | 46 |
85892 | 85892 | 2020-04-24 | Franklin | Ohio | 39049 | 1768 | 48 |
88706 | 88706 | 2020-04-25 | Franklin | Ohio | 39049 | 1839 | 50 |
91522 | 91522 | 2020-04-26 | Franklin | Ohio | 39049 | 1942 | 53 |
94348 | 94348 | 2020-04-27 | Franklin | Ohio | 39049 | 2005 | 57 |
97185 | 97185 | 2020-04-28 | Franklin | Ohio | 39049 | 2090 | 62 |
100034 | 100034 | 2020-04-29 | Franklin | Ohio | 39049 | 2216 | 71 |
102887 | 102887 | 2020-04-30 | Franklin | Ohio | 39049 | 2441 | 73 |
105750 | 105750 | 2020-05-01 | Franklin | Ohio | 39049 | 2589 | 76 |
108617 | 108617 | 2020-05-02 | Franklin | Ohio | 39049 | 2698 | 78 |
111491 | 111491 | 2020-05-03 | Franklin | Ohio | 39049 | 2905 | 79 |
114372 | 114372 | 2020-05-04 | Franklin | Ohio | 39049 | 2988 | 84 |
117253 | 117253 | 2020-05-05 | Franklin | Ohio | 39049 | 3097 | 87 |
120214 | 120214 | 2020-05-06 | Franklin | Ohio | 39049 | 3237 | 99 |
123191 | 123191 | 2020-05-07 | Franklin | Ohio | 39049 | 3377 | 107 |
126174 | 126174 | 2020-05-08 | Franklin | Ohio | 39049 | 3615 | 108 |
129163 | 129163 | 2020-05-09 | Franklin | Ohio | 39049 | 3710 | 114 |
132152 | 132152 | 2020-05-10 | Franklin | Ohio | 39049 | 3777 | 119 |
135143 | 135143 | 2020-05-11 | Franklin | Ohio | 39049 | 3881 | 124 |
138133 | 138133 | 2020-05-12 | Franklin | Ohio | 39049 | 4002 | 138 |
141129 | 141129 | 2020-05-13 | Franklin | Ohio | 39049 | 4113 | 148 |
144124 | 144124 | 2020-05-14 | Franklin | Ohio | 39049 | 4227 | 150 |
147125 | 147125 | 2020-05-15 | Franklin | Ohio | 39049 | 4330 | 156 |
150132 | 150132 | 2020-05-16 | Franklin | Ohio | 39049 | 4420 | 169 |
153143 | 153143 | 2020-05-17 | Franklin | Ohio | 39049 | 4493 | 170 |
156160 | 156160 | 2020-05-18 | Franklin | Ohio | 39049 | 4574 | 177 |
159180 | 159180 | 2020-05-19 | Franklin | Ohio | 39049 | 4706 | 193 |
162207 | 162207 | 2020-05-20 | Franklin | Ohio | 39049 | 4793 | 200 |
165236 | 165236 | 2020-05-21 | Franklin | Ohio | 39049 | 4885 | 205 |
168272 | 168272 | 2020-05-22 | Franklin | Ohio | 39049 | 4996 | 215 |
171311 | 171311 | 2020-05-23 | Franklin | Ohio | 39049 | 5097 | 224 |
174353 | 174353 | 2020-05-24 | Franklin | Ohio | 39049 | 5188 | 228 |
177397 | 177397 | 2020-05-25 | Franklin | Ohio | 39049 | 5310 | 237 |
180440 | 180440 | 2020-05-26 | Franklin | Ohio | 39049 | 5414 | 239 |
183489 | 183489 | 2020-05-27 | Franklin | Ohio | 39049 | 5486 | 243 |
186546 | 186546 | 2020-05-28 | Franklin | Ohio | 39049 | 5566 | 253 |
189606 | 189606 | 2020-05-29 | Franklin | Ohio | 39049 | 5674 | 256 |
192670 | 192670 | 2020-05-30 | Franklin | Ohio | 39049 | 5773 | 260 |
195740 | 195740 | 2020-05-31 | Franklin | Ohio | 39049 | 5862 | 262 |
198813 | 198813 | 2020-06-01 | Franklin | Ohio | 39049 | 5933 | 271 |
201888 | 201888 | 2020-06-02 | Franklin | Ohio | 39049 | 5996 | 279 |
204965 | 204965 | 2020-06-03 | Franklin | Ohio | 39049 | 6112 | 290 |
208046 | 208046 | 2020-06-04 | Franklin | Ohio | 39049 | 6216 | 293 |
211128 | 211128 | 2020-06-05 | Franklin | Ohio | 39049 | 6323 | 295 |
214214 | 214214 | 2020-06-06 | Franklin | Ohio | 39049 | 6406 | 297 |
217304 | 217304 | 2020-06-07 | Franklin | Ohio | 39049 | 6512 | 299 |
220396 | 220396 | 2020-06-08 | Franklin | Ohio | 39049 | 6586 | 300 |
223491 | 223491 | 2020-06-09 | Franklin | Ohio | 39049 | 6667 | 303 |
226591 | 226591 | 2020-06-10 | Franklin | Ohio | 39049 | 6741 | 313 |
229695 | 229695 | 2020-06-11 | Franklin | Ohio | 39049 | 6844 | 320 |
232800 | 232800 | 2020-06-12 | Franklin | Ohio | 39049 | 6918 | 325 |
235905 | 235905 | 2020-06-13 | Franklin | Ohio | 39049 | 7030 | 329 |
239013 | 239013 | 2020-06-14 | Franklin | Ohio | 39049 | 7076 | 329 |
242122 | 242122 | 2020-06-15 | Franklin | Ohio | 39049 | 7202 | 332 |
245234 | 245234 | 2020-06-16 | Franklin | Ohio | 39049 | 7289 | 334 |
248347 | 248347 | 2020-06-17 | Franklin | Ohio | 39049 | 7365 | 337 |
251462 | 251462 | 2020-06-18 | Franklin | Ohio | 39049 | 7487 | 342 |
254577 | 254577 | 2020-06-19 | Franklin | Ohio | 39049 | 7590 | 348 |
257702 | 257702 | 2020-06-20 | Franklin | Ohio | 39049 | 7694 | 357 |
260829 | 260829 | 2020-06-21 | Franklin | Ohio | 39049 | 7794 | 358 |
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);