johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
507 rows where deaths = 559 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753237 | 2753237 | 2022-12-29 | Sweden | Vastmanland | 80492 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-30 04:21:04 | Vastmanland, Sweden | |||
1074243 | 1074243 | 2022-12-28 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-29 04:21:01 | Vastmanland, Sweden | |||
1073924 | 1073924 | 2022-12-28 | Japan | Okayama | 397618 | 559 | 0 | 34.89246 | 133.826252 | 2022-12-29 04:21:01 | Okayama, Japan | |||
328240 | 328240 | 2022-12-27 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-28 04:21:04 | Vastmanland, Sweden | |||
218313 | 218313 | 2022-12-26 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-27 04:21:07 | Vastmanland, Sweden | |||
3222770 | 3222770 | 2022-12-25 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-26 04:21:06 | Vastmanland, Sweden | |||
1018684 | 1018684 | 2022-12-24 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-25 04:21:04 | Vastmanland, Sweden | |||
690707 | 690707 | 2022-12-23 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-24 04:21:02 | Vastmanland, Sweden | |||
2179917 | 2179917 | 2022-12-22 | Sweden | Vastmanland | 80151 | 559 | 0 | 59.6714 | 16.2159 | 2022-12-23 04:21:04 | Vastmanland, Sweden | |||
308376 | 308376 | 2022-12-13 | US | Arkansas | Garland | 5051 | 26440 | 559 | 0 | 34.57692074 | -93.14921604 | 2022-12-14 04:21:04 | Garland, Arkansas, US | |
3377357 | 3377357 | 2022-12-08 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-09 04:21:05 | Valle d'Aosta, Italy | |||
1984628 | 1984628 | 2022-12-07 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-08 04:21:07 | Valle d'Aosta, Italy | |||
3715207 | 3715207 | 2022-12-06 | US | Illinois | Peoria | 17143 | 57571 | 559 | 0 | 40.78702156 | -89.76078901 | 2022-12-07 04:20:58 | Peoria, Illinois, US | |
3714151 | 3714151 | 2022-12-06 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-07 04:20:58 | Valle d'Aosta, Italy | |||
2414856 | 2414856 | 2022-12-05 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-06 04:21:03 | Valle d'Aosta, Italy | |||
718464 | 718464 | 2022-12-04 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-05 04:20:58 | Valle d'Aosta, Italy | |||
2816753 | 2816753 | 2022-12-03 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-04 04:20:56 | Valle d'Aosta, Italy | |||
833609 | 833609 | 2022-12-02 | Italy | Valle d'Aosta | 49033 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-03 04:21:02 | Valle d'Aosta, Italy | |||
2136139 | 2136139 | 2022-12-01 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-02 04:21:07 | Valle d'Aosta, Italy | |||
2135976 | 2135976 | 2022-12-01 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-12-02 04:21:07 | Arauca, Colombia | |||
1964555 | 1964555 | 2022-11-30 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-12-01 04:21:03 | Valle d'Aosta, Italy | |||
1964392 | 1964392 | 2022-11-30 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-12-01 04:21:03 | Arauca, Colombia | |||
2556569 | 2556569 | 2022-11-29 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-30 04:21:07 | Valle d'Aosta, Italy | |||
2556406 | 2556406 | 2022-11-29 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-30 04:21:07 | Arauca, Colombia | |||
1239643 | 1239643 | 2022-11-28 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-29 04:21:05 | Valle d'Aosta, Italy | |||
1239480 | 1239480 | 2022-11-28 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-29 04:21:05 | Arauca, Colombia | |||
3551631 | 3551631 | 2022-11-27 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-28 04:21:02 | Valle d'Aosta, Italy | |||
3551468 | 3551468 | 2022-11-27 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-28 04:21:02 | Arauca, Colombia | |||
2100111 | 2100111 | 2022-11-26 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-27 04:21:05 | Valle d'Aosta, Italy | |||
2099948 | 2099948 | 2022-11-26 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-27 04:21:05 | Arauca, Colombia | |||
487602 | 487602 | 2022-11-25 | Italy | Valle d'Aosta | 48705 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-26 04:21:11 | Valle d'Aosta, Italy | |||
487439 | 487439 | 2022-11-25 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-26 04:21:11 | Arauca, Colombia | |||
3523431 | 3523431 | 2022-11-24 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-25 04:21:06 | Valle d'Aosta, Italy | |||
3523268 | 3523268 | 2022-11-24 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-25 04:21:06 | Arauca, Colombia | |||
3312214 | 3312214 | 2022-11-23 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-24 04:21:09 | Valle d'Aosta, Italy | |||
3312051 | 3312051 | 2022-11-23 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-24 04:21:09 | Arauca, Colombia | |||
1620255 | 1620255 | 2022-11-22 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-23 04:21:06 | Valle d'Aosta, Italy | |||
1620092 | 1620092 | 2022-11-22 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-23 04:21:06 | Arauca, Colombia | |||
3460143 | 3460143 | 2022-11-21 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-22 04:20:47 | Valle d'Aosta, Italy | |||
3459980 | 3459980 | 2022-11-21 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-22 04:20:47 | Arauca, Colombia | |||
1640328 | 1640328 | 2022-11-20 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-21 04:21:05 | Valle d'Aosta, Italy | |||
1640165 | 1640165 | 2022-11-20 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-21 04:21:05 | Arauca, Colombia | |||
2063885 | 2063885 | 2022-11-19 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-20 04:21:08 | Valle d'Aosta, Italy | |||
2063722 | 2063722 | 2022-11-19 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-20 04:21:08 | Arauca, Colombia | |||
1755279 | 1755279 | 2022-11-18 | Italy | Valle d'Aosta | 48329 | 559 | 0 | 45.73750286 | 7.320149366 | 2022-11-19 04:21:14 | Valle d'Aosta, Italy | |||
1755116 | 1755116 | 2022-11-18 | Colombia | Arauca | 17020 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-19 04:21:14 | Arauca, Colombia | |||
3026109 | 3026109 | 2022-11-17 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-18 04:21:15 | Arauca, Colombia | |||
2485820 | 2485820 | 2022-11-16 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-17 04:21:11 | Arauca, Colombia | |||
291831 | 291831 | 2022-11-15 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-16 04:21:09 | Arauca, Colombia | |||
3597049 | 3597049 | 2022-11-14 | Japan | Mie | 280347 | 559 | 0 | 34.508018 | 136.376013 | 2022-11-15 04:21:16 | Mie, Japan | |||
3596861 | 3596861 | 2022-11-14 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-15 04:21:16 | Arauca, Colombia | |||
311719 | 311719 | 2022-11-13 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-14 04:21:09 | Arauca, Colombia | |||
62880 | 62880 | 2022-11-12 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-13 04:21:14 | Arauca, Colombia | |||
2927042 | 2927042 | 2022-11-11 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-12 04:20:41 | Arauca, Colombia | |||
2505878 | 2505878 | 2022-11-10 | Colombia | Arauca | 17006 | 559 | 0 | 7.0762 | -70.7105 | 2022-11-11 04:21:22 | Arauca, Colombia | |||
2431572 | 2431572 | 2022-11-09 | US | Colorado | Larimer | 8069 | 102427 | 559 | 0 | 40.66671597 | -105.4625784 | 2022-11-10 04:21:16 | Larimer, Colorado, US | |
796642 | 796642 | 2022-10-24 | US | New York | Broome | 36007 | 55353 | 559 | 0 | 42.15903158 | -75.81326086 | 2022-10-25 04:21:53 | Broome, New York, US | |
3279097 | 3279097 | 2022-10-23 | US | New York | Broome | 36007 | 55329 | 559 | 0 | 42.15903158 | -75.81326086 | 2022-10-24 04:22:29 | Broome, New York, US | |
2270135 | 2270135 | 2022-10-22 | US | New York | Broome | 36007 | 55281 | 559 | 0 | 42.15903158 | -75.81326086 | 2022-10-23 04:22:46 | Broome, New York, US | |
1594435 | 1594435 | 2022-10-21 | US | New York | Broome | 36007 | 55246 | 559 | 0 | 42.15903158 | -75.81326086 | 2022-10-22 04:22:53 | Broome, New York, US | |
2274151 | 2274151 | 2022-10-20 | US | New York | Broome | 36007 | 55202 | 559 | 0 | 42.15903158 | -75.81326086 | 2022-10-21 04:22:23 | Broome, New York, US | |
2759613 | 2759613 | 2022-10-18 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-19 04:22:26 | Monroe, Pennsylvania, US | |
2027447 | 2027447 | 2022-10-17 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-18 04:22:42 | Monroe, Pennsylvania, US | |
2026338 | 2026338 | 2022-10-17 | US | Maryland | Frederick | 24021 | 54479 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-18 04:22:42 | Frederick, Maryland, US | |
2162225 | 2162225 | 2022-10-16 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-17 04:20:31 | Monroe, Pennsylvania, US | |
2161116 | 2161116 | 2022-10-16 | US | Maryland | Frederick | 24021 | 54460 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-17 04:20:31 | Frederick, Maryland, US | |
518422 | 518422 | 2022-10-15 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-16 04:22:39 | Monroe, Pennsylvania, US | |
517313 | 517313 | 2022-10-15 | US | Maryland | Frederick | 24021 | 54460 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-16 04:22:39 | Frederick, Maryland, US | |
2035479 | 2035479 | 2022-10-14 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-15 04:22:00 | Monroe, Pennsylvania, US | |
2034370 | 2034370 | 2022-10-14 | US | Maryland | Frederick | 24021 | 54460 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-15 04:22:00 | Frederick, Maryland, US | |
3756167 | 3756167 | 2022-10-13 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-14 04:22:28 | Monroe, Pennsylvania, US | |
3755058 | 3755058 | 2022-10-13 | US | Maryland | Frederick | 24021 | 54425 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-14 04:22:28 | Frederick, Maryland, US | |
3753680 | 3753680 | 2022-10-13 | Russia | Jewish Autonomous Okrug | 21840 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-14 04:22:28 | Jewish Autonomous Okrug, Russia | |||
3216992 | 3216992 | 2022-10-12 | US | Pennsylvania | Monroe | 42089 | 44175 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-13 04:22:39 | Monroe, Pennsylvania, US | |
3215883 | 3215883 | 2022-10-12 | US | Maryland | Frederick | 24021 | 54398 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-13 04:22:39 | Frederick, Maryland, US | |
3214505 | 3214505 | 2022-10-12 | Russia | Jewish Autonomous Okrug | 21831 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-13 04:22:39 | Jewish Autonomous Okrug, Russia | |||
3252841 | 3252841 | 2022-10-11 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-12 04:22:51 | Monroe, Pennsylvania, US | |
3251732 | 3251732 | 2022-10-11 | US | Maryland | Frederick | 24021 | 54321 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-12 04:22:51 | Frederick, Maryland, US | |
3250354 | 3250354 | 2022-10-11 | Russia | Jewish Autonomous Okrug | 21821 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-12 04:22:51 | Jewish Autonomous Okrug, Russia | |||
2970100 | 2970100 | 2022-10-10 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-11 04:23:05 | Monroe, Pennsylvania, US | |
2969631 | 2969631 | 2022-10-10 | US | New York | Albany | 36001 | 73482 | 559 | 0 | 42.60060306 | -73.97723916 | 2022-10-11 04:23:05 | Albany, New York, US | |
2968991 | 2968991 | 2022-10-10 | US | Maryland | Frederick | 24021 | 54300 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-11 04:23:05 | Frederick, Maryland, US | |
2967613 | 2967613 | 2022-10-10 | Russia | Jewish Autonomous Okrug | 21814 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-11 04:23:05 | Jewish Autonomous Okrug, Russia | |||
3100136 | 3100136 | 2022-10-09 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-10 04:22:32 | Monroe, Pennsylvania, US | |
3099667 | 3099667 | 2022-10-09 | US | New York | Albany | 36001 | 73446 | 559 | 0 | 42.60060306 | -73.97723916 | 2022-10-10 04:22:32 | Albany, New York, US | |
3099027 | 3099027 | 2022-10-09 | US | Maryland | Frederick | 24021 | 54300 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-10 04:22:32 | Frederick, Maryland, US | |
3097649 | 3097649 | 2022-10-09 | Russia | Jewish Autonomous Okrug | 21803 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-10 04:22:32 | Jewish Autonomous Okrug, Russia | |||
4005361 | 4005361 | 2022-10-08 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-09 04:21:16 | Monroe, Pennsylvania, US | |
4004892 | 4004892 | 2022-10-08 | US | New York | Albany | 36001 | 73397 | 559 | 0 | 42.60060306 | -73.97723916 | 2022-10-09 04:21:16 | Albany, New York, US | |
4004252 | 4004252 | 2022-10-08 | US | Maryland | Frederick | 24021 | 54300 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-09 04:21:16 | Frederick, Maryland, US | |
4002874 | 4002874 | 2022-10-08 | Russia | Jewish Autonomous Okrug | 21790 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-09 04:21:16 | Jewish Autonomous Okrug, Russia | |||
398958 | 398958 | 2022-10-07 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-08 04:22:56 | Monroe, Pennsylvania, US | |
398489 | 398489 | 2022-10-07 | US | New York | Albany | 36001 | 73325 | 559 | 0 | 42.60060306 | -73.97723916 | 2022-10-08 04:22:56 | Albany, New York, US | |
397849 | 397849 | 2022-10-07 | US | Maryland | Frederick | 24021 | 54300 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-08 04:22:56 | Frederick, Maryland, US | |
396471 | 396471 | 2022-10-07 | Russia | Jewish Autonomous Okrug | 21774 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-08 04:22:56 | Jewish Autonomous Okrug, Russia | |||
2532075 | 2532075 | 2022-10-06 | US | Pennsylvania | Monroe | 42089 | 43978 | 559 | 0 | 41.05934058 | -75.34031025 | 2022-10-07 04:23:08 | Monroe, Pennsylvania, US | |
2531606 | 2531606 | 2022-10-06 | US | New York | Albany | 36001 | 73254 | 559 | 0 | 42.60060306 | -73.97723916 | 2022-10-07 04:23:08 | Albany, New York, US | |
2530966 | 2530966 | 2022-10-06 | US | Maryland | Frederick | 24021 | 54272 | 559 | 0 | 39.47296601 | -77.39999394 | 2022-10-07 04:23:08 | Frederick, Maryland, US | |
2529912 | 2529912 | 2022-10-06 | US | Arkansas | Sebastian | 5131 | 37405 | 559 | 0 | 35.19605503 | -94.27162713 | 2022-10-07 04:23:08 | Sebastian, Arkansas, US | |
2529588 | 2529588 | 2022-10-06 | Russia | Jewish Autonomous Okrug | 21760 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-10-07 04:23:08 | Jewish Autonomous Okrug, Russia |
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]);