johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
307 rows where country_or_region = "US", deaths = 52 and province_or_state = "Ohio" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1364850 | 1364850 | 2022-02-08 | US | Ohio | Morgan | 39115 | 3134 | 52 | 0 | 39.62081738 | -81.85308173 | 2022-02-09 04:21:04 | Morgan, Ohio, US | |
73588 | 73588 | 2022-02-07 | US | Ohio | Morgan | 39115 | 3120 | 52 | 0 | 39.62081738 | -81.85308173 | 2022-02-08 04:21:15 | Morgan, Ohio, US | |
3812455 | 3812455 | 2022-01-28 | US | Ohio | Vinton | 39163 | 2681 | 52 | 0 | 39.25208988 | -82.4831444 | 2022-01-29 04:21:10 | Vinton, Ohio, US | |
1781909 | 1781909 | 2022-01-27 | US | Ohio | Vinton | 39163 | 2657 | 52 | 0 | 39.25208988 | -82.4831444 | 2022-01-28 04:21:09 | Vinton, Ohio, US | |
1320737 | 1320737 | 2022-01-26 | US | Ohio | Vinton | 39163 | 2631 | 52 | 0 | 39.25208988 | -82.4831444 | 2022-01-27 04:21:19 | Vinton, Ohio, US | |
3843011 | 3843011 | 2022-01-15 | US | Ohio | Noble | 39121 | 2768 | 52 | 0 | 39.76818851 | -81.45937183 | 2022-01-16 04:21:12 | Noble, Ohio, US | |
101826 | 101826 | 2022-01-14 | US | Ohio | Noble | 39121 | 2716 | 52 | 0 | 39.76818851 | -81.45937183 | 2022-01-15 04:21:07 | Noble, Ohio, US | |
3689981 | 3689981 | 2022-01-13 | US | Ohio | Noble | 39121 | 2672 | 52 | 0 | 39.76818851 | -81.45937183 | 2022-01-14 04:21:54 | Noble, Ohio, US | |
3615565 | 3615565 | 2022-01-12 | US | Ohio | Noble | 39121 | 2635 | 52 | 0 | 39.76818851 | -81.45937183 | 2022-01-13 08:00:09 | Noble, Ohio, US | |
906681 | 906681 | 2021-11-24 | US | Ohio | Paulding | 39125 | 3144 | 52 | 0 | 41.11676341 | -84.5801017 | 2021-11-25 04:22:33 | Paulding, Ohio, US | |
3072531 | 3072531 | 2021-11-23 | US | Ohio | Paulding | 39125 | 3125 | 52 | 0 | 41.11676341 | -84.5801017 | 2021-11-24 04:22:14 | Paulding, Ohio, US | |
3751629 | 3751629 | 2021-11-22 | US | Ohio | Paulding | 39125 | 3105 | 52 | 0 | 41.11676341 | -84.5801017 | 2021-11-23 04:22:39 | Paulding, Ohio, US | |
3513877 | 3513877 | 2021-11-01 | US | Ohio | Harrison | 39067 | 1861 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-11-02 04:22:03 | Harrison, Ohio, US | |
290468 | 290468 | 2021-10-31 | US | Ohio | Harrison | 39067 | 1855 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-11-01 04:22:01 | Harrison, Ohio, US | |
2723474 | 2723474 | 2021-10-30 | US | Ohio | Harrison | 39067 | 1853 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-10-31 04:22:08 | Harrison, Ohio, US | |
569576 | 569576 | 2021-10-29 | US | Ohio | Harrison | 39067 | 1848 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-10-30 04:22:03 | Harrison, Ohio, US | |
6818 | 6818 | 2021-10-28 | US | Ohio | Harrison | 39067 | 1843 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-10-29 04:22:03 | Harrison, Ohio, US | |
537208 | 537208 | 2021-10-27 | US | Ohio | Harrison | 39067 | 1837 | 52 | 0 | 40.29380509 | -81.09068544 | 2021-10-28 04:22:08 | Harrison, Ohio, US | |
425842 | 425842 | 2021-10-10 | US | Ohio | Meigs | 39105 | 2486 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-11 04:21:31 | Meigs, Ohio, US | |
2878699 | 2878699 | 2021-10-09 | US | Ohio | Meigs | 39105 | 2457 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-10 04:21:38 | Meigs, Ohio, US | |
2961865 | 2961865 | 2021-10-08 | US | Ohio | Meigs | 39105 | 2456 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-09 04:21:34 | Meigs, Ohio, US | |
469903 | 469903 | 2021-10-07 | US | Ohio | Meigs | 39105 | 2444 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-08 04:21:25 | Meigs, Ohio, US | |
2461283 | 2461283 | 2021-10-06 | US | Ohio | Meigs | 39105 | 2422 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-07 04:21:36 | Meigs, Ohio, US | |
3834976 | 3834976 | 2021-10-05 | US | Ohio | Meigs | 39105 | 2402 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-06 04:21:33 | Meigs, Ohio, US | |
989469 | 989469 | 2021-10-04 | US | Ohio | Meigs | 39105 | 2384 | 52 | 0 | 39.09224872 | -82.0305041 | 2021-10-05 04:21:27 | Meigs, Ohio, US | |
812068 | 812068 | 2021-09-20 | US | Ohio | Monroe | 39111 | 1867 | 52 | 0 | 39.72984936 | -81.08464734 | 2021-09-21 04:21:26 | Monroe, Ohio, US | |
2811265 | 2811265 | 2021-09-16 | US | Ohio | Union | 39159 | 7092 | 52 | 0 | 40.30016061 | -83.37239023 | 2021-09-17 04:21:46 | Union, Ohio, US | |
1377009 | 1377009 | 2021-09-15 | US | Ohio | Union | 39159 | 7035 | 52 | 0 | 40.30016061 | -83.37239023 | 2021-09-16 04:22:19 | Union, Ohio, US | |
2465308 | 2465308 | 2021-09-14 | US | Ohio | Union | 39159 | 7004 | 52 | 0 | 40.30016061 | -83.37239023 | 2021-09-15 03:22:37 | Union, Ohio, US | |
644437 | 644437 | 2021-09-07 | US | Ohio | Perry | 39127 | 3676 | 52 | 0 | 39.73508655 | -82.23804971 | 2021-09-08 04:21:31 | Perry, Ohio, US | |
180471 | 180471 | 2021-09-02 | US | Ohio | Carroll | 39019 | 2286 | 52 | 0 | 40.578968599999996 | -81.09178213 | 2021-09-03 04:21:20 | Carroll, Ohio, US | |
69506 | 69506 | 2021-09-01 | US | Ohio | Carroll | 39019 | 2253 | 52 | 0 | 40.578968599999996 | -81.09178213 | 2021-09-02 04:21:15 | Carroll, Ohio, US | |
3894390 | 3894390 | 2021-08-29 | US | Ohio | Fayette | 39047 | 3163 | 52 | 0 | 39.56021306 | -83.4562016 | 2021-08-30 04:21:23 | Fayette, Ohio, US | |
2795493 | 2795493 | 2021-08-28 | US | Ohio | Fayette | 39047 | 3149 | 52 | 0 | 39.56021306 | -83.4562016 | 2021-08-29 04:21:14 | Fayette, Ohio, US | |
2925652 | 2925652 | 2021-08-27 | US | Ohio | Fayette | 39047 | 3119 | 52 | 0 | 39.56021306 | -83.4562016 | 2021-08-28 04:21:28 | Fayette, Ohio, US | |
1598666 | 1598666 | 2021-08-26 | US | Ohio | Fayette | 39047 | 3091 | 52 | 0 | 39.56021306 | -83.4562016 | 2021-08-27 04:21:37 | Fayette, Ohio, US | |
2206102 | 2206102 | 2021-08-07 | US | Ohio | Gallia | 39053 | 2574 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-08 04:21:33 | Gallia, Ohio, US | |
1120052 | 1120052 | 2021-08-06 | US | Ohio | Gallia | 39053 | 2572 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-07 04:21:30 | Gallia, Ohio, US | |
1958989 | 1958989 | 2021-08-05 | US | Ohio | Gallia | 39053 | 2566 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-06 04:21:18 | Gallia, Ohio, US | |
334368 | 334368 | 2021-08-04 | US | Ohio | Gallia | 39053 | 2561 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-05 04:21:51 | Gallia, Ohio, US | |
3470639 | 3470639 | 2021-08-03 | US | Ohio | Gallia | 39053 | 2541 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-04 04:21:25 | Gallia, Ohio, US | |
3685913 | 3685913 | 2021-08-02 | US | Ohio | Gallia | 39053 | 2527 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-03 04:21:39 | Gallia, Ohio, US | |
3017812 | 3017812 | 2021-08-01 | US | Ohio | Gallia | 39053 | 2524 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-02 04:21:36 | Gallia, Ohio, US | |
3906435 | 3906435 | 2021-07-31 | US | Ohio | Gallia | 39053 | 2521 | 52 | 0 | 38.82708533 | -82.31647569 | 2021-08-01 04:21:50 | Gallia, Ohio, US | |
1915673 | 1915673 | 2021-05-20 | US | Ohio | Guernsey | 39059 | 3196 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-21 04:20:43 | Guernsey, Ohio, US | |
2258194 | 2258194 | 2021-05-19 | US | Ohio | Guernsey | 39059 | 3187 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-20 04:21:05 | Guernsey, Ohio, US | |
2393232 | 2393232 | 2021-05-18 | US | Ohio | Guernsey | 39059 | 3180 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-19 04:20:42 | Guernsey, Ohio, US | |
3577057 | 3577057 | 2021-05-17 | US | Ohio | Guernsey | 39059 | 3176 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-18 04:20:33 | Guernsey, Ohio, US | |
2941787 | 2941787 | 2021-05-16 | US | Ohio | Guernsey | 39059 | 3173 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-17 04:20:34 | Guernsey, Ohio, US | |
1875417 | 1875417 | 2021-05-15 | US | Ohio | Guernsey | 39059 | 3173 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-16 04:20:49 | Guernsey, Ohio, US | |
1084386 | 1084386 | 2021-05-14 | US | Ohio | Guernsey | 39059 | 3173 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-15 04:20:58 | Guernsey, Ohio, US | |
3056652 | 3056652 | 2021-05-13 | US | Ohio | Guernsey | 39059 | 3173 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-14 04:20:41 | Guernsey, Ohio, US | |
2007122 | 2007122 | 2021-05-12 | US | Ohio | Guernsey | 39059 | 3169 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-13 04:20:51 | Guernsey, Ohio, US | |
3956953 | 3956953 | 2021-05-11 | US | Ohio | Guernsey | 39059 | 3162 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-12 04:21:29 | Guernsey, Ohio, US | |
2823232 | 2823232 | 2021-05-10 | US | Ohio | Guernsey | 39059 | 3160 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-11 04:20:41 | Guernsey, Ohio, US | |
1427564 | 1427564 | 2021-05-09 | US | Ohio | Guernsey | 39059 | 3156 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-10 04:20:38 | Guernsey, Ohio, US | |
1554432 | 1554432 | 2021-05-08 | US | Ohio | Guernsey | 39059 | 3156 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-09 04:20:35 | Guernsey, Ohio, US | |
2504490 | 2504490 | 2021-05-07 | US | Ohio | Guernsey | 39059 | 3156 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-08 04:21:04 | Guernsey, Ohio, US | |
3115946 | 3115946 | 2021-05-06 | US | Ohio | Guernsey | 39059 | 3154 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-07 04:20:40 | Guernsey, Ohio, US | |
648413 | 648413 | 2021-05-05 | US | Ohio | Guernsey | 39059 | 3153 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-06 04:20:38 | Guernsey, Ohio, US | |
3678113 | 3678113 | 2021-05-04 | US | Ohio | Guernsey | 39059 | 3144 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-05 04:20:43 | Guernsey, Ohio, US | |
2763380 | 2763380 | 2021-05-03 | US | Ohio | Guernsey | 39059 | 3142 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-04 04:20:34 | Guernsey, Ohio, US | |
2453233 | 2453233 | 2021-05-02 | US | Ohio | Guernsey | 39059 | 3137 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-03 04:20:39 | Guernsey, Ohio, US | |
2827246 | 2827246 | 2021-05-01 | US | Ohio | Guernsey | 39059 | 3136 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-02 04:20:48 | Guernsey, Ohio, US | |
2827256 | 2827256 | 2021-05-01 | US | Ohio | Jackson | 39079 | 3114 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-05-02 04:20:48 | Jackson, Ohio, US | |
382654 | 382654 | 2021-04-30 | US | Ohio | Guernsey | 39059 | 3131 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-05-01 04:20:47 | Guernsey, Ohio, US | |
382664 | 382664 | 2021-04-30 | US | Ohio | Jackson | 39079 | 3113 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-05-01 04:20:47 | Jackson, Ohio, US | |
1638777 | 1638777 | 2021-04-29 | US | Ohio | Guernsey | 39059 | 3124 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-30 04:21:03 | Guernsey, Ohio, US | |
1638787 | 1638787 | 2021-04-29 | US | Ohio | Jackson | 39079 | 3112 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-30 04:21:03 | Jackson, Ohio, US | |
3395856 | 3395856 | 2021-04-28 | US | Ohio | Guernsey | 39059 | 3116 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-29 04:20:55 | Guernsey, Ohio, US | |
3395866 | 3395866 | 2021-04-28 | US | Ohio | Jackson | 39079 | 3109 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-29 04:20:55 | Jackson, Ohio, US | |
3704572 | 3704572 | 2021-04-27 | US | Ohio | Guernsey | 39059 | 3112 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-28 04:20:32 | Guernsey, Ohio, US | |
3704582 | 3704582 | 2021-04-27 | US | Ohio | Jackson | 39079 | 3108 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-28 04:20:32 | Jackson, Ohio, US | |
890581 | 890581 | 2021-04-26 | US | Ohio | Guernsey | 39059 | 3107 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-27 04:20:52 | Guernsey, Ohio, US | |
890591 | 890591 | 2021-04-26 | US | Ohio | Jackson | 39079 | 3105 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-27 04:20:52 | Jackson, Ohio, US | |
957326 | 957326 | 2021-04-25 | US | Ohio | Guernsey | 39059 | 3103 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-26 04:21:04 | Guernsey, Ohio, US | |
957336 | 957336 | 2021-04-25 | US | Ohio | Jackson | 39079 | 3105 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-26 04:21:04 | Jackson, Ohio, US | |
3926473 | 3926473 | 2021-04-24 | US | Ohio | Guernsey | 39059 | 3100 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-25 04:20:32 | Guernsey, Ohio, US | |
3926483 | 3926483 | 2021-04-24 | US | Ohio | Jackson | 39079 | 3101 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-25 04:20:32 | Jackson, Ohio, US | |
1411504 | 1411504 | 2021-04-23 | US | Ohio | Guernsey | 39059 | 3093 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-24 04:20:38 | Guernsey, Ohio, US | |
1411514 | 1411514 | 2021-04-23 | US | Ohio | Jackson | 39079 | 3099 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-24 04:20:38 | Jackson, Ohio, US | |
1570567 | 1570567 | 2021-04-22 | US | Ohio | Guernsey | 39059 | 3089 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-23 04:20:52 | Guernsey, Ohio, US | |
1570577 | 1570577 | 2021-04-22 | US | Ohio | Jackson | 39079 | 3095 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-23 04:20:52 | Jackson, Ohio, US | |
3244788 | 3244788 | 2021-04-21 | US | Ohio | Guernsey | 39059 | 3087 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-22 04:20:53 | Guernsey, Ohio, US | |
3244798 | 3244798 | 2021-04-21 | US | Ohio | Jackson | 39079 | 3093 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-22 04:20:53 | Jackson, Ohio, US | |
2023184 | 2023184 | 2021-04-20 | US | Ohio | Guernsey | 39059 | 3082 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-21 04:21:14 | Guernsey, Ohio, US | |
2023194 | 2023194 | 2021-04-20 | US | Ohio | Jackson | 39079 | 3088 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-21 04:21:14 | Jackson, Ohio, US | |
2413305 | 2413305 | 2021-04-19 | US | Ohio | Guernsey | 39059 | 3075 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-20 04:20:41 | Guernsey, Ohio, US | |
2413315 | 2413315 | 2021-04-19 | US | Ohio | Jackson | 39079 | 3085 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-20 04:20:41 | Jackson, Ohio, US | |
3131982 | 3131982 | 2021-04-18 | US | Ohio | Guernsey | 39059 | 3067 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-19 04:20:57 | Guernsey, Ohio, US | |
3131992 | 3131992 | 2021-04-18 | US | Ohio | Jackson | 39079 | 3085 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-19 04:20:57 | Jackson, Ohio, US | |
985410 | 985410 | 2021-04-17 | US | Ohio | Guernsey | 39059 | 3066 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-18 04:20:41 | Guernsey, Ohio, US | |
985420 | 985420 | 2021-04-17 | US | Ohio | Jackson | 39079 | 3084 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-18 04:20:41 | Jackson, Ohio, US | |
172505 | 172505 | 2021-04-16 | US | Ohio | Guernsey | 39059 | 3061 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-17 04:20:40 | Guernsey, Ohio, US | |
172515 | 172515 | 2021-04-16 | US | Ohio | Jackson | 39079 | 3079 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-17 04:20:40 | Jackson, Ohio, US | |
2551336 | 2551336 | 2021-04-15 | US | Ohio | Guernsey | 39059 | 3058 | 52 | 0 | 40.05026529 | -81.49248905 | 2021-04-16 04:20:46 | Guernsey, Ohio, US | |
2551346 | 2551346 | 2021-04-15 | US | Ohio | Jackson | 39079 | 3069 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-16 04:20:46 | Jackson, Ohio, US | |
1844416 | 1844416 | 2021-04-14 | US | Ohio | Jackson | 39079 | 3061 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-15 04:20:54 | Jackson, Ohio, US | |
2574150 | 2574150 | 2021-04-13 | US | Ohio | Jackson | 39079 | 3058 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-14 04:20:41 | Jackson, Ohio, US | |
38901 | 38901 | 2021-04-12 | US | Ohio | Jackson | 39079 | 3055 | 52 | 0 | 39.01914254 | -82.61818559999998 | 2021-04-13 04:20:37 | Jackson, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);