johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Kalmar" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2017045 | 2017045 | 2022-09-20 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-21 04:23:22 | Kalmar, Sweden | |||
3570918 | 3570918 | 2022-09-19 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-20 04:22:48 | Kalmar, Sweden | |||
419657 | 419657 | 2022-09-18 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-19 04:21:49 | Kalmar, Sweden | |||
3373681 | 3373681 | 2022-09-17 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-18 04:22:50 | Kalmar, Sweden | |||
2355789 | 2355789 | 2022-09-16 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-17 04:20:19 | Kalmar, Sweden | |||
3986946 | 3986946 | 2022-09-15 | Sweden | Kalmar | 61758 | 372 | 0 | 57.235 | 16.1849 | 2022-09-16 04:21:19 | Kalmar, Sweden | |||
1889463 | 1889463 | 2022-09-14 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-15 04:21:02 | Kalmar, Sweden | |||
372518 | 372518 | 2022-09-13 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-14 04:20:44 | Kalmar, Sweden | |||
2395121 | 2395121 | 2022-09-12 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-13 04:20:57 | Kalmar, Sweden | |||
3766199 | 3766199 | 2022-09-11 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-12 04:20:58 | Kalmar, Sweden | |||
3824774 | 3824774 | 2022-09-10 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-11 04:20:50 | Kalmar, Sweden | |||
963231 | 963231 | 2022-09-09 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-10 04:21:10 | Kalmar, Sweden | |||
253633 | 253633 | 2022-09-08 | Sweden | Kalmar | 61588 | 369 | 0 | 57.235 | 16.1849 | 2022-09-09 04:21:11 | Kalmar, Sweden | |||
3745431 | 3745431 | 2022-09-07 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-08 04:21:02 | Kalmar, Sweden | |||
115071 | 115071 | 2022-09-06 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-07 04:20:59 | Kalmar, Sweden | |||
2634043 | 2634043 | 2022-09-05 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-06 04:21:02 | Kalmar, Sweden | |||
2987607 | 2987607 | 2022-09-04 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-05 04:21:01 | Kalmar, Sweden | |||
2713292 | 2713292 | 2022-09-03 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-04 04:21:22 | Kalmar, Sweden | |||
1393997 | 1393997 | 2022-09-02 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-03 04:21:04 | Kalmar, Sweden | |||
3547826 | 3547826 | 2022-09-01 | Sweden | Kalmar | 61477 | 368 | 0 | 57.235 | 16.1849 | 2022-09-02 04:21:07 | Kalmar, Sweden | |||
2343746 | 2343746 | 2022-08-31 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-09-01 04:21:03 | Kalmar, Sweden | |||
3774226 | 3774226 | 2022-08-30 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-31 04:20:57 | Kalmar, Sweden | |||
1680822 | 1680822 | 2022-08-29 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-30 04:21:03 | Kalmar, Sweden | |||
1877306 | 1877306 | 2022-08-28 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-29 04:21:06 | Kalmar, Sweden | |||
2096433 | 2096433 | 2022-08-27 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-28 04:21:02 | Kalmar, Sweden | |||
1532248 | 1532248 | 2022-08-26 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-27 04:20:57 | Kalmar, Sweden | |||
2829135 | 2829135 | 2022-08-25 | Sweden | Kalmar | 61383 | 368 | 0 | 57.235 | 16.1849 | 2022-08-26 04:21:02 | Kalmar, Sweden | |||
2323668 | 2323668 | 2022-08-24 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-25 04:21:13 | Kalmar, Sweden | |||
1251077 | 1251077 | 2022-08-23 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-24 04:20:46 | Kalmar, Sweden | |||
2853181 | 2853181 | 2022-08-22 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-23 04:20:56 | Kalmar, Sweden | |||
2403153 | 2403153 | 2022-08-21 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-22 04:20:38 | Kalmar, Sweden | |||
3798231 | 3798231 | 2022-08-20 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-21 04:20:44 | Kalmar, Sweden | |||
2363817 | 2363817 | 2022-08-19 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-20 04:21:01 | Kalmar, Sweden | |||
1161488 | 1161488 | 2022-08-18 | Sweden | Kalmar | 61272 | 365 | 0 | 57.235 | 16.1849 | 2022-08-19 04:20:54 | Kalmar, Sweden | |||
3950812 | 3950812 | 2022-08-17 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-18 04:21:11 | Kalmar, Sweden | |||
991314 | 991314 | 2022-08-16 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-17 04:20:59 | Kalmar, Sweden | |||
2494353 | 2494353 | 2022-08-15 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-16 04:20:58 | Kalmar, Sweden | |||
3647903 | 3647903 | 2022-08-14 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-15 04:20:59 | Kalmar, Sweden | |||
1968909 | 1968909 | 2022-08-13 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-14 04:20:55 | Kalmar, Sweden | |||
2888718 | 2888718 | 2022-08-12 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-13 04:20:52 | Kalmar, Sweden | |||
3908323 | 3908323 | 2022-08-11 | Sweden | Kalmar | 61160 | 365 | 0 | 57.235 | 16.1849 | 2022-08-12 04:20:54 | Kalmar, Sweden | |||
1346640 | 1346640 | 2022-08-10 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-11 04:20:49 | Kalmar, Sweden | |||
1086395 | 1086395 | 2022-08-09 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-10 04:20:57 | Kalmar, Sweden | |||
3543810 | 3543810 | 2022-08-08 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-09 04:20:34 | Kalmar, Sweden | |||
1070213 | 1070213 | 2022-08-07 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-08 04:21:08 | Kalmar, Sweden | |||
1940801 | 1940801 | 2022-08-06 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-07 04:20:54 | Kalmar, Sweden | |||
880600 | 880600 | 2022-08-05 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-06 04:20:56 | Kalmar, Sweden | |||
2009011 | 2009011 | 2022-08-04 | Sweden | Kalmar | 61035 | 363 | 0 | 57.235 | 16.1849 | 2022-08-05 04:20:52 | Kalmar, Sweden | |||
1098438 | 1098438 | 2022-08-03 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-08-04 04:20:58 | Kalmar, Sweden | |||
1405363 | 1405363 | 2022-08-02 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-08-03 04:20:59 | Kalmar, Sweden | |||
3617401 | 3617401 | 2022-08-01 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-08-02 04:20:53 | Kalmar, Sweden | |||
3871881 | 3871881 | 2022-07-31 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-08-01 04:21:03 | Kalmar, Sweden | |||
674635 | 674635 | 2022-07-30 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-07-31 04:21:02 | Kalmar, Sweden | |||
1783834 | 1783834 | 2022-07-29 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-07-30 04:20:42 | Kalmar, Sweden | |||
1066197 | 1066197 | 2022-07-28 | Sweden | Kalmar | 60886 | 361 | 0 | 57.235 | 16.1849 | 2022-07-29 04:20:45 | Kalmar, Sweden | |||
2335716 | 2335716 | 2022-07-27 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-28 04:20:56 | Kalmar, Sweden | |||
1487906 | 1487906 | 2022-07-26 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-27 04:21:04 | Kalmar, Sweden | |||
2594352 | 2594352 | 2022-07-25 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-26 04:20:58 | Kalmar, Sweden | |||
896467 | 896467 | 2022-07-24 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-25 04:20:51 | Kalmar, Sweden | |||
91461 | 91461 | 2022-07-23 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-24 04:20:47 | Kalmar, Sweden | |||
900483 | 900483 | 2022-07-22 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-23 04:20:53 | Kalmar, Sweden | |||
670619 | 670619 | 2022-07-21 | Sweden | Kalmar | 60755 | 360 | 0 | 57.235 | 16.1849 | 2022-07-22 04:21:15 | Kalmar, Sweden | |||
1608582 | 1608582 | 2022-07-20 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-21 04:21:10 | Kalmar, Sweden | |||
959215 | 959215 | 2022-07-19 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-20 04:20:59 | Kalmar, Sweden | |||
3210602 | 3210602 | 2022-07-18 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-19 04:20:58 | Kalmar, Sweden | |||
3405777 | 3405777 | 2022-07-17 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-18 04:20:59 | Kalmar, Sweden | |||
2151977 | 2151977 | 2022-07-16 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-17 04:21:15 | Kalmar, Sweden | |||
2419210 | 2419210 | 2022-07-15 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-16 04:21:05 | Kalmar, Sweden | |||
3429285 | 3429285 | 2022-07-14 | Sweden | Kalmar | 60598 | 359 | 0 | 57.235 | 16.1849 | 2022-07-15 04:20:53 | Kalmar, Sweden | |||
3109805 | 3109805 | 2022-07-13 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-14 04:20:57 | Kalmar, Sweden | |||
630228 | 630228 | 2022-07-12 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-13 04:20:58 | Kalmar, Sweden | |||
1211872 | 1211872 | 2022-07-11 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-12 04:20:51 | Kalmar, Sweden | |||
2789354 | 2789354 | 2022-07-10 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-11 04:20:46 | Kalmar, Sweden | |||
142307 | 142307 | 2022-07-09 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-10 04:20:54 | Kalmar, Sweden | |||
1417407 | 1417407 | 2022-07-08 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-09 04:20:59 | Kalmar, Sweden | |||
2741332 | 2741332 | 2022-07-07 | Sweden | Kalmar | 60468 | 355 | 0 | 57.235 | 16.1849 | 2022-07-08 04:20:56 | Kalmar, Sweden | |||
1200127 | 1200127 | 2022-07-06 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-07 04:20:55 | Kalmar, Sweden | |||
3966870 | 3966870 | 2022-07-05 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-06 04:20:58 | Kalmar, Sweden | |||
3078381 | 3078381 | 2022-07-04 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-05 04:20:45 | Kalmar, Sweden | |||
1767663 | 1767663 | 2022-07-03 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-04 04:20:54 | Kalmar, Sweden | |||
3365649 | 3365649 | 2022-07-02 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-03 04:20:59 | Kalmar, Sweden | |||
593978 | 593978 | 2022-07-01 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-02 04:21:16 | Kalmar, Sweden | |||
3940379 | 3940379 | 2022-06-30 | Sweden | Kalmar | 60385 | 355 | 0 | 57.235 | 16.1849 | 2022-07-01 04:21:10 | Kalmar, Sweden | |||
2490337 | 2490337 | 2022-06-29 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-30 04:21:01 | Kalmar, Sweden | |||
2239719 | 2239719 | 2022-06-28 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-29 04:20:59 | Kalmar, Sweden | |||
2147961 | 2147961 | 2022-06-27 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-28 04:20:58 | Kalmar, Sweden | |||
475762 | 475762 | 2022-06-26 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-27 04:21:00 | Kalmar, Sweden | |||
939137 | 939137 | 2022-06-25 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-26 04:21:02 | Kalmar, Sweden | |||
3346957 | 3346957 | 2022-06-24 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-25 04:20:57 | Kalmar, Sweden | |||
1648698 | 1648698 | 2022-06-23 | Sweden | Kalmar | 60321 | 355 | 0 | 57.235 | 16.1849 | 2022-06-24 04:20:58 | Kalmar, Sweden | |||
2187933 | 2187933 | 2022-06-22 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-23 04:20:55 | Kalmar, Sweden | |||
166364 | 166364 | 2022-06-21 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-22 04:20:54 | Kalmar, Sweden | |||
1763647 | 1763647 | 2022-06-20 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-21 04:20:56 | Kalmar, Sweden | |||
3269833 | 3269833 | 2022-06-19 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-20 04:21:01 | Kalmar, Sweden | |||
3397745 | 3397745 | 2022-06-18 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-19 04:20:51 | Kalmar, Sweden | |||
2311622 | 2311622 | 2022-06-17 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-18 04:21:10 | Kalmar, Sweden | |||
559126 | 559126 | 2022-06-16 | Sweden | Kalmar | 60281 | 355 | 0 | 57.235 | 16.1849 | 2022-06-17 04:20:56 | Kalmar, Sweden | |||
3982928 | 3982928 | 2022-06-15 | Sweden | Kalmar | 60260 | 355 | 0 | 57.235 | 16.1849 | 2022-06-16 04:20:55 | Kalmar, Sweden | |||
947169 | 947169 | 2022-06-14 | Sweden | Kalmar | 60260 | 355 | 0 | 57.235 | 16.1849 | 2022-06-15 04:20:54 | Kalmar, Sweden | |||
2979577 | 2979577 | 2022-06-13 | Sweden | Kalmar | 60260 | 355 | 0 | 57.235 | 16.1849 | 2022-06-14 04:20:52 | Kalmar, Sweden |
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]);