johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Emilia-Romagna" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005389 | 1005389 | 2020-07-09 | Italy | Emilia-Romagna | 28769 | 4269 | 23434 | 1066 | 44.49436681 | 11.341720800000001 | 2020-07-10 04:34:24 | Emilia-Romagna, Italy | ||
2222605 | 2222605 | 2020-07-08 | Italy | Emilia-Romagna | 28755 | 4269 | 23415 | 1071 | 44.49436681 | 11.341720800000001 | 2020-07-09 04:34:23 | Emilia-Romagna, Italy | ||
887214 | 887214 | 2020-07-07 | Italy | Emilia-Romagna | 28706 | 4269 | 23377 | 1060 | 44.49436681 | 11.341720800000001 | 2020-07-08 05:33:48 | Emilia-Romagna, Italy | ||
2684774 | 2684774 | 2020-07-06 | Italy | Emilia-Romagna | 28675 | 4268 | 23343 | 1064 | 44.49436681 | 11.341720800000001 | 2020-07-07 04:34:00 | Emilia-Romagna, Italy | ||
415239 | 415239 | 2020-07-05 | Italy | Emilia-Romagna | 28637 | 4268 | 23340 | 1029 | 44.49436681 | 11.341720800000001 | 2020-07-06 04:33:57 | Emilia-Romagna, Italy | ||
529801 | 529801 | 2020-07-04 | Italy | Emilia-Romagna | 28613 | 4267 | 23309 | 1037 | 44.49436681 | 11.341720800000001 | 2020-07-05 04:33:46 | Emilia-Romagna, Italy | ||
2234462 | 2234462 | 2020-07-03 | Italy | Emilia-Romagna | 28562 | 4267 | 23284 | 1011 | 44.49436681 | 11.341720800000001 | 2020-07-04 04:33:51 | Emilia-Romagna, Italy | ||
3045256 | 3045256 | 2020-07-02 | Italy | Emilia-Romagna | 28535 | 4265 | 23267 | 1003 | 44.49436681 | 11.3417208 | 2020-07-03 04:33:54 | Emilia-Romagna, Italy | ||
302947 | 302947 | 2020-07-01 | Italy | Emilia-Romagna | 28508 | 4264 | 23242 | 1002 | 44.49436681 | 11.341720800000001 | 2020-07-02 04:33:46 | Emilia-Romagna, Italy | ||
2974325 | 2974325 | 2020-06-30 | Italy | Emilia-Romagna | 28492 | 4260 | 23222 | 1010 | 44.49436681 | 11.341720800000001 | 2020-07-01 04:33:52 | Emilia-Romagna, Italy | ||
2632802 | 2632802 | 2020-06-29 | Italy | Emilia-Romagna | 28472 | 4255 | 23185 | 1032 | 44.49436681 | 11.3417208 | 2020-06-30 04:33:48 | Emilia-Romagna, Italy | ||
2306365 | 2306365 | 2020-06-28 | Italy | Emilia-Romagna | 28456 | 4253 | 23161 | 1042 | 44.49436681 | 11.341720800000001 | 2020-06-29 04:33:44 | Emilia-Romagna, Italy | ||
2039700 | 2039700 | 2020-06-27 | Italy | Emilia-Romagna | 28435 | 4252 | 23142 | 1041 | 44.49436681 | 11.341720800000001 | 2020-06-28 04:34:04 | Emilia-Romagna, Italy | ||
1135981 | 1135981 | 2020-06-26 | Italy | Emilia-Romagna | 28393 | 4252 | 23097 | 1044 | 44.49436681 | 11.341720800000001 | 2020-06-27 04:33:35 | Emilia-Romagna, Italy | ||
2624968 | 2624968 | 2020-06-25 | Italy | Emilia-Romagna | 28351 | 4249 | 23034 | 1068 | 44.49436681 | 11.341720800000001 | 2020-06-26 04:33:43 | Emilia-Romagna, Italy | ||
2700608 | 2700608 | 2020-06-24 | Italy | Emilia-Romagna | 28304 | 4245 | 22985 | 1074 | 44.49436681 | 11.341720800000001 | 2020-06-25 05:26:54 | Emilia-Romagna, Italy | ||
1522293 | 1522293 | 2020-06-23 | Italy | Emilia-Romagna | 28260 | 4236 | 22935 | 1089 | 44.49436681 | 11.341720800000001 | 2020-06-24 04:33:28 | Emilia-Romagna, Italy | ||
1510487 | 1510487 | 2020-06-22 | Italy | Emilia-Romagna | 28243 | 4235 | 22854 | 1154 | 44.49436681 | 11.341720800000001 | 2020-06-23 04:33:22 | Emilia-Romagna, Italy | ||
3249226 | 3249226 | 2020-06-21 | Italy | Emilia-Romagna | 28221 | 4231 | 22818 | 1172 | 44.49436681 | 11.341720800000001 | 2020-06-22 04:33:20 | Emilia-Romagna, Italy | ||
2437819 | 2437819 | 2020-06-20 | Italy | Emilia-Romagna | 28198 | 4230 | 22761 | 1207 | 44.49436681 | 11.341720800000001 | 2020-06-21 04:33:19 | Emilia-Romagna, Italy | ||
1691397 | 1691397 | 2020-06-19 | Italy | Emilia-Romagna | 28170 | 4224 | 22727 | 1219 | 44.49436681 | 11.341720800000001 | 2020-06-20 04:33:19 | Emilia-Romagna, Italy | ||
3682546 | 3682546 | 2020-06-18 | Italy | Emilia-Romagna | 28143 | 4219 | 22643 | 1281 | 44.49436681 | 11.341720800000001 | 2020-06-19 04:33:17 | Emilia-Romagna, Italy | ||
1195749 | 1195749 | 2020-06-17 | Italy | Emilia-Romagna | 28111 | 4215 | 22551 | 1345 | 44.49436681 | 11.341720800000001 | 2020-06-18 04:33:18 | Emilia-Romagna, Italy | ||
2386512 | 2386512 | 2020-06-16 | Italy | Emilia-Romagna | 28097 | 4209 | 22483 | 1405 | 44.49436681 | 11.341720800000001 | 2020-06-17 04:33:21 | Emilia-Romagna, Italy | ||
287075 | 287075 | 2020-06-15 | Italy | Emilia-Romagna | 28084 | 4207 | 22377 | 1500 | 44.49436681 | 11.341720800000001 | 2020-06-16 04:33:09 | Emilia-Romagna, Italy | ||
1837026 | 1837026 | 2020-06-14 | Italy | Emilia-Romagna | 28073 | 4204 | 22232 | 1637 | 44.49436681 | 11.341720800000001 | 2020-06-15 03:33:14 | Emilia-Romagna, Italy | ||
3061078 | 3061078 | 2020-06-13 | Italy | Emilia-Romagna | 28056 | 4199 | 22130 | 1727 | 44.49436681 | 11.341720800000001 | 2020-06-14 03:33:15 | Emilia-Romagna, Italy | ||
737398 | 737398 | 2020-06-12 | Italy | Emilia-Romagna | 28028 | 4196 | 22015 | 1817 | 44.49436681 | 11.341720800000001 | 2020-06-13 03:33:14 | Emilia-Romagna, Italy | ||
1273368 | 1273368 | 2020-06-11 | Italy | Emilia-Romagna | 27995 | 4192 | 21803 | 2000 | 44.49436681 | 11.341720800000001 | 2020-06-12 05:09:52 | Emilia-Romagna, Italy | ||
2863812 | 2863812 | 2020-06-10 | Italy | Emilia-Romagna | 27970 | 4192 | 21717 | 2061 | 44.49436681 | 11.3417208 | 2020-06-11 03:33:41 | Emilia-Romagna, Italy | ||
1210661 | 1210661 | 2020-06-09 | Italy | Emilia-Romagna | 27946 | 4185 | 21605 | 2156 | 44.49436681 | 11.3417208 | 2020-06-10 04:07:00 | Emilia-Romagna, Italy | ||
217088 | 217088 | 2020-06-08 | Italy | Emilia-Romagna | 27928 | 4179 | 21467 | 2282 | 44.49436681 | 11.3417208 | 2020-06-09 03:33:03 | Emilia-Romagna, Italy | ||
2799885 | 2799885 | 2020-06-07 | Italy | Emilia-Romagna | 27908 | 4175 | 21405 | 2328 | 44.49436681 | 11.3417208 | 2020-06-08 03:33:22 | Emilia-Romagna, Italy | ||
573941 | 573941 | 2020-06-06 | Italy | Emilia-Romagna | 27894 | 4171 | 21307 | 2416 | 44.49436681 | 11.3417208 | 2020-06-07 03:53:30 | Emilia-Romagna, Italy | ||
1269638 | 1269638 | 2020-06-05 | Italy | Emilia-Romagna | 27877 | 4167 | 21198 | 2512 | 44.49436681 | 11.3417208 | 2020-06-06 02:33:00 | Emilia-Romagna, Italy | ||
1281117 | 1281117 | 2020-06-04 | Italy | Emilia-Romagna | 27860 | 4154 | 21018 | 2688 | 44.49436681 | 11.341720800000001 | 2020-06-05 02:33:06 | Emilia-Romagna, Italy | ||
3866672 | 3866672 | 2020-06-03 | Italy | Emilia-Romagna | 27842 | 4147 | 20856 | 2839 | 44.49436681 | 11.341720800000001 | 2020-06-04 02:33:14 | Emilia-Romagna, Italy | ||
2555714 | 2555714 | 2020-06-02 | Italy | Emilia-Romagna | 27828 | 4136 | 20780 | 2912 | 44.49436681 | 11.341720800000001 | 2020-06-03 02:33:13 | Emilia-Romagna, Italy | ||
805251 | 805251 | 2020-06-01 | Italy | Emilia-Romagna | 27809 | 4124 | 20617 | 3068 | 44.49436681 | 11.341720800000001 | 2020-06-02 02:33:08 | Emilia-Romagna, Italy | ||
1793875 | 1793875 | 2020-05-31 | Italy | Emilia-Romagna | 27790 | 4114 | 20513 | 3163 | 44.49436681 | 11.341720800000001 | 2020-06-01 02:32:46 | Emilia-Romagna, Italy | ||
3638768 | 3638768 | 2020-05-30 | Italy | Emilia-Romagna | 27759 | 4107 | 20373 | 3279 | 44.49436681 | 11.341720800000001 | 2020-05-31 02:32:45 | Emilia-Romagna, Italy | ||
1790309 | 1790309 | 2020-05-29 | Italy | Emilia-Romagna | 27739 | 4102 | 20073 | 3564 | 44.49436681 | 11.341720800000001 | 2020-05-30 02:32:48 | Emilia-Romagna, Italy | ||
2712189 | 2712189 | 2020-05-28 | Italy | Emilia-Romagna | 27701 | 4094 | 19857 | 3750 | 44.49436681 | 11.341720800000001 | 2020-05-29 02:32:50 | Emilia-Romagna, Italy | ||
2548181 | 2548181 | 2020-05-27 | Italy | Emilia-Romagna | 27627 | 4083 | 19546 | 3998 | 44.49436681 | 11.3417208 | 2020-05-28 02:32:31 | Emilia-Romagna, Italy | ||
1041144 | 1041144 | 2020-05-26 | Italy | Emilia-Romagna | 27611 | 4076 | 19389 | 4146 | 44.49436681 | 11.3417208 | 2020-05-27 02:32:31 | Emilia-Romagna, Italy | ||
1104874 | 1104874 | 2020-05-25 | Italy | Emilia-Romagna | 27587 | 4068 | 19160 | 4359 | 44.49436681 | 11.3417208 | 2020-05-26 02:32:35 | Emilia-Romagna, Italy | ||
875554 | 875554 | 2020-05-24 | Italy | Emilia-Romagna | 27558 | 4055 | 19046 | 4457 | 44.49436681 | 11.3417208 | 2020-05-25 02:32:44 | Emilia-Romagna, Italy | ||
997745 | 997745 | 2020-05-23 | Italy | Emilia-Romagna | 27513 | 4047 | 18896 | 4570 | 44.49436681 | 11.3417208 | 2020-05-24 02:32:43 | Emilia-Romagna, Italy | ||
1864768 | 1864768 | 2020-05-22 | Italy | Emilia-Romagna | 27470 | 4037 | 18703 | 4730 | 44.49436681 | 11.3417208 | 2020-05-23 02:32:42 | Emilia-Romagna, Italy | ||
268274 | 268274 | 2020-05-21 | Italy | Emilia-Romagna | 27417 | 4025 | 18466 | 4926 | 44.49436681 | 11.3417208 | 2020-05-22 02:36:51 | Emilia-Romagna, Italy | ||
1431857 | 1431857 | 2020-05-20 | Italy | Emilia-Romagna | 27364 | 4008 | 18258 | 5098 | 44.49436681 | 11.3417208 | 2020-05-21 02:32:48 | Emilia-Romagna, Italy | ||
2390128 | 2390128 | 2020-05-19 | Italy | Emilia-Romagna | 27314 | 3997 | 17987 | 5330 | 44.49436681 | 11.341720800000001 | 2020-05-20 02:32:19 | Emilia-Romagna, Italy | ||
3260866 | 3260866 | 2020-05-18 | Italy | Emilia-Romagna | 27267 | 3986 | 17756 | 5525 | 44.49436681 | 11.341720800000001 | 2020-05-19 02:32:18 | Emilia-Romagna, Italy | ||
3416260 | 3416260 | 2020-05-17 | Italy | Emilia-Romagna | 27232 | 3973 | 17603 | 5656 | 44.49436681 | 11.341720800000001 | 2020-05-18 02:32:21 | Emilia-Romagna, Italy | ||
1829494 | 1829494 | 2020-05-16 | Italy | Emilia-Romagna | 27182 | 3960 | 17370 | 5852 | 44.49436681 | 11.341720800000001 | 2020-05-17 02:32:32 | Emilia-Romagna, Italy | ||
3276210 | 3276210 | 2020-05-15 | Italy | Emilia-Romagna | 27110 | 3943 | 17166 | 6001 | 44.49436681 | 11.341720800000001 | 2020-05-16 02:32:19 | Emilia-Romagna, Italy | ||
1404384 | 1404384 | 2020-05-14 | Italy | Emilia-Romagna | 27056 | 3930 | 16825 | 6301 | 44.49436681 | 11.341720800000001 | 2020-05-15 02:33:02 | Emilia-Romagna, Italy |
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]);