ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388001 | 388001 | 2020-07-31 | Franklin | Ohio | 39049 | 16842 | 511 |
384784 | 384784 | 2020-07-30 | Franklin | Ohio | 39049 | 16630 | 507 |
381566 | 381566 | 2020-07-29 | Franklin | Ohio | 39049 | 16311 | 502 |
378349 | 378349 | 2020-07-28 | Franklin | Ohio | 39049 | 16042 | 496 |
375132 | 375132 | 2020-07-27 | Franklin | Ohio | 39049 | 15862 | 494 |
371920 | 371920 | 2020-07-26 | Franklin | Ohio | 39049 | 15682 | 489 |
368708 | 368708 | 2020-07-25 | Franklin | Ohio | 39049 | 15548 | 487 |
365499 | 365499 | 2020-07-24 | Franklin | Ohio | 39049 | 15301 | 487 |
362293 | 362293 | 2020-07-23 | Franklin | Ohio | 39049 | 14993 | 484 |
359087 | 359087 | 2020-07-22 | Franklin | Ohio | 39049 | 14736 | 478 |
355883 | 355883 | 2020-07-21 | Franklin | Ohio | 39049 | 14432 | 475 |
352680 | 352680 | 2020-07-20 | Franklin | Ohio | 39049 | 14246 | 468 |
349477 | 349477 | 2020-07-19 | Franklin | Ohio | 39049 | 14001 | 467 |
346276 | 346276 | 2020-07-18 | Franklin | Ohio | 39049 | 13778 | 461 |
343077 | 343077 | 2020-07-17 | Franklin | Ohio | 39049 | 13412 | 457 |
339879 | 339879 | 2020-07-16 | Franklin | Ohio | 39049 | 13099 | 456 |
336683 | 336683 | 2020-07-15 | Franklin | Ohio | 39049 | 12823 | 449 |
333489 | 333489 | 2020-07-14 | Franklin | Ohio | 39049 | 12574 | 449 |
330297 | 330297 | 2020-07-13 | Franklin | Ohio | 39049 | 12301 | 449 |
327110 | 327110 | 2020-07-12 | Franklin | Ohio | 39049 | 12035 | 447 |
323925 | 323925 | 2020-07-11 | Franklin | Ohio | 39049 | 11724 | 445 |
320745 | 320745 | 2020-07-10 | Franklin | Ohio | 39049 | 11433 | 443 |
317568 | 317568 | 2020-07-09 | Franklin | Ohio | 39049 | 11122 | 439 |
314395 | 314395 | 2020-07-08 | Franklin | Ohio | 39049 | 10879 | 439 |
311223 | 311223 | 2020-07-07 | Franklin | Ohio | 39049 | 10587 | 431 |
308054 | 308054 | 2020-07-06 | Franklin | Ohio | 39049 | 10410 | 429 |
304887 | 304887 | 2020-07-05 | Franklin | Ohio | 39049 | 10271 | 422 |
301724 | 301724 | 2020-07-04 | Franklin | Ohio | 39049 | 10023 | 420 |
298561 | 298561 | 2020-07-03 | Franklin | Ohio | 39049 | 9825 | 417 |
295401 | 295401 | 2020-07-02 | Franklin | Ohio | 39049 | 9338 | 407 |
292246 | 292246 | 2020-07-01 | Franklin | Ohio | 39049 | 9338 | 407 |
289094 | 289094 | 2020-06-30 | Franklin | Ohio | 39049 | 9148 | 404 |
285944 | 285944 | 2020-06-29 | Franklin | Ohio | 39049 | 8982 | 395 |
282799 | 282799 | 2020-06-28 | Franklin | Ohio | 39049 | 8840 | 393 |
279653 | 279653 | 2020-06-27 | Franklin | Ohio | 39049 | 8694 | 392 |
276505 | 276505 | 2020-06-26 | Franklin | Ohio | 39049 | 8511 | 383 |
273358 | 273358 | 2020-06-25 | Franklin | Ohio | 39049 | 8310 | 378 |
270219 | 270219 | 2020-06-24 | Franklin | Ohio | 39049 | 8144 | 376 |
267085 | 267085 | 2020-06-23 | Franklin | Ohio | 39049 | 8029 | 370 |
263957 | 263957 | 2020-06-22 | Franklin | Ohio | 39049 | 7915 | 358 |
260829 | 260829 | 2020-06-21 | Franklin | Ohio | 39049 | 7794 | 358 |
257702 | 257702 | 2020-06-20 | Franklin | Ohio | 39049 | 7694 | 357 |
254577 | 254577 | 2020-06-19 | Franklin | Ohio | 39049 | 7590 | 348 |
251462 | 251462 | 2020-06-18 | Franklin | Ohio | 39049 | 7487 | 342 |
248347 | 248347 | 2020-06-17 | Franklin | Ohio | 39049 | 7365 | 337 |
245234 | 245234 | 2020-06-16 | Franklin | Ohio | 39049 | 7289 | 334 |
242122 | 242122 | 2020-06-15 | Franklin | Ohio | 39049 | 7202 | 332 |
239013 | 239013 | 2020-06-14 | Franklin | Ohio | 39049 | 7076 | 329 |
235905 | 235905 | 2020-06-13 | Franklin | Ohio | 39049 | 7030 | 329 |
232800 | 232800 | 2020-06-12 | Franklin | Ohio | 39049 | 6918 | 325 |
229695 | 229695 | 2020-06-11 | Franklin | Ohio | 39049 | 6844 | 320 |
226591 | 226591 | 2020-06-10 | Franklin | Ohio | 39049 | 6741 | 313 |
223491 | 223491 | 2020-06-09 | Franklin | Ohio | 39049 | 6667 | 303 |
220396 | 220396 | 2020-06-08 | Franklin | Ohio | 39049 | 6586 | 300 |
217304 | 217304 | 2020-06-07 | Franklin | Ohio | 39049 | 6512 | 299 |
214214 | 214214 | 2020-06-06 | Franklin | Ohio | 39049 | 6406 | 297 |
211128 | 211128 | 2020-06-05 | Franklin | Ohio | 39049 | 6323 | 295 |
208046 | 208046 | 2020-06-04 | Franklin | Ohio | 39049 | 6216 | 293 |
204965 | 204965 | 2020-06-03 | Franklin | Ohio | 39049 | 6112 | 290 |
201888 | 201888 | 2020-06-02 | Franklin | Ohio | 39049 | 5996 | 279 |
198813 | 198813 | 2020-06-01 | Franklin | Ohio | 39049 | 5933 | 271 |
195740 | 195740 | 2020-05-31 | Franklin | Ohio | 39049 | 5862 | 262 |
192670 | 192670 | 2020-05-30 | Franklin | Ohio | 39049 | 5773 | 260 |
189606 | 189606 | 2020-05-29 | Franklin | Ohio | 39049 | 5674 | 256 |
186546 | 186546 | 2020-05-28 | Franklin | Ohio | 39049 | 5566 | 253 |
183489 | 183489 | 2020-05-27 | Franklin | Ohio | 39049 | 5486 | 243 |
180440 | 180440 | 2020-05-26 | Franklin | Ohio | 39049 | 5414 | 239 |
177397 | 177397 | 2020-05-25 | Franklin | Ohio | 39049 | 5310 | 237 |
174353 | 174353 | 2020-05-24 | Franklin | Ohio | 39049 | 5188 | 228 |
171311 | 171311 | 2020-05-23 | Franklin | Ohio | 39049 | 5097 | 224 |
168272 | 168272 | 2020-05-22 | Franklin | Ohio | 39049 | 4996 | 215 |
165236 | 165236 | 2020-05-21 | Franklin | Ohio | 39049 | 4885 | 205 |
162207 | 162207 | 2020-05-20 | Franklin | Ohio | 39049 | 4793 | 200 |
159180 | 159180 | 2020-05-19 | Franklin | Ohio | 39049 | 4706 | 193 |
156160 | 156160 | 2020-05-18 | Franklin | Ohio | 39049 | 4574 | 177 |
153143 | 153143 | 2020-05-17 | Franklin | Ohio | 39049 | 4493 | 170 |
150132 | 150132 | 2020-05-16 | Franklin | Ohio | 39049 | 4420 | 169 |
147125 | 147125 | 2020-05-15 | Franklin | Ohio | 39049 | 4330 | 156 |
144124 | 144124 | 2020-05-14 | Franklin | Ohio | 39049 | 4227 | 150 |
141129 | 141129 | 2020-05-13 | Franklin | Ohio | 39049 | 4113 | 148 |
138133 | 138133 | 2020-05-12 | Franklin | Ohio | 39049 | 4002 | 138 |
135143 | 135143 | 2020-05-11 | Franklin | Ohio | 39049 | 3881 | 124 |
132152 | 132152 | 2020-05-10 | Franklin | Ohio | 39049 | 3777 | 119 |
129163 | 129163 | 2020-05-09 | Franklin | Ohio | 39049 | 3710 | 114 |
126174 | 126174 | 2020-05-08 | Franklin | Ohio | 39049 | 3615 | 108 |
123191 | 123191 | 2020-05-07 | Franklin | Ohio | 39049 | 3377 | 107 |
120214 | 120214 | 2020-05-06 | Franklin | Ohio | 39049 | 3237 | 99 |
117253 | 117253 | 2020-05-05 | Franklin | Ohio | 39049 | 3097 | 87 |
114372 | 114372 | 2020-05-04 | Franklin | Ohio | 39049 | 2988 | 84 |
111491 | 111491 | 2020-05-03 | Franklin | Ohio | 39049 | 2905 | 79 |
108617 | 108617 | 2020-05-02 | Franklin | Ohio | 39049 | 2698 | 78 |
105750 | 105750 | 2020-05-01 | Franklin | Ohio | 39049 | 2589 | 76 |
102887 | 102887 | 2020-04-30 | Franklin | Ohio | 39049 | 2441 | 73 |
100034 | 100034 | 2020-04-29 | Franklin | Ohio | 39049 | 2216 | 71 |
97185 | 97185 | 2020-04-28 | Franklin | Ohio | 39049 | 2090 | 62 |
94348 | 94348 | 2020-04-27 | Franklin | Ohio | 39049 | 2005 | 57 |
91522 | 91522 | 2020-04-26 | Franklin | Ohio | 39049 | 1942 | 53 |
88706 | 88706 | 2020-04-25 | Franklin | Ohio | 39049 | 1839 | 50 |
85892 | 85892 | 2020-04-24 | Franklin | Ohio | 39049 | 1768 | 48 |
83088 | 83088 | 2020-04-23 | Franklin | Ohio | 39049 | 1673 | 46 |
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);