johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22,298 rows where province_or_state = "New Jersey" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113813 | 113813 | 2020-05-08 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-09 02:32:35 | Unassigned, New Jersey, US |
267916 | 267916 | 2020-05-21 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-22 02:36:51 | Unassigned, New Jersey, US |
997387 | 997387 | 2020-05-23 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-24 02:32:43 | Unassigned, New Jersey, US |
1431499 | 1431499 | 2020-05-20 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-21 02:32:48 | Unassigned, New Jersey, US |
1864410 | 1864410 | 2020-05-22 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-23 02:32:42 | Unassigned, New Jersey, US |
2389793 | 2389793 | 2020-05-19 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-20 02:32:19 | Unassigned, New Jersey, US |
2581074 | 2581074 | 2020-05-12 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-13 03:32:26 | Unassigned, New Jersey, US |
2898764 | 2898764 | 2020-05-09 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-10 02:32:30 | Unassigned, New Jersey, US |
3260533 | 3260533 | 2020-05-18 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-19 02:32:18 | Unassigned, New Jersey, US |
3275876 | 3275876 | 2020-05-15 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-16 02:32:19 | Unassigned, New Jersey, US |
3295256 | 3295256 | 2020-05-07 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-08 02:32:32 | Unassigned, New Jersey, US |
3330608 | 3330608 | 2020-05-11 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-12 03:32:27 | Unassigned, New Jersey, US |
3415926 | 3415926 | 2020-05-17 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-18 02:32:21 | Unassigned, New Jersey, US |
3459223 | 3459223 | 2020-05-10 | US | New Jersey | Unassigned | 90034 | 0 | 0 | 0 | 0 | 41.13891592 | 0.0 | 2020-05-11 02:32:30 | Unassigned, New Jersey, US |
1131790 | 1131790 | 2020-03-25 | US | New Jersey | Salem | 34033 | 1 | 0 | 0 | 1 | 39.58719656 | -75.34696629999998 | 2020-03-25 23:33:19 | Salem, New Jersey, US |
1478298 | 1478298 | 2020-03-24 | US | New Jersey | Salem | 34033 | 1 | 0 | 0 | 1 | 39.58719656 | -75.34696629999998 | 2020-03-24 23:37:31 | Salem, New Jersey, US |
2144545 | 2144545 | 2020-03-23 | US | New Jersey | Cumberland | 34011 | 1 | 0 | 0 | 1 | 39.37199394 | -75.10712559 | 2020-03-23 23:19:34 | Cumberland, New Jersey, US |
2146355 | 2146355 | 2020-03-23 | US | New Jersey | Salem | 34033 | 1 | 0 | 0 | 1 | 39.58719656 | -75.34696629999998 | 2020-03-23 23:19:34 | Salem, New Jersey, US |
2907498 | 2907498 | 2020-03-22 | US | New Jersey | Cumberland | 34011 | 1 | 0 | 0 | 1 | 39.37199394 | -75.10712559 | 3/22/20 23:45 | Cumberland, New Jersey, US |
2907499 | 2907499 | 2020-03-22 | US | New Jersey | Salem | 34033 | 1 | 0 | 0 | 1 | 39.58719656 | -75.3469663 | 3/22/20 23:45 | Salem, New Jersey, US |
918389 | 918389 | 2020-03-26 | US | New Jersey | Salem | 34033 | 2 | 0 | 0 | 2 | 39.58719656 | -75.34696629999998 | 2020-03-26 23:48:35 | Salem, New Jersey, US |
1476488 | 1476488 | 2020-03-24 | US | New Jersey | Cumberland | 34011 | 2 | 0 | 0 | 2 | 39.37199394 | -75.10712559 | 2020-03-24 23:37:31 | Cumberland, New Jersey, US |
2144243 | 2144243 | 2020-03-23 | US | New Jersey | Cape May | 34009 | 2 | 0 | 0 | 2 | 39.15008829 | -74.80170244 | 2020-03-23 23:19:34 | Cape May, New Jersey, US |
2907497 | 2907497 | 2020-03-22 | US | New Jersey | Cape May | 34009 | 2 | 0 | 0 | 2 | 39.15008829 | -74.80170244 | 3/22/20 23:45 | Cape May, New Jersey, US |
808289 | 808289 | 2020-03-27 | US | New Jersey | Salem | 34033 | 3 | 0 | 0 | 3 | 39.58719656 | -75.34696629999998 | 2020-03-27 22:14:55 | Salem, New Jersey, US |
1129980 | 1129980 | 2020-03-25 | US | New Jersey | Cumberland | 34011 | 3 | 0 | 0 | 3 | 39.37199394 | -75.10712559 | 2020-03-25 23:33:19 | Cumberland, New Jersey, US |
1476186 | 1476186 | 2020-03-24 | US | New Jersey | Cape May | 34009 | 3 | 0 | 0 | 3 | 39.15008829 | -74.80170244 | 2020-03-24 23:37:31 | Cape May, New Jersey, US |
1871659 | 1871659 | 2020-03-30 | US | New Jersey | Salem | 34033 | 3 | 0 | 0 | 3 | 39.58719656 | -75.3469663 | 3/30/20 22:52 | Salem, New Jersey, US |
2874900 | 2874900 | 2020-03-29 | US | New Jersey | Salem | 34033 | 3 | 0 | 0 | 3 | 39.58719656 | -75.3469663 | 3/29/20 23:08 | Salem, New Jersey, US |
3946240 | 3946240 | 2020-03-28 | US | New Jersey | Salem | 34033 | 3 | 0 | 0 | 3 | 39.58719656 | -75.3469663 | 3/28/20 23:05 | Salem, New Jersey, US |
916580 | 916580 | 2020-03-26 | US | New Jersey | Cumberland | 34011 | 4 | 0 | 0 | 4 | 39.37199394 | -75.10712559 | 2020-03-26 23:48:35 | Cumberland, New Jersey, US |
1129678 | 1129678 | 2020-03-25 | US | New Jersey | Cape May | 34009 | 4 | 0 | 0 | 4 | 39.15008829 | -74.80170244 | 2020-03-25 23:33:19 | Cape May, New Jersey, US |
2907496 | 2907496 | 2020-03-22 | US | New Jersey | Atlantic | 34001 | 5 | 0 | 0 | 5 | 39.47538693 | -74.65848483 | 3/22/20 23:45 | Atlantic, New Jersey, US |
916278 | 916278 | 2020-03-26 | US | New Jersey | Cape May | 34009 | 6 | 0 | 0 | 6 | 39.15008829 | -74.80170244 | 2020-03-26 23:48:35 | Cape May, New Jersey, US |
1475904 | 1475904 | 2020-03-24 | US | New Jersey | Atlantic | 34001 | 6 | 0 | 0 | 6 | 39.47538693 | -74.65848483 | 2020-03-24 23:37:31 | Atlantic, New Jersey, US |
2143961 | 2143961 | 2020-03-23 | US | New Jersey | Atlantic | 34001 | 6 | 0 | 0 | 6 | 39.47538693 | -74.65848483 | 2020-03-23 23:19:34 | Atlantic, New Jersey, US |
806178 | 806178 | 2020-03-27 | US | New Jersey | Cape May | 34009 | 7 | 0 | 0 | 7 | 39.15008829 | -74.80170244 | 2020-03-27 22:14:55 | Cape May, New Jersey, US |
3944129 | 3944129 | 2020-03-28 | US | New Jersey | Cape May | 34009 | 7 | 0 | 0 | 7 | 39.15008829 | -74.80170244 | 3/28/20 23:05 | Cape May, New Jersey, US |
2907495 | 2907495 | 2020-03-22 | US | New Jersey | Gloucester | 34015 | 8 | 0 | 0 | 8 | 39.71581067 | -75.13995546 | 3/22/20 23:45 | Gloucester, New Jersey, US |
806480 | 806480 | 2020-03-27 | US | New Jersey | Cumberland | 34011 | 9 | 0 | 0 | 9 | 39.37199394 | -75.10712559 | 2020-03-27 22:14:55 | Cumberland, New Jersey, US |
1869548 | 1869548 | 2020-03-30 | US | New Jersey | Cape May | 34009 | 9 | 0 | 0 | 9 | 39.15008829 | -74.80170244 | 3/30/20 22:52 | Cape May, New Jersey, US |
2608191 | 2608191 | 2020-09-24 | US | New Jersey | Unassigned | 90034 | 9 | 0 | 0 | 9 | 41.13891592 | 0.0 | 2020-09-25 04:23:00 | Unassigned, New Jersey, US |
2872789 | 2872789 | 2020-03-29 | US | New Jersey | Cape May | 34009 | 9 | 0 | 0 | 9 | 39.15008829 | -74.80170244 | 3/29/20 23:08 | Cape May, New Jersey, US |
2907494 | 2907494 | 2020-03-22 | US | New Jersey | Warren | 34041 | 9 | 0 | 0 | 9 | 40.85951833 | -74.99556527 | 3/22/20 23:45 | Warren, New Jersey, US |
915996 | 915996 | 2020-03-26 | US | New Jersey | Atlantic | 34001 | 10 | 0 | 0 | 10 | 39.47538693 | -74.65848483 | 2020-03-26 23:48:35 | Atlantic, New Jersey, US |
2873091 | 2873091 | 2020-03-29 | US | New Jersey | Cumberland | 34011 | 11 | 0 | 0 | 11 | 39.37199394 | -75.10712559 | 3/29/20 23:08 | Cumberland, New Jersey, US |
3944431 | 3944431 | 2020-03-28 | US | New Jersey | Cumberland | 34011 | 11 | 0 | 0 | 11 | 39.37199394 | -75.10712559 | 3/28/20 23:05 | Cumberland, New Jersey, US |
1129396 | 1129396 | 2020-03-25 | US | New Jersey | Atlantic | 34001 | 12 | 0 | 0 | 12 | 39.47538693 | -74.65848483 | 2020-03-25 23:33:19 | Atlantic, New Jersey, US |
1869850 | 1869850 | 2020-03-30 | US | New Jersey | Cumberland | 34011 | 12 | 1 | 0 | 11 | 39.37199394 | -75.10712559 | 3/30/20 22:52 | Cumberland, New Jersey, US |
2146824 | 2146824 | 2020-03-23 | US | New Jersey | Warren | 34041 | 12 | 0 | 0 | 12 | 40.85951833 | -74.99556527 | 2020-03-23 23:19:34 | Warren, New Jersey, US |
2907493 | 2907493 | 2020-03-22 | US | New Jersey | Sussex | 34037 | 12 | 0 | 0 | 12 | 41.13891592 | -74.69118243 | 3/22/20 23:45 | Sussex, New Jersey, US |
3813888 | 3813888 | 2020-03-31 | US | New Jersey | Cape May | 34009 | 12 | 0 | 0 | 12 | 39.15008829 | -74.80170244 | 2020-03-31 23:43:56 | Cape May, New Jersey, US |
3815294 | 3815294 | 2020-03-31 | US | New Jersey | Salem | 34033 | 12 | 0 | 0 | 12 | 39.58719656 | -75.34696629999998 | 2020-03-31 23:43:56 | Salem, New Jersey, US |
2144913 | 2144913 | 2020-03-23 | US | New Jersey | Gloucester | 34015 | 13 | 0 | 0 | 13 | 39.71581067 | -75.13995546 | 2020-03-23 23:19:34 | Gloucester, New Jersey, US |
805896 | 805896 | 2020-03-27 | US | New Jersey | Atlantic | 34001 | 14 | 0 | 0 | 14 | 39.47538693 | -74.65848483 | 2020-03-27 22:14:55 | Atlantic, New Jersey, US |
1478766 | 1478766 | 2020-03-24 | US | New Jersey | Warren | 34041 | 15 | 0 | 0 | 15 | 40.85951833 | -74.99556527 | 2020-03-24 23:37:31 | Warren, New Jersey, US |
2146605 | 2146605 | 2020-03-23 | US | New Jersey | Sussex | 34037 | 15 | 0 | 0 | 15 | 41.13891592 | -74.69118243 | 2020-03-23 23:19:34 | Sussex, New Jersey, US |
3752909 | 3752909 | 2020-03-10 | US | New Jersey | 15 | 1 | 0 | 40.2989 | -74.521 | 2020-03-10T18:13:16 | ||||
2907492 | 2907492 | 2020-03-22 | US | New Jersey | Hunterdon | 34019 | 16 | 0 | 0 | 16 | 40.56335249 | -74.91284156 | 3/22/20 23:45 | Hunterdon, New Jersey, US |
3943847 | 3943847 | 2020-03-28 | US | New Jersey | Atlantic | 34001 | 17 | 0 | 0 | 17 | 39.47538693 | -74.65848483 | 3/28/20 23:05 | Atlantic, New Jersey, US |
1132258 | 1132258 | 2020-03-25 | US | New Jersey | Warren | 34041 | 18 | 0 | 0 | 18 | 40.85951833 | -74.99556527 | 2020-03-25 23:33:19 | Warren, New Jersey, US |
1478548 | 1478548 | 2020-03-24 | US | New Jersey | Sussex | 34037 | 18 | 0 | 0 | 18 | 41.13891592 | -74.69118243 | 2020-03-24 23:37:31 | Sussex, New Jersey, US |
2145184 | 2145184 | 2020-03-23 | US | New Jersey | Hunterdon | 34019 | 18 | 0 | 0 | 18 | 40.56335249 | -74.91284156 | 2020-03-23 23:19:34 | Hunterdon, New Jersey, US |
3814106 | 3814106 | 2020-03-31 | US | New Jersey | Cumberland | 34011 | 18 | 1 | 0 | 17 | 39.37199394 | -75.10712559 | 2020-03-31 23:43:56 | Cumberland, New Jersey, US |
1476856 | 1476856 | 2020-03-24 | US | New Jersey | Gloucester | 34015 | 19 | 0 | 0 | 19 | 39.71581067 | -75.13995546 | 2020-03-24 23:37:31 | Gloucester, New Jersey, US |
3364194 | 3364194 | 2020-04-01 | US | New Jersey | Salem | 34033 | 19 | 1 | 0 | 18 | 39.58719656 | -75.34696629999998 | 2020-04-01 21:58:49 | Salem, New Jersey, US |
3700970 | 3700970 | 2020-04-02 | US | New Jersey | Salem | 34033 | 20 | 1 | 0 | 19 | 39.58719656 | -75.3469663 | 4/2/20 23:25 | Salem, New Jersey, US |
2907491 | 2907491 | 2020-03-22 | US | New Jersey | Camden | 34007 | 22 | 0 | 0 | 22 | 39.80343818 | -74.96388753 | 3/22/20 23:45 | Camden, New Jersey, US |
3362755 | 3362755 | 2020-04-01 | US | New Jersey | Cape May | 34009 | 22 | 0 | 0 | 22 | 39.15008829 | -74.80170244 | 2020-04-01 21:58:49 | Cape May, New Jersey, US |
1130348 | 1130348 | 2020-03-25 | US | New Jersey | Gloucester | 34015 | 23 | 0 | 0 | 23 | 39.71581067 | -75.13995546 | 2020-03-25 23:33:19 | Gloucester, New Jersey, US |
2127516 | 2127516 | 2020-03-11 | US | New Jersey | 23 | 1 | 0 | 40.2989 | -74.521 | 2020-03-11T18:52:04 | ||||
2872507 | 2872507 | 2020-03-29 | US | New Jersey | Atlantic | 34001 | 24 | 0 | 0 | 24 | 39.47538693 | -74.65848483 | 3/29/20 23:08 | Atlantic, New Jersey, US |
1130619 | 1130619 | 2020-03-25 | US | New Jersey | Hunterdon | 34019 | 25 | 0 | 0 | 25 | 40.56335249 | -74.91284156 | 2020-03-25 23:33:19 | Hunterdon, New Jersey, US |
1477127 | 1477127 | 2020-03-24 | US | New Jersey | Hunterdon | 34019 | 25 | 0 | 0 | 25 | 40.56335249 | -74.91284156 | 2020-03-24 23:37:31 | Hunterdon, New Jersey, US |
1750109 | 1750109 | 2020-04-04 | US | New Jersey | Salem | 34033 | 25 | 2 | 0 | 23 | 39.58719656 | -75.3469663 | 4/4/20 23:34 | Salem, New Jersey, US |
3739929 | 3739929 | 2020-04-03 | US | New Jersey | Salem | 34033 | 25 | 2 | 0 | 23 | 39.58719656 | -75.34696629999998 | 2020-04-03 22:46:37 | Salem, New Jersey, US |
588449 | 588449 | 2020-04-05 | US | New Jersey | Salem | 34033 | 26 | 2 | 0 | 24 | 39.58719656 | -75.34696629999998 | 2020-04-05 23:06:45 | Salem, New Jersey, US |
2907490 | 2907490 | 2020-03-22 | US | New Jersey | Burlington | 34005 | 26 | 0 | 0 | 26 | 39.87681124 | -74.66927768 | 3/22/20 23:45 | Burlington, New Jersey, US |
1132040 | 1132040 | 2020-03-25 | US | New Jersey | Sussex | 34037 | 27 | 0 | 0 | 27 | 41.13891592 | -74.69118243 | 2020-03-25 23:33:19 | Sussex, New Jersey, US |
3362979 | 3362979 | 2020-04-01 | US | New Jersey | Cumberland | 34011 | 27 | 1 | 0 | 26 | 39.37199394 | -75.10712559 | 2020-04-01 21:58:49 | Cumberland, New Jersey, US |
764481 | 764481 | 2020-10-18 | US | New Jersey | Unassigned | 90034 | 28 | 0 | 0 | 28 | 41.13891592 | 0.0 | 2020-10-19 04:24:16 | Unassigned, New Jersey, US |
1869266 | 1869266 | 2020-03-30 | US | New Jersey | Atlantic | 34001 | 29 | 0 | 0 | 29 | 39.47538693 | -74.65848483 | 3/30/20 22:52 | Atlantic, New Jersey, US |
2282945 | 2282945 | 2020-03-12 | US | New Jersey | 29 | 1 | 0 | 40.2989 | -74.521 | 2020-03-12T21:39:10 | ||||
3626750 | 3626750 | 2020-04-06 | US | New Jersey | Salem | 34033 | 29 | 2 | 0 | 27 | 39.58719656 | -75.3469663 | 4/6/20 23:22 | Salem, New Jersey, US |
3765484 | 3765484 | 2020-03-13 | US | New Jersey | 29 | 1 | 0 | 40.298904 | -74.521011 | 2020-03-11T20:00:00 | ||||
918855 | 918855 | 2020-03-26 | US | New Jersey | Warren | 34041 | 31 | 0 | 0 | 31 | 40.85951833 | -74.99556527 | 2020-03-26 23:48:35 | Warren, New Jersey, US |
3021060 | 3021060 | 2020-04-07 | US | New Jersey | Salem | 34033 | 31 | 3 | 0 | 28 | 39.58719656 | -75.34696629999998 | 2020-04-07 23:04:49 | Salem, New Jersey, US |
3699709 | 3699709 | 2020-04-02 | US | New Jersey | Cumberland | 34011 | 31 | 1 | 0 | 30 | 39.37199394 | -75.10712559 | 4/2/20 23:25 | Cumberland, New Jersey, US |
3813693 | 3813693 | 2020-03-31 | US | New Jersey | Atlantic | 34001 | 31 | 0 | 0 | 31 | 39.47538693 | -74.65848483 | 2020-03-31 23:43:56 | Atlantic, New Jersey, US |
2711801 | 2711801 | 2020-05-28 | US | New Jersey | Unassigned | 90034 | 32 | 0 | 0 | 32 | 41.13891592 | 0.0 | 2020-05-29 02:32:50 | Unassigned, New Jersey, US |
916947 | 916947 | 2020-03-26 | US | New Jersey | Gloucester | 34015 | 33 | 0 | 0 | 33 | 39.71581067 | -75.13995546 | 2020-03-26 23:48:35 | Gloucester, New Jersey, US |
2144227 | 2144227 | 2020-03-23 | US | New Jersey | Camden | 34007 | 33 | 1 | 0 | 32 | 39.80343818 | -74.96388753 | 2020-03-23 23:19:34 | Camden, New Jersey, US |
3699475 | 3699475 | 2020-04-02 | US | New Jersey | Cape May | 34009 | 34 | 0 | 0 | 34 | 39.15008829 | -74.80170244 | 4/2/20 23:25 | Cape May, New Jersey, US |
2144178 | 2144178 | 2020-03-23 | US | New Jersey | Burlington | 34005 | 36 | 0 | 0 | 36 | 39.87681124 | -74.66927768 | 2020-03-23 23:19:34 | Burlington, New Jersey, US |
3561379 | 3561379 | 2020-04-08 | US | New Jersey | Salem | 34033 | 36 | 3 | 0 | 33 | 39.58719656 | -75.34696629999998 | 2020-04-08 22:51:58 | Salem, New Jersey, US |
3738631 | 3738631 | 2020-04-03 | US | New Jersey | Cumberland | 34011 | 36 | 1 | 0 | 35 | 39.37199394 | -75.10712559 | 2020-04-03 22:46:37 | Cumberland, New Jersey, US |
808762 | 808762 | 2020-03-27 | US | New Jersey | Warren | 34041 | 38 | 0 | 0 | 38 | 40.85951833 | -74.99556527 | 2020-03-27 22:14:55 | Warren, New Jersey, US |
917218 | 917218 | 2020-03-26 | US | New Jersey | Hunterdon | 34019 | 39 | 0 | 0 | 39 | 40.56335249 | -74.91284156 | 2020-03-26 23:48:35 | Hunterdon, New Jersey, US |
806847 | 806847 | 2020-03-27 | US | New Jersey | Gloucester | 34015 | 40 | 0 | 0 | 40 | 39.71581067 | -75.13995546 | 2020-03-27 22:14:55 | Gloucester, New Jersey, US |
1748780 | 1748780 | 2020-04-04 | US | New Jersey | Cumberland | 34011 | 40 | 2 | 0 | 38 | 39.37199394 | -75.10712559 | 4/4/20 23:34 | Cumberland, New Jersey, 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]);