johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
212 rows where country_or_region = "US", deaths = 50 and province_or_state = "Oregon" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2338006 | 2338006 | 2022-07-27 | US | Oregon | Baker | 41001 | 3498 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-28 04:20:56 | Baker, Oregon, US | |
1490196 | 1490196 | 2022-07-26 | US | Oregon | Baker | 41001 | 3495 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-27 04:21:04 | Baker, Oregon, US | |
2596642 | 2596642 | 2022-07-25 | US | Oregon | Baker | 41001 | 3484 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-26 04:20:58 | Baker, Oregon, US | |
898757 | 898757 | 2022-07-24 | US | Oregon | Baker | 41001 | 3479 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-25 04:20:51 | Baker, Oregon, US | |
93751 | 93751 | 2022-07-23 | US | Oregon | Baker | 41001 | 3479 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-24 04:20:47 | Baker, Oregon, US | |
902773 | 902773 | 2022-07-22 | US | Oregon | Baker | 41001 | 3479 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-23 04:20:53 | Baker, Oregon, US | |
672909 | 672909 | 2022-07-21 | US | Oregon | Baker | 41001 | 3471 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-22 04:21:15 | Baker, Oregon, US | |
1610872 | 1610872 | 2022-07-20 | US | Oregon | Baker | 41001 | 3464 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-21 04:21:10 | Baker, Oregon, US | |
961505 | 961505 | 2022-07-19 | US | Oregon | Baker | 41001 | 3457 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-20 04:20:59 | Baker, Oregon, US | |
3212892 | 3212892 | 2022-07-18 | US | Oregon | Baker | 41001 | 3453 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-19 04:20:58 | Baker, Oregon, US | |
3408067 | 3408067 | 2022-07-17 | US | Oregon | Baker | 41001 | 3448 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-18 04:20:59 | Baker, Oregon, US | |
2154267 | 2154267 | 2022-07-16 | US | Oregon | Baker | 41001 | 3448 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-17 04:21:15 | Baker, Oregon, US | |
2421500 | 2421500 | 2022-07-15 | US | Oregon | Baker | 41001 | 3448 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-16 04:21:05 | Baker, Oregon, US | |
3431575 | 3431575 | 2022-07-14 | US | Oregon | Baker | 41001 | 3443 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-15 04:20:53 | Baker, Oregon, US | |
3112095 | 3112095 | 2022-07-13 | US | Oregon | Baker | 41001 | 3442 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-14 04:20:57 | Baker, Oregon, US | |
632518 | 632518 | 2022-07-12 | US | Oregon | Baker | 41001 | 3437 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-13 04:20:58 | Baker, Oregon, US | |
1214162 | 1214162 | 2022-07-11 | US | Oregon | Baker | 41001 | 3424 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-12 04:20:51 | Baker, Oregon, US | |
2791644 | 2791644 | 2022-07-10 | US | Oregon | Baker | 41001 | 3422 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-11 04:20:46 | Baker, Oregon, US | |
144597 | 144597 | 2022-07-09 | US | Oregon | Baker | 41001 | 3422 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-10 04:20:54 | Baker, Oregon, US | |
1419697 | 1419697 | 2022-07-08 | US | Oregon | Baker | 41001 | 3422 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-09 04:20:59 | Baker, Oregon, US | |
2743622 | 2743622 | 2022-07-07 | US | Oregon | Baker | 41001 | 3410 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-08 04:20:56 | Baker, Oregon, US | |
1202417 | 1202417 | 2022-07-06 | US | Oregon | Baker | 41001 | 3404 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-07 04:20:55 | Baker, Oregon, US | |
3969160 | 3969160 | 2022-07-05 | US | Oregon | Baker | 41001 | 3394 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-06 04:20:58 | Baker, Oregon, US | |
3080671 | 3080671 | 2022-07-04 | US | Oregon | Baker | 41001 | 3387 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-05 04:20:45 | Baker, Oregon, US | |
1769953 | 1769953 | 2022-07-03 | US | Oregon | Baker | 41001 | 3387 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-04 04:20:54 | Baker, Oregon, US | |
3367939 | 3367939 | 2022-07-02 | US | Oregon | Baker | 41001 | 3387 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-03 04:20:59 | Baker, Oregon, US | |
596268 | 596268 | 2022-07-01 | US | Oregon | Baker | 41001 | 3387 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-02 04:21:16 | Baker, Oregon, US | |
3942669 | 3942669 | 2022-06-30 | US | Oregon | Baker | 41001 | 3376 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-07-01 04:21:10 | Baker, Oregon, US | |
2492627 | 2492627 | 2022-06-29 | US | Oregon | Baker | 41001 | 3368 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-30 04:21:01 | Baker, Oregon, US | |
2242009 | 2242009 | 2022-06-28 | US | Oregon | Baker | 41001 | 3361 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-29 04:20:59 | Baker, Oregon, US | |
2150251 | 2150251 | 2022-06-27 | US | Oregon | Baker | 41001 | 3343 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-28 04:20:58 | Baker, Oregon, US | |
478052 | 478052 | 2022-06-26 | US | Oregon | Baker | 41001 | 3330 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-27 04:21:00 | Baker, Oregon, US | |
941427 | 941427 | 2022-06-25 | US | Oregon | Baker | 41001 | 3330 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-26 04:21:02 | Baker, Oregon, US | |
3349247 | 3349247 | 2022-06-24 | US | Oregon | Baker | 41001 | 3330 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-25 04:20:57 | Baker, Oregon, US | |
1650988 | 1650988 | 2022-06-23 | US | Oregon | Baker | 41001 | 3328 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-24 04:20:58 | Baker, Oregon, US | |
2190223 | 2190223 | 2022-06-22 | US | Oregon | Baker | 41001 | 3319 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-23 04:20:55 | Baker, Oregon, US | |
2190226 | 2190226 | 2022-06-22 | US | Oregon | Clatsop | 41007 | 5205 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-23 04:20:55 | Clatsop, Oregon, US | |
168654 | 168654 | 2022-06-21 | US | Oregon | Baker | 41001 | 3313 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-22 04:20:54 | Baker, Oregon, US | |
168657 | 168657 | 2022-06-21 | US | Oregon | Clatsop | 41007 | 5184 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-22 04:20:54 | Clatsop, Oregon, US | |
1765937 | 1765937 | 2022-06-20 | US | Oregon | Baker | 41001 | 3310 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-21 04:20:56 | Baker, Oregon, US | |
1765940 | 1765940 | 2022-06-20 | US | Oregon | Clatsop | 41007 | 5156 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-21 04:20:56 | Clatsop, Oregon, US | |
3272123 | 3272123 | 2022-06-19 | US | Oregon | Baker | 41001 | 3310 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-20 04:21:01 | Baker, Oregon, US | |
3272126 | 3272126 | 2022-06-19 | US | Oregon | Clatsop | 41007 | 5156 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-20 04:21:01 | Clatsop, Oregon, US | |
3400035 | 3400035 | 2022-06-18 | US | Oregon | Baker | 41001 | 3310 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-19 04:20:51 | Baker, Oregon, US | |
3400038 | 3400038 | 2022-06-18 | US | Oregon | Clatsop | 41007 | 5156 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-19 04:20:51 | Clatsop, Oregon, US | |
2313912 | 2313912 | 2022-06-17 | US | Oregon | Baker | 41001 | 3310 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-18 04:21:10 | Baker, Oregon, US | |
2313915 | 2313915 | 2022-06-17 | US | Oregon | Clatsop | 41007 | 5156 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-18 04:21:10 | Clatsop, Oregon, US | |
561416 | 561416 | 2022-06-16 | US | Oregon | Baker | 41001 | 3304 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-17 04:20:56 | Baker, Oregon, US | |
561419 | 561419 | 2022-06-16 | US | Oregon | Clatsop | 41007 | 5148 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-17 04:20:56 | Clatsop, Oregon, US | |
3985218 | 3985218 | 2022-06-15 | US | Oregon | Baker | 41001 | 3304 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-16 04:20:55 | Baker, Oregon, US | |
3985221 | 3985221 | 2022-06-15 | US | Oregon | Clatsop | 41007 | 5135 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-16 04:20:55 | Clatsop, Oregon, US | |
949459 | 949459 | 2022-06-14 | US | Oregon | Baker | 41001 | 3296 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-15 04:20:54 | Baker, Oregon, US | |
949462 | 949462 | 2022-06-14 | US | Oregon | Clatsop | 41007 | 5125 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-15 04:20:54 | Clatsop, Oregon, US | |
2981867 | 2981867 | 2022-06-13 | US | Oregon | Baker | 41001 | 3289 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-14 04:20:52 | Baker, Oregon, US | |
2981870 | 2981870 | 2022-06-13 | US | Oregon | Clatsop | 41007 | 5116 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-14 04:20:52 | Clatsop, Oregon, US | |
2237993 | 2237993 | 2022-06-12 | US | Oregon | Baker | 41001 | 3286 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-13 04:21:14 | Baker, Oregon, US | |
2237996 | 2237996 | 2022-06-12 | US | Oregon | Clatsop | 41007 | 5081 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-13 04:21:14 | Clatsop, Oregon, US | |
3144191 | 3144191 | 2022-06-11 | US | Oregon | Baker | 41001 | 3286 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-12 04:20:53 | Baker, Oregon, US | |
3144194 | 3144194 | 2022-06-11 | US | Oregon | Clatsop | 41007 | 5081 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-12 04:20:53 | Clatsop, Oregon, US | |
1947107 | 1947107 | 2022-06-10 | US | Oregon | Baker | 41001 | 3286 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-11 04:21:01 | Baker, Oregon, US | |
1947110 | 1947110 | 2022-06-10 | US | Oregon | Clatsop | 41007 | 5081 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-11 04:21:01 | Clatsop, Oregon, US | |
3160246 | 3160246 | 2022-06-09 | US | Oregon | Baker | 41001 | 3284 | 50 | 0 | 44.70915557 | -117.6749883 | 2022-06-10 04:20:55 | Baker, Oregon, US | |
3160249 | 3160249 | 2022-06-09 | US | Oregon | Clatsop | 41007 | 5066 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-10 04:20:55 | Clatsop, Oregon, US | |
1423716 | 1423716 | 2022-06-08 | US | Oregon | Clatsop | 41007 | 5057 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-09 04:20:54 | Clatsop, Oregon, US | |
3728830 | 3728830 | 2022-06-07 | US | Oregon | Clatsop | 41007 | 5046 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-08 04:20:55 | Clatsop, Oregon, US | |
3890232 | 3890232 | 2022-06-06 | US | Oregon | Clatsop | 41007 | 5024 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-07 04:21:08 | Clatsop, Oregon, US | |
3510001 | 3510001 | 2022-06-05 | US | Oregon | Clatsop | 41007 | 4987 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-06 04:20:57 | Clatsop, Oregon, US | |
3530078 | 3530078 | 2022-06-04 | US | Oregon | Clatsop | 41007 | 4987 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-05 04:20:55 | Clatsop, Oregon, US | |
3136164 | 3136164 | 2022-06-03 | US | Oregon | Clatsop | 41007 | 4987 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-04 04:20:58 | Clatsop, Oregon, US | |
3581239 | 3581239 | 2022-06-02 | US | Oregon | Clatsop | 41007 | 4984 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-03 04:20:58 | Clatsop, Oregon, US | |
973532 | 973532 | 2022-06-01 | US | Oregon | Clatsop | 41007 | 4966 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-02 05:20:39 | Clatsop, Oregon, US | |
231839 | 231839 | 2022-05-31 | US | Oregon | Clatsop | 41007 | 4958 | 50 | 0 | 45.99712889 | -123.660711 | 2022-06-01 04:20:55 | Clatsop, Oregon, US | |
3188604 | 3188604 | 2022-05-30 | US | Oregon | Clatsop | 41007 | 4937 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-31 04:20:51 | Clatsop, Oregon, US | |
3200753 | 3200753 | 2022-05-29 | US | Oregon | Clatsop | 41007 | 4937 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-30 04:20:50 | Clatsop, Oregon, US | |
2727631 | 2727631 | 2022-05-28 | US | Oregon | Clatsop | 41007 | 4937 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-29 04:20:53 | Clatsop, Oregon, US | |
1316812 | 1316812 | 2022-05-27 | US | Oregon | Clatsop | 41007 | 4937 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-28 04:21:07 | Clatsop, Oregon, US | |
1852604 | 1852604 | 2022-05-26 | US | Oregon | Clatsop | 41007 | 4922 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-27 04:20:56 | Clatsop, Oregon, US | |
2050480 | 2050480 | 2022-05-25 | US | Oregon | Clatsop | 41007 | 4918 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-26 04:20:50 | Clatsop, Oregon, US | |
3001918 | 3001918 | 2022-05-24 | US | Oregon | Clatsop | 41007 | 4905 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-25 04:20:56 | Clatsop, Oregon, US | |
3595639 | 3595639 | 2022-05-23 | US | Oregon | Clatsop | 41007 | 4891 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-24 04:20:57 | Clatsop, Oregon, US | |
624491 | 624491 | 2022-05-22 | US | Oregon | Clatsop | 41007 | 4918 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-26 04:20:50 | Clatsop, Oregon, US | |
1112187 | 1112187 | 2022-05-21 | US | Oregon | Clatsop | 41007 | 4867 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-22 04:20:52 | Clatsop, Oregon, US | |
1171811 | 1171811 | 2022-05-20 | US | Oregon | Clatsop | 41007 | 4867 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-21 04:20:58 | Clatsop, Oregon, US | |
3898574 | 3898574 | 2022-05-19 | US | Oregon | Clatsop | 41007 | 4862 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-20 04:20:57 | Clatsop, Oregon, US | |
1187358 | 1187358 | 2022-05-18 | US | Oregon | Clatsop | 41007 | 4850 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-19 04:20:54 | Clatsop, Oregon, US | |
3585255 | 3585255 | 2022-05-17 | US | Oregon | Clatsop | 41007 | 4834 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-18 04:20:50 | Clatsop, Oregon, US | |
1506212 | 1506212 | 2022-05-16 | US | Oregon | Clatsop | 41007 | 4834 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-17 04:20:59 | Clatsop, Oregon, US | |
2086571 | 2086571 | 2022-05-15 | US | Oregon | Clatsop | 41007 | 4810 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-16 04:20:47 | Clatsop, Oregon, US | |
3357281 | 3357281 | 2022-05-14 | US | Oregon | Clatsop | 41007 | 4810 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-15 04:20:53 | Clatsop, Oregon, US | |
660926 | 660926 | 2022-05-13 | US | Oregon | Clatsop | 41007 | 4810 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-14 04:20:48 | Clatsop, Oregon, US | |
2536009 | 2536009 | 2022-05-12 | US | Oregon | Clatsop | 41007 | 4799 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-13 04:20:51 | Clatsop, Oregon, US | |
3447455 | 3447455 | 2022-05-11 | US | Oregon | Clatsop | 41007 | 4787 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-12 04:20:54 | Clatsop, Oregon, US | |
3538072 | 3538072 | 2022-05-10 | US | Oregon | Clatsop | 41007 | 4779 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-11 04:20:48 | Clatsop, Oregon, US | |
224607 | 224607 | 2022-05-09 | US | Oregon | Clatsop | 41007 | 4773 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-10 04:20:50 | Clatsop, Oregon, US | |
2333992 | 2333992 | 2022-05-08 | US | Oregon | Clatsop | 41007 | 4755 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-09 04:20:54 | Clatsop, Oregon, US | |
362954 | 362954 | 2022-05-07 | US | Oregon | Clatsop | 41007 | 4755 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-08 04:20:49 | Clatsop, Oregon, US | |
1400305 | 1400305 | 2022-05-06 | US | Oregon | Clatsop | 41007 | 4755 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-07 04:21:09 | Clatsop, Oregon, US | |
2600660 | 2600660 | 2022-05-05 | US | Oregon | Clatsop | 41007 | 4744 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-06 04:21:00 | Clatsop, Oregon, US | |
3268109 | 3268109 | 2022-05-04 | US | Oregon | Clatsop | 41007 | 4727 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-05 04:20:55 | Clatsop, Oregon, US | |
1574748 | 1574748 | 2022-05-03 | US | Oregon | Clatsop | 41007 | 4715 | 50 | 0 | 45.99712889 | -123.660711 | 2022-05-04 04:20:59 | Clatsop, Oregon, 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]);