johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Thuringen" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2633117 | 2633117 | 2020-06-29 | Germany | Thuringen | 3250 | 181 | 3020 | 49 | 51.011 | 10.8453 | 2020-06-30 04:33:48 | Thuringen, Germany | ||
2306680 | 2306680 | 2020-06-28 | Germany | Thuringen | 3250 | 181 | 3020 | 49 | 51.011 | 10.8453 | 2020-06-29 04:33:44 | Thuringen, Germany | ||
2040015 | 2040015 | 2020-06-27 | Germany | Thuringen | 3248 | 181 | 3020 | 48 | 51.011 | 10.8453 | 2020-06-28 04:34:04 | Thuringen, Germany | ||
1136296 | 1136296 | 2020-06-26 | Germany | Thuringen | 3240 | 178 | 3000 | 63 | 51.011 | 10.8453 | 2020-06-27 04:33:35 | Thuringen, Germany | ||
2625283 | 2625283 | 2020-06-25 | Germany | Thuringen | 3225 | 178 | 3000 | 57 | 51.011 | 10.8453 | 2020-06-26 04:33:43 | Thuringen, Germany | ||
2700923 | 2700923 | 2020-06-24 | Germany | Thuringen | 3231 | 178 | 2970 | 83 | 51.011 | 10.8453 | 2020-06-25 05:26:54 | Thuringen, Germany | ||
1522608 | 1522608 | 2020-06-23 | Germany | Thuringen | 3229 | 178 | 2960 | 91 | 51.011 | 10.8453 | 2020-06-24 04:33:28 | Thuringen, Germany | ||
1510802 | 1510802 | 2020-06-22 | Germany | Thuringen | 3221 | 178 | 2950 | 93 | 51.011 | 10.8453 | 2020-06-23 04:33:22 | Thuringen, Germany | ||
3249541 | 3249541 | 2020-06-21 | Germany | Thuringen | 3214 | 178 | 2940 | 96 | 51.011 | 10.8453 | 2020-06-22 04:33:20 | Thuringen, Germany | ||
2438134 | 2438134 | 2020-06-20 | Germany | Thuringen | 3210 | 178 | 2930 | 103 | 51.011 | 10.8453 | 2020-06-21 04:33:19 | Thuringen, Germany | ||
1691712 | 1691712 | 2020-06-19 | Germany | Thuringen | 3205 | 178 | 2920 | 108 | 51.011 | 10.8453 | 2020-06-20 04:33:19 | Thuringen, Germany | ||
3682861 | 3682861 | 2020-06-18 | Germany | Thuringen | 3189 | 177 | 2890 | 130 | 51.011 | 10.8453 | 2020-06-19 04:33:17 | Thuringen, Germany | ||
1196064 | 1196064 | 2020-06-17 | Germany | Thuringen | 3188 | 178 | 2890 | 125 | 51.011 | 10.8453 | 2020-06-18 04:33:18 | Thuringen, Germany | ||
2386827 | 2386827 | 2020-06-16 | Germany | Thuringen | 3175 | 174 | 2870 | 131 | 51.011 | 10.8453 | 2020-06-17 04:33:21 | Thuringen, Germany | ||
287390 | 287390 | 2020-06-15 | Germany | Thuringen | 3171 | 174 | 2860 | 139 | 51.011 | 10.8453 | 2020-06-16 04:33:09 | Thuringen, Germany | ||
1837341 | 1837341 | 2020-06-14 | Germany | Thuringen | 3169 | 174 | 2860 | 135 | 51.011 | 10.8453 | 2020-06-15 03:33:14 | Thuringen, Germany | ||
3061393 | 3061393 | 2020-06-13 | Germany | Thuringen | 3154 | 174 | 2840 | 142 | 51.011 | 10.8453 | 2020-06-14 03:33:15 | Thuringen, Germany | ||
737713 | 737713 | 2020-06-12 | Germany | Thuringen | 3143 | 171 | 2840 | 138 | 51.011 | 10.8453 | 2020-06-13 03:33:14 | Thuringen, Germany | ||
1273683 | 1273683 | 2020-06-11 | Germany | Thuringen | 3130 | 171 | 2830 | 131 | 51.011 | 10.8453 | 2020-06-12 05:09:52 | Thuringen, Germany | ||
2864124 | 2864124 | 2020-06-10 | Germany | Thuringen | 3108 | 170 | 2810 | 131 | 51.011 | 10.8453 | 2020-06-11 03:33:41 | Thuringen, Germany | ||
1210946 | 1210946 | 2020-06-09 | Germany | Thuringen | 3100 | 170 | 2780 | 152 | 51.011 | 10.8453 | 2020-06-10 04:07:00 | Thuringen, Germany | ||
217373 | 217373 | 2020-06-08 | Germany | Thuringen | 3081 | 170 | 2750 | 167 | 51.011 | 10.8453 | 2020-06-09 03:33:03 | Thuringen, Germany | ||
2800169 | 2800169 | 2020-06-07 | Germany | Thuringen | 3077 | 170 | 2740 | 169 | 51.011 | 10.8453 | 2020-06-08 03:33:22 | Thuringen, Germany | ||
574225 | 574225 | 2020-06-06 | Germany | Thuringen | 3066 | 170 | 2730 | 177 | 51.011 | 10.8453 | 2020-06-07 03:53:30 | Thuringen, Germany | ||
1269922 | 1269922 | 2020-06-05 | Germany | Thuringen | 3051 | 169 | 2710 | 174 | 51.011 | 10.8453 | 2020-06-06 02:33:00 | Thuringen, Germany | ||
1281388 | 1281388 | 2020-06-04 | Germany | Thuringen | 3033 | 167 | 2680 | 195 | 51.011 | 10.8453 | 2020-06-05 02:33:06 | Thuringen, Germany | ||
3866943 | 3866943 | 2020-06-03 | Germany | Thuringen | 3022 | 166 | 2660 | 198 | 51.011 | 10.8453 | 2020-06-04 02:33:14 | Thuringen, Germany | ||
2555985 | 2555985 | 2020-06-02 | Germany | Thuringen | 3017 | 163 | 2630 | 227 | 51.011 | 10.8453 | 2020-06-03 02:33:13 | Thuringen, Germany | ||
805522 | 805522 | 2020-06-01 | Germany | Thuringen | 3015 | 162 | 2610 | 243 | 51.011 | 10.8453 | 2020-06-02 02:33:08 | Thuringen, Germany | ||
1794076 | 1794076 | 2020-05-31 | Germany | Thuringen | 2984 | 162 | 2590 | 234 | 51.011 | 10.8453 | 2020-06-01 02:32:46 | Thuringen, Germany | ||
3638969 | 3638969 | 2020-05-30 | Germany | Thuringen | 2974 | 161 | 2590 | 225 | 51.011 | 10.8453 | 2020-05-31 02:32:45 | Thuringen, Germany | ||
1790510 | 1790510 | 2020-05-29 | Germany | Thuringen | 2958 | 159 | 2570 | 232 | 51.011 | 10.8453 | 2020-05-30 02:32:48 | Thuringen, Germany | ||
2712389 | 2712389 | 2020-05-28 | Germany | Thuringen | 2932 | 158 | 2550 | 233 | 51.011 | 10.8453 | 2020-05-29 02:32:50 | Thuringen, Germany | ||
2548321 | 2548321 | 2020-05-27 | Germany | Thuringen | 2898 | 157 | 2520 | 233 | 51.011 | 10.8453 | 2020-05-28 02:32:31 | Thuringen, Germany | ||
1041284 | 1041284 | 2020-05-26 | Germany | Thuringen | 2877 | 153 | 2500 | 226 | 51.011 | 10.8453 | 2020-05-27 02:32:31 | Thuringen, Germany | ||
1105014 | 1105014 | 2020-05-25 | Germany | Thuringen | 2871 | 152 | 2480 | 239 | 51.011 | 10.8453 | 2020-05-26 02:32:35 | Thuringen, Germany | ||
875694 | 875694 | 2020-05-24 | Germany | Thuringen | 2857 | 152 | 2450 | 263 | 51.011 | 10.8453 | 2020-05-25 02:32:44 | Thuringen, Germany | ||
997885 | 997885 | 2020-05-23 | Germany | Thuringen | 2830 | 151 | 2440 | 249 | 51.011 | 10.8453 | 2020-05-24 02:32:43 | Thuringen, Germany | ||
1864908 | 1864908 | 2020-05-22 | Germany | Thuringen | 2818 | 151 | 2420 | 248 | 51.011 | 10.8453 | 2020-05-23 02:32:42 | Thuringen, Germany | ||
268414 | 268414 | 2020-05-21 | Germany | Thuringen | 2796 | 151 | 2390 | 255 | 51.011 | 10.8453 | 2020-05-22 02:36:51 | Thuringen, Germany | ||
1431997 | 1431997 | 2020-05-20 | Germany | Thuringen | 2760 | 149 | 2340 | 281 | 51.011 | 10.8453 | 2020-05-21 02:32:48 | Thuringen, Germany | ||
2390223 | 2390223 | 2020-05-19 | Germany | Thuringen | 2750 | 147 | 2300 | 304 | 51.011 | 10.8453 | 2020-05-20 02:32:19 | Thuringen, Germany | ||
3260961 | 3260961 | 2020-05-18 | Germany | Thuringen | 2740 | 139 | 2300 | 302 | 51.011 | 10.8453 | 2020-05-19 02:32:18 | Thuringen, Germany | ||
3416355 | 3416355 | 2020-05-17 | Germany | Thuringen | 2725 | 138 | 2230 | 357 | 51.011 | 10.8453 | 2020-05-18 02:32:21 | Thuringen, Germany | ||
1829589 | 1829589 | 2020-05-16 | Germany | Thuringen | 2711 | 137 | 2200 | 374 | 51.011 | 10.8453 | 2020-05-17 02:32:32 | Thuringen, Germany | ||
3276305 | 3276305 | 2020-05-15 | Germany | Thuringen | 2681 | 135 | 2200 | 354 | 51.011 | 10.8453 | 2020-05-16 02:32:19 | Thuringen, Germany | ||
1404479 | 1404479 | 2020-05-14 | Germany | Thuringen | 2652 | 131 | 2200 | 330 | 51.011 | 10.8453 | 2020-05-15 02:33:02 | Thuringen, Germany |
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]);