johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where country_or_region = "US", deaths = 87 and province_or_state = "Pennsylvania" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1060541 | 1060541 | 2022-02-23 | US | Pennsylvania | Montour | 42093 | 4433 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-24 04:21:14 | Montour, Pennsylvania, US | |
2449464 | 2449464 | 2022-02-22 | US | Pennsylvania | Montour | 42093 | 4426 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-23 04:21:09 | Montour, Pennsylvania, US | |
3720877 | 3720877 | 2022-02-21 | US | Pennsylvania | Montour | 42093 | 4419 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-22 04:21:01 | Montour, Pennsylvania, US | |
3914711 | 3914711 | 2022-02-20 | US | Pennsylvania | Montour | 42093 | 4419 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-21 04:21:05 | Montour, Pennsylvania, US | |
3878269 | 3878269 | 2022-02-19 | US | Pennsylvania | Montour | 42093 | 4413 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-20 04:21:00 | Montour, Pennsylvania, US | |
3858525 | 3858525 | 2022-02-18 | US | Pennsylvania | Montour | 42093 | 4406 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-19 04:21:11 | Montour, Pennsylvania, US | |
1300744 | 1300744 | 2022-02-17 | US | Pennsylvania | Montour | 42093 | 4400 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-18 04:21:04 | Montour, Pennsylvania, US | |
3823130 | 3823130 | 2022-02-16 | US | Pennsylvania | Montour | 42093 | 4393 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-17 04:20:56 | Montour, Pennsylvania, US | |
3674344 | 3674344 | 2022-02-15 | US | Pennsylvania | Montour | 42093 | 4382 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-16 04:21:10 | Montour, Pennsylvania, US | |
2644445 | 2644445 | 2022-02-14 | US | Pennsylvania | Montour | 42093 | 4374 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-15 04:21:09 | Montour, Pennsylvania, US | |
188762 | 188762 | 2022-02-13 | US | Pennsylvania | Montour | 42093 | 4370 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-14 04:20:51 | Montour, Pennsylvania, US | |
318608 | 318608 | 2022-02-12 | US | Pennsylvania | Montour | 42093 | 4368 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-13 04:21:00 | Montour, Pennsylvania, US | |
235934 | 235934 | 2022-02-11 | US | Pennsylvania | Montour | 42093 | 4366 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-12 04:21:06 | Montour, Pennsylvania, US | |
1466776 | 1466776 | 2022-02-10 | US | Pennsylvania | Montour | 42093 | 4351 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-11 04:21:09 | Montour, Pennsylvania, US | |
73788 | 73788 | 2022-02-07 | US | Pennsylvania | Potter | 42105 | 3020 | 87 | 0 | 41.74471626 | -77.89559864 | 2022-02-08 04:21:15 | Potter, Pennsylvania, US | |
2015404 | 2015404 | 2022-02-06 | US | Pennsylvania | Potter | 42105 | 3016 | 87 | 0 | 41.74471626 | -77.89559864 | 2022-02-07 04:21:05 | Potter, Pennsylvania, US | |
1296733 | 1296733 | 2022-02-05 | US | Pennsylvania | Potter | 42105 | 3012 | 87 | 0 | 41.74471626 | -77.89559864 | 2022-02-06 04:21:00 | Potter, Pennsylvania, US | |
2330061 | 2330061 | 2022-02-04 | US | Pennsylvania | Potter | 42105 | 3003 | 87 | 0 | 41.74471626 | -77.89559864 | 2022-02-05 04:21:05 | Potter, Pennsylvania, US | |
1288708 | 1288708 | 2022-01-04 | US | Pennsylvania | Susquehanna | 42115 | 5947 | 87 | 0 | 41.82147784 | -75.80071959 | 2022-01-05 04:21:59 | Susquehanna, Pennsylvania, US | |
4001362 | 4001362 | 2021-12-30 | US | Pennsylvania | Wyoming | 42131 | 3764 | 87 | 0 | 41.51955538 | -76.01074915 | 2021-12-31 04:21:50 | Wyoming, Pennsylvania, US | |
3796580 | 3796580 | 2021-10-25 | US | Pennsylvania | McKean | 42083 | 5135 | 87 | 0 | 41.80938602 | -78.56478358 | 2021-10-26 04:22:09 | McKean, Pennsylvania, US | |
685026 | 685026 | 2021-10-24 | US | Pennsylvania | McKean | 42083 | 5124 | 87 | 0 | 41.80938602 | -78.56478358 | 2021-10-25 04:22:31 | McKean, Pennsylvania, US | |
1265484 | 1265484 | 2021-09-09 | US | Pennsylvania | Snyder | 42109 | 3989 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-10 04:21:20 | Snyder, Pennsylvania, US | |
2281854 | 2281854 | 2021-09-08 | US | Pennsylvania | Snyder | 42109 | 3978 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-09 04:21:27 | Snyder, Pennsylvania, US | |
644633 | 644633 | 2021-09-07 | US | Pennsylvania | Snyder | 42109 | 3958 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-08 04:21:31 | Snyder, Pennsylvania, US | |
3196696 | 3196696 | 2021-09-06 | US | Pennsylvania | Snyder | 42109 | 3958 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-07 04:21:35 | Snyder, Pennsylvania, US | |
3283564 | 3283564 | 2021-09-05 | US | Pennsylvania | Snyder | 42109 | 3951 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-06 04:21:22 | Snyder, Pennsylvania, US | |
251978 | 251978 | 2021-09-04 | US | Pennsylvania | Snyder | 42109 | 3943 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-05 04:21:33 | Snyder, Pennsylvania, US | |
3977259 | 3977259 | 2021-09-03 | US | Pennsylvania | Snyder | 42109 | 3931 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-04 04:21:28 | Snyder, Pennsylvania, US | |
180721 | 180721 | 2021-09-02 | US | Pennsylvania | Snyder | 42109 | 3923 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-03 04:21:20 | Snyder, Pennsylvania, US | |
69756 | 69756 | 2021-09-01 | US | Pennsylvania | Snyder | 42109 | 3916 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-02 04:21:15 | Snyder, Pennsylvania, US | |
2070598 | 2070598 | 2021-08-31 | US | Pennsylvania | Snyder | 42109 | 3897 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-09-01 04:21:38 | Snyder, Pennsylvania, US | |
1778052 | 1778052 | 2021-08-30 | US | Pennsylvania | Snyder | 42109 | 3888 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-31 04:21:46 | Snyder, Pennsylvania, US | |
3894626 | 3894626 | 2021-08-29 | US | Pennsylvania | Snyder | 42109 | 3884 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-30 04:21:23 | Snyder, Pennsylvania, US | |
2795729 | 2795729 | 2021-08-28 | US | Pennsylvania | Snyder | 42109 | 3877 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-29 04:21:14 | Snyder, Pennsylvania, US | |
2925888 | 2925888 | 2021-08-27 | US | Pennsylvania | Snyder | 42109 | 3875 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-28 04:21:28 | Snyder, Pennsylvania, US | |
1598902 | 1598902 | 2021-08-26 | US | Pennsylvania | Snyder | 42109 | 3868 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-27 04:21:37 | Snyder, Pennsylvania, US | |
35111 | 35111 | 2021-08-25 | US | Pennsylvania | Snyder | 42109 | 3863 | 87 | 0 | 40.77129231 | -77.06840691 | 2021-08-26 04:21:28 | Snyder, Pennsylvania, US | |
3361342 | 3361342 | 2021-06-21 | US | Pennsylvania | Juniata | 42067 | 2165 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-22 04:21:34 | Juniata, Pennsylvania, US | |
2887041 | 2887041 | 2021-06-20 | US | Pennsylvania | Juniata | 42067 | 2165 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-21 04:21:41 | Juniata, Pennsylvania, US | |
110124 | 110124 | 2021-06-19 | US | Pennsylvania | Juniata | 42067 | 2165 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-20 04:21:48 | Juniata, Pennsylvania, US | |
1128267 | 1128267 | 2021-06-18 | US | Pennsylvania | Juniata | 42067 | 2165 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-19 04:22:33 | Juniata, Pennsylvania, US | |
2913845 | 2913845 | 2021-06-17 | US | Pennsylvania | Juniata | 42067 | 2164 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-18 04:22:16 | Juniata, Pennsylvania, US | |
3032961 | 3032961 | 2021-06-16 | US | Pennsylvania | Juniata | 42067 | 2163 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-17 04:22:36 | Juniata, Pennsylvania, US | |
2342067 | 2342067 | 2021-06-15 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-16 04:22:32 | Juniata, Pennsylvania, US | |
1566763 | 1566763 | 2021-06-14 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-15 04:22:22 | Juniata, Pennsylvania, US | |
3384046 | 3384046 | 2021-06-13 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-14 04:22:46 | Juniata, Pennsylvania, US | |
1739180 | 1739180 | 2021-06-12 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-13 04:22:44 | Juniata, Pennsylvania, US | |
3973221 | 3973221 | 2021-06-11 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-12 04:22:22 | Juniata, Pennsylvania, US | |
2719643 | 2719643 | 2021-06-10 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-11 04:23:20 | Juniata, Pennsylvania, US | |
525528 | 525528 | 2021-06-09 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-10 04:23:17 | Juniata, Pennsylvania, US | |
3474968 | 3474968 | 2021-06-08 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-09 04:23:31 | Juniata, Pennsylvania, US | |
3148252 | 3148252 | 2021-06-07 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-08 04:22:35 | Juniata, Pennsylvania, US | |
828254 | 828254 | 2021-06-06 | US | Pennsylvania | Juniata | 42067 | 2161 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-07 04:22:51 | Juniata, Pennsylvania, US | |
2588659 | 2588659 | 2021-06-05 | US | Pennsylvania | Juniata | 42067 | 2159 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-06 04:24:03 | Juniata, Pennsylvania, US | |
2317973 | 2317973 | 2021-06-04 | US | Pennsylvania | Juniata | 42067 | 2158 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-05 04:23:03 | Juniata, Pennsylvania, US | |
1451258 | 1451258 | 2021-06-03 | US | Pennsylvania | Juniata | 42067 | 2158 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-04 04:23:37 | Juniata, Pennsylvania, US | |
1710982 | 1710982 | 2021-06-02 | US | Pennsylvania | Juniata | 42067 | 2158 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-03 04:23:32 | Juniata, Pennsylvania, US | |
2106800 | 2106800 | 2021-06-01 | US | Pennsylvania | Juniata | 42067 | 2156 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-02 04:24:34 | Juniata, Pennsylvania, US | |
2106827 | 2106827 | 2021-06-01 | US | Pennsylvania | Union | 42119 | 6150 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-06-02 04:24:34 | Union, Pennsylvania, US | |
1191416 | 1191416 | 2021-05-31 | US | Pennsylvania | Juniata | 42067 | 2155 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-06-01 04:23:09 | Juniata, Pennsylvania, US | |
1191443 | 1191443 | 2021-05-31 | US | Pennsylvania | Union | 42119 | 6149 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-06-01 04:23:09 | Union, Pennsylvania, US | |
3092093 | 3092093 | 2021-05-30 | US | Pennsylvania | Juniata | 42067 | 2155 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-05-31 03:08:59 | Juniata, Pennsylvania, US | |
3092120 | 3092120 | 2021-05-30 | US | Pennsylvania | Union | 42119 | 6148 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-31 03:08:59 | Union, Pennsylvania, US | |
53462 | 53462 | 2021-05-29 | US | Pennsylvania | Juniata | 42067 | 2155 | 87 | 0 | 40.53358749 | -77.39975129999998 | 2021-05-30 04:20:55 | Juniata, Pennsylvania, US | |
53489 | 53489 | 2021-05-29 | US | Pennsylvania | Union | 42119 | 6146 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-30 04:20:55 | Union, Pennsylvania, US | |
23068 | 23068 | 2021-05-28 | US | Pennsylvania | Union | 42119 | 6145 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-29 04:20:41 | Union, Pennsylvania, US | |
1809443 | 1809443 | 2021-05-27 | US | Pennsylvania | Union | 42119 | 6140 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-28 04:20:36 | Union, Pennsylvania, US | |
1312866 | 1312866 | 2021-05-26 | US | Pennsylvania | Union | 42119 | 6135 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-27 04:20:59 | Union, Pennsylvania, US | |
85792 | 85792 | 2021-05-25 | US | Pennsylvania | Union | 42119 | 6132 | 87 | 0 | 40.96188846 | -77.05996014 | 2021-05-26 04:20:35 | Union, Pennsylvania, US | |
1638960 | 1638960 | 2021-04-29 | US | Pennsylvania | Bradford | 42015 | 5644 | 87 | 0 | 41.78869215 | -76.51570822 | 2021-04-30 04:21:03 | Bradford, Pennsylvania, US | |
2783644 | 2783644 | 2021-03-24 | US | Pennsylvania | Clarion | 42031 | 2805 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-25 05:27:00 | Clarion, Pennsylvania, US | |
1801289 | 1801289 | 2021-03-23 | US | Pennsylvania | Clarion | 42031 | 2797 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-24 05:25:40 | Clarion, Pennsylvania, US | |
1206457 | 1206457 | 2021-03-22 | US | Pennsylvania | Clarion | 42031 | 2793 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-23 05:26:18 | Clarion, Pennsylvania, US | |
3371979 | 3371979 | 2021-03-21 | US | Pennsylvania | Clarion | 42031 | 2793 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-22 05:25:43 | Clarion, Pennsylvania, US | |
1747189 | 1747189 | 2021-03-20 | US | Pennsylvania | Clarion | 42031 | 2788 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-21 05:25:44 | Clarion, Pennsylvania, US | |
3423569 | 3423569 | 2021-03-19 | US | Pennsylvania | Clarion | 42031 | 2784 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-20 05:25:46 | Clarion, Pennsylvania, US | |
3455507 | 3455507 | 2021-03-18 | US | Pennsylvania | Clarion | 42031 | 2781 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-19 05:26:09 | Clarion, Pennsylvania, US | |
3623731 | 3623731 | 2021-03-17 | US | Pennsylvania | Clarion | 42031 | 2774 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-18 05:26:22 | Clarion, Pennsylvania, US | |
705055 | 705055 | 2021-03-16 | US | Pennsylvania | Clarion | 42031 | 2766 | 87 | 0 | 41.19265812 | -79.42413524 | 2021-03-17 05:25:07 | Clarion, Pennsylvania, US | |
2058567 | 2058567 | 2021-03-15 | US | Pennsylvania | Perry | 42099 | 3014 | 87 | 0 | 40.40206612 | -77.26297447 | 2021-03-16 05:25:13 | Perry, Pennsylvania, US | |
3965216 | 3965216 | 2021-03-10 | US | Pennsylvania | Venango | 42121 | 3466 | 87 | 0 | 41.40323442 | -79.75845449 | 2021-03-11 05:25:48 | Venango, Pennsylvania, US | |
3666304 | 3666304 | 2021-03-09 | US | Pennsylvania | Venango | 42121 | 3462 | 87 | 0 | 41.40323442 | -79.75845449 | 2021-03-10 05:24:35 | Venango, Pennsylvania, US | |
2362163 | 2362163 | 2021-03-08 | US | Pennsylvania | Venango | 42121 | 3452 | 87 | 0 | 41.40323442 | -79.75845449 | 2021-03-09 05:28:19 | Venango, Pennsylvania, US | |
282850 | 282850 | 2021-02-24 | US | Pennsylvania | Jefferson | 42065 | 2777 | 87 | 0 | 2690 | 41.12913106 | -78.9986361 | 2021-02-25 05:24:57 | Jefferson, Pennsylvania, US |
2469498 | 2469498 | 2021-01-22 | US | Pennsylvania | Tioga | 42117 | 2197 | 87 | 0 | 2110 | 41.77255149 | -77.25433032 | 2021-01-23 05:22:03 | Tioga, Pennsylvania, US |
438049 | 438049 | 2021-01-21 | US | Pennsylvania | Tioga | 42117 | 2189 | 87 | 0 | 2102 | 41.77255149 | -77.25433032 | 2021-01-22 05:22:10 | Tioga, Pennsylvania, US |
1096780 | 1096780 | 2021-01-20 | US | Pennsylvania | Tioga | 42117 | 2183 | 87 | 0 | 2096 | 41.77255149 | -77.25433032 | 2021-01-21 05:22:01 | Tioga, Pennsylvania, US |
3882211 | 3882211 | 2021-01-14 | US | Pennsylvania | Armstrong | 42005 | 4205 | 87 | 0 | 4118 | 40.81665618 | -79.46290811 | 2021-01-15 05:22:24 | Armstrong, Pennsylvania, US |
3902611 | 3902611 | 2021-01-09 | US | Pennsylvania | Columbia | 42037 | 3344 | 87 | 0 | 3257 | 41.04821986 | -76.40565017 | 2021-01-10 05:22:12 | Columbia, Pennsylvania, US |
3036966 | 3036966 | 2021-01-05 | US | Pennsylvania | Huntingdon | 42061 | 3236 | 87 | 0 | 3149 | 40.42162652 | -77.97673273 | 2021-01-06 05:22:16 | Huntingdon, Pennsylvania, US |
1064511 | 1064511 | 2021-01-04 | US | Pennsylvania | Huntingdon | 42061 | 3198 | 87 | 0 | 3111 | 40.42162652 | -77.97673273 | 2021-01-05 05:21:49 | Huntingdon, Pennsylvania, US |
3233114 | 3233114 | 2021-01-03 | US | Pennsylvania | Huntingdon | 42061 | 3188 | 87 | 0 | 3101 | 40.42162652 | -77.97673273 | 2021-01-04 05:22:02 | Huntingdon, Pennsylvania, US |
2230183 | 2230183 | 2021-01-02 | US | Pennsylvania | Huntingdon | 42061 | 3149 | 87 | 0 | 3062 | 40.42162652 | -77.97673273 | 2021-01-03 05:22:52 | Huntingdon, Pennsylvania, US |
1139547 | 1139547 | 2021-01-01 | US | Pennsylvania | Huntingdon | 42061 | 3129 | 87 | 0 | 3042 | 40.42162652 | -77.97673273 | 2021-01-02 05:22:33 | Huntingdon, Pennsylvania, US |
2226167 | 2226167 | 2020-12-26 | US | Pennsylvania | Fayette | 42051 | 6506 | 87 | 0 | 6419 | 39.92041012 | -79.64291195 | 2020-12-27 05:22:55 | Fayette, Pennsylvania, US |
204914 | 204914 | 2020-12-25 | US | Pennsylvania | Fayette | 42051 | 6393 | 87 | 0 | 6306 | 39.92041012 | -79.64291195 | 2020-12-26 05:22:28 | Fayette, Pennsylvania, US |
3694116 | 3694116 | 2020-12-24 | US | Pennsylvania | Bedford | 42009 | 2804 | 87 | 0 | 2717 | 40.00522157 | -78.48998442 | 2020-12-25 05:22:48 | Bedford, Pennsylvania, US |
2409476 | 2409476 | 2020-12-23 | US | Pennsylvania | Carbon | 42025 | 2379 | 87 | 0 | 2292 | 40.91545395 | -75.7068525 | 2020-12-24 05:23:04 | Carbon, Pennsylvania, US |
3772522 | 3772522 | 2020-12-22 | US | Pennsylvania | Carbon | 42025 | 2334 | 87 | 0 | 2247 | 40.91545395 | -75.7068525 | 2020-12-23 05:22:03 | Carbon, Pennsylvania, 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]);