johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,130 rows where deaths = 243 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,849
- Sweden 50
- Togo 43
- Russia 26
- Germany 21
- Japan 21
- Netherlands 10
- Colombia 9
- Canada 8
- Mexico 8
- Maldives 7
- Nicaragua 7
- Haiti 6
- Qatar 6
- Malaysia 5
- Ukraine 5
- France 4
- Chile 3
- India 3
- Peru 3
- Spain 3
- Congo (Kinshasa) 2
- Greece 2
- Italy 2
- Pakistan 2
- Rwanda 2
- Zimbabwe 2
- Australia 1
- Austria 1
- Bahamas 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755245 | 2755245 | 2022-12-29 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-30 04:21:04 | Lenoir, North Carolina, US | |
2754308 | 2754308 | 2022-12-29 | US | Kentucky | Floyd | 21071 | 16349 | 243 | 0 | 37.56213922 | -82.74750924 | 2022-12-30 04:21:04 | Floyd, Kentucky, US | |
2753267 | 2753267 | 2022-12-29 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-30 04:21:04 | Coffee, Alabama, US | |
1076251 | 1076251 | 2022-12-28 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-29 04:21:01 | Lenoir, North Carolina, US | |
1075314 | 1075314 | 2022-12-28 | US | Kentucky | Floyd | 21071 | 16349 | 243 | 0 | 37.56213922 | -82.74750924 | 2022-12-29 04:21:01 | Floyd, Kentucky, US | |
1074273 | 1074273 | 2022-12-28 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-29 04:21:01 | Coffee, Alabama, US | |
1073937 | 1073937 | 2022-12-28 | Japan | Toyama | 201651 | 243 | 0 | 36.637464 | 137.269346 | 2022-12-29 04:21:01 | Toyama, Japan | |||
331354 | 331354 | 2022-12-27 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-28 04:21:04 | Grays Harbor, Washington, US | |
330248 | 330248 | 2022-12-27 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-28 04:21:04 | Lenoir, North Carolina, US | |
330135 | 330135 | 2022-12-27 | US | New York | Cattaraugus | 36009 | 18848 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-28 04:21:04 | Cattaraugus, New York, US | |
329311 | 329311 | 2022-12-27 | US | Kentucky | Floyd | 21071 | 16349 | 243 | 0 | 37.56213922 | -82.74750924 | 2022-12-28 04:21:04 | Floyd, Kentucky, US | |
328270 | 328270 | 2022-12-27 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-28 04:21:04 | Coffee, Alabama, US | |
221427 | 221427 | 2022-12-26 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-27 04:21:07 | Grays Harbor, Washington, US | |
220321 | 220321 | 2022-12-26 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-27 04:21:07 | Lenoir, North Carolina, US | |
220208 | 220208 | 2022-12-26 | US | New York | Cattaraugus | 36009 | 18844 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-27 04:21:07 | Cattaraugus, New York, US | |
218343 | 218343 | 2022-12-26 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-27 04:21:07 | Coffee, Alabama, US | |
3225884 | 3225884 | 2022-12-25 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-26 04:21:06 | Grays Harbor, Washington, US | |
3224778 | 3224778 | 2022-12-25 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-26 04:21:06 | Lenoir, North Carolina, US | |
3224665 | 3224665 | 2022-12-25 | US | New York | Cattaraugus | 36009 | 18840 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-26 04:21:06 | Cattaraugus, New York, US | |
3222800 | 3222800 | 2022-12-25 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-26 04:21:06 | Coffee, Alabama, US | |
1021798 | 1021798 | 2022-12-24 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-25 04:21:04 | Grays Harbor, Washington, US | |
1020692 | 1020692 | 2022-12-24 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-25 04:21:04 | Lenoir, North Carolina, US | |
1020579 | 1020579 | 2022-12-24 | US | New York | Cattaraugus | 36009 | 18837 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-25 04:21:04 | Cattaraugus, New York, US | |
1018714 | 1018714 | 2022-12-24 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-25 04:21:04 | Coffee, Alabama, US | |
693821 | 693821 | 2022-12-23 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-24 04:21:02 | Grays Harbor, Washington, US | |
692715 | 692715 | 2022-12-23 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-24 04:21:02 | Lenoir, North Carolina, US | |
692602 | 692602 | 2022-12-23 | US | New York | Cattaraugus | 36009 | 18826 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-24 04:21:02 | Cattaraugus, New York, US | |
690737 | 690737 | 2022-12-23 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-24 04:21:02 | Coffee, Alabama, US | |
2183031 | 2183031 | 2022-12-22 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-23 04:21:04 | Grays Harbor, Washington, US | |
2181925 | 2181925 | 2022-12-22 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-23 04:21:04 | Lenoir, North Carolina, US | |
2181812 | 2181812 | 2022-12-22 | US | New York | Cattaraugus | 36009 | 18817 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-23 04:21:04 | Cattaraugus, New York, US | |
2179947 | 2179947 | 2022-12-22 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-23 04:21:04 | Coffee, Alabama, US | |
454835 | 454835 | 2022-12-21 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-22 04:20:56 | Grays Harbor, Washington, US | |
453729 | 453729 | 2022-12-21 | US | North Carolina | Lenoir | 37107 | 19213 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-22 04:20:56 | Lenoir, North Carolina, US | |
453616 | 453616 | 2022-12-21 | US | New York | Cattaraugus | 36009 | 18805 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-22 04:20:56 | Cattaraugus, New York, US | |
451751 | 451751 | 2022-12-21 | US | Alabama | Coffee | 1031 | 16328 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-22 04:20:56 | Coffee, Alabama, US | |
2953699 | 2953699 | 2022-12-20 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-21 04:21:03 | Craven, North Carolina, US | |
2953615 | 2953615 | 2022-12-20 | US | New York | Cattaraugus | 36009 | 18796 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-21 04:21:03 | Cattaraugus, New York, US | |
2951750 | 2951750 | 2022-12-20 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-21 04:21:03 | Coffee, Alabama, US | |
3176101 | 3176101 | 2022-12-19 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-20 04:21:04 | Craven, North Carolina, US | |
3176017 | 3176017 | 2022-12-19 | US | New York | Cattaraugus | 36009 | 18788 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-20 04:21:04 | Cattaraugus, New York, US | |
3174152 | 3174152 | 2022-12-19 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-20 04:21:04 | Coffee, Alabama, US | |
1630618 | 1630618 | 2022-12-18 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-19 04:21:03 | Craven, North Carolina, US | |
1630534 | 1630534 | 2022-12-18 | US | New York | Cattaraugus | 36009 | 18783 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-19 04:21:03 | Cattaraugus, New York, US | |
1628669 | 1628669 | 2022-12-18 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-19 04:21:03 | Coffee, Alabama, US | |
505997 | 505997 | 2022-12-17 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-18 04:21:03 | Craven, North Carolina, US | |
505913 | 505913 | 2022-12-17 | US | New York | Cattaraugus | 36009 | 18773 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-18 04:21:03 | Cattaraugus, New York, US | |
504048 | 504048 | 2022-12-17 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-18 04:21:03 | Coffee, Alabama, US | |
503709 | 503709 | 2022-12-17 | Japan | Tokushima | 118999 | 243 | 0 | 33.919178 | 134.242091 | 2022-12-18 04:21:03 | Tokushima, Japan | |||
3326569 | 3326569 | 2022-12-16 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-17 04:21:04 | Craven, North Carolina, US | |
3326485 | 3326485 | 2022-12-16 | US | New York | Cattaraugus | 36009 | 18770 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-17 04:21:04 | Cattaraugus, New York, US | |
3324620 | 3324620 | 2022-12-16 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-17 04:21:04 | Coffee, Alabama, US | |
545081 | 545081 | 2022-12-15 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-16 04:21:01 | Craven, North Carolina, US | |
544997 | 544997 | 2022-12-15 | US | New York | Cattaraugus | 36009 | 18756 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-16 04:21:01 | Cattaraugus, New York, US | |
543132 | 543132 | 2022-12-15 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-16 04:21:01 | Coffee, Alabama, US | |
350609 | 350609 | 2022-12-14 | US | North Carolina | Craven | 37049 | 30565 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-15 04:20:58 | Craven, North Carolina, US | |
350525 | 350525 | 2022-12-14 | US | New York | Cattaraugus | 36009 | 18742 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-15 04:20:58 | Cattaraugus, New York, US | |
348660 | 348660 | 2022-12-14 | US | Alabama | Coffee | 1031 | 16288 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-15 04:20:58 | Coffee, Alabama, US | |
310197 | 310197 | 2022-12-13 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-14 04:21:04 | Craven, North Carolina, US | |
310113 | 310113 | 2022-12-13 | US | New York | Cattaraugus | 36009 | 18731 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-14 04:21:04 | Cattaraugus, New York, US | |
308248 | 308248 | 2022-12-13 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-14 04:21:04 | Coffee, Alabama, US | |
1151258 | 1151258 | 2022-12-12 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-13 04:21:01 | Craven, North Carolina, US | |
1151174 | 1151174 | 2022-12-12 | US | New York | Cattaraugus | 36009 | 18731 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-13 04:21:01 | Cattaraugus, New York, US | |
1149309 | 1149309 | 2022-12-12 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-13 04:21:01 | Coffee, Alabama, US | |
871112 | 871112 | 2022-12-11 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-12 04:21:01 | Craven, North Carolina, US | |
871028 | 871028 | 2022-12-11 | US | New York | Cattaraugus | 36009 | 18730 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-12 04:21:01 | Cattaraugus, New York, US | |
869163 | 869163 | 2022-12-11 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-12 04:21:01 | Coffee, Alabama, US | |
259642 | 259642 | 2022-12-10 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-11 04:20:50 | Craven, North Carolina, US | |
259558 | 259558 | 2022-12-10 | US | New York | Cattaraugus | 36009 | 18727 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-11 04:20:50 | Cattaraugus, New York, US | |
257693 | 257693 | 2022-12-10 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-11 04:20:50 | Coffee, Alabama, US | |
3938356 | 3938356 | 2022-12-09 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-10 04:21:02 | Craven, North Carolina, US | |
3938272 | 3938272 | 2022-12-09 | US | New York | Cattaraugus | 36009 | 18717 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-10 04:21:02 | Cattaraugus, New York, US | |
3936407 | 3936407 | 2022-12-09 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-10 04:21:02 | Coffee, Alabama, US | |
3379688 | 3379688 | 2022-12-08 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-09 04:21:05 | Craven, North Carolina, US | |
3379604 | 3379604 | 2022-12-08 | US | New York | Cattaraugus | 36009 | 18715 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-09 04:21:05 | Cattaraugus, New York, US | |
3377739 | 3377739 | 2022-12-08 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-09 04:21:05 | Coffee, Alabama, US | |
1986959 | 1986959 | 2022-12-07 | US | North Carolina | Craven | 37049 | 30482 | 243 | 0 | 35.11833364 | -77.08398081 | 2022-12-08 04:21:07 | Craven, North Carolina, US | |
1986875 | 1986875 | 2022-12-07 | US | New York | Cattaraugus | 36009 | 18709 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-08 04:21:07 | Cattaraugus, New York, US | |
1985010 | 1985010 | 2022-12-07 | US | Alabama | Coffee | 1031 | 16238 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-08 04:21:07 | Coffee, Alabama, US | |
3717632 | 3717632 | 2022-12-06 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-07 04:20:58 | Skagit, Washington, US | |
3716511 | 3716511 | 2022-12-06 | US | North Carolina | Lenoir | 37107 | 18993 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-07 04:20:58 | Lenoir, North Carolina, US | |
3716398 | 3716398 | 2022-12-06 | US | New York | Cattaraugus | 36009 | 18702 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-07 04:20:58 | Cattaraugus, New York, US | |
3714533 | 3714533 | 2022-12-06 | US | Alabama | Coffee | 1031 | 16216 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-07 04:20:58 | Coffee, Alabama, US | |
2418337 | 2418337 | 2022-12-05 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-06 04:21:03 | Skagit, Washington, US | |
2417216 | 2417216 | 2022-12-05 | US | North Carolina | Lenoir | 37107 | 18993 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-06 04:21:03 | Lenoir, North Carolina, US | |
2417103 | 2417103 | 2022-12-05 | US | New York | Cattaraugus | 36009 | 18700 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-06 04:21:03 | Cattaraugus, New York, US | |
2415238 | 2415238 | 2022-12-05 | US | Alabama | Coffee | 1031 | 16216 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-06 04:21:03 | Coffee, Alabama, US | |
721945 | 721945 | 2022-12-04 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-05 04:20:58 | Skagit, Washington, US | |
720824 | 720824 | 2022-12-04 | US | North Carolina | Lenoir | 37107 | 18993 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-05 04:20:58 | Lenoir, North Carolina, US | |
720711 | 720711 | 2022-12-04 | US | New York | Cattaraugus | 36009 | 18699 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-05 04:20:58 | Cattaraugus, New York, US | |
718846 | 718846 | 2022-12-04 | US | Alabama | Coffee | 1031 | 16216 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-05 04:20:58 | Coffee, Alabama, US | |
2820234 | 2820234 | 2022-12-03 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-04 04:20:56 | Skagit, Washington, US | |
2819113 | 2819113 | 2022-12-03 | US | North Carolina | Lenoir | 37107 | 18993 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-04 04:20:56 | Lenoir, North Carolina, US | |
2819000 | 2819000 | 2022-12-03 | US | New York | Cattaraugus | 36009 | 18696 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-04 04:20:56 | Cattaraugus, New York, US | |
2817135 | 2817135 | 2022-12-03 | US | Alabama | Coffee | 1031 | 16216 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-04 04:20:56 | Coffee, Alabama, US | |
837090 | 837090 | 2022-12-02 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-03 04:21:02 | Skagit, Washington, US | |
835969 | 835969 | 2022-12-02 | US | North Carolina | Lenoir | 37107 | 18993 | 243 | 0 | 35.2403259 | -77.64245615 | 2022-12-03 04:21:02 | Lenoir, North Carolina, US | |
835856 | 835856 | 2022-12-02 | US | New York | Cattaraugus | 36009 | 18692 | 243 | 0 | 42.24778241 | -78.67923096 | 2022-12-03 04:21:02 | Cattaraugus, New York, US | |
833991 | 833991 | 2022-12-02 | US | Alabama | Coffee | 1031 | 16216 | 243 | 0 | 31.39932826 | -85.98901039 | 2022-12-03 04:21:02 | Coffee, Alabama, US | |
2139620 | 2139620 | 2022-12-01 | US | Washington | Skagit | 53057 | 27515 | 243 | 0 | 48.48171488 | -121.766131 | 2022-12-02 04:21:07 | Skagit, Washington, 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]);