johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Cordoba" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3045240 | 3045240 | 2020-07-02 | Colombia | Cordoba | 801 | 59 | 241 | 501 | 8.0493 | -75.574 | 2020-07-03 04:33:54 | Cordoba, Colombia | ||
302931 | 302931 | 2020-07-01 | Colombia | Cordoba | 786 | 53 | 229 | 504 | 8.0493 | -75.574 | 2020-07-02 04:33:46 | Cordoba, Colombia | ||
2974309 | 2974309 | 2020-06-30 | Colombia | Cordoba | 744 | 46 | 212 | 486 | 8.0493 | -75.574 | 2020-07-01 04:33:52 | Cordoba, Colombia | ||
2632786 | 2632786 | 2020-06-29 | Colombia | Cordoba | 642 | 40 | 200 | 402 | 8.0493 | -75.574 | 2020-06-30 04:33:48 | Cordoba, Colombia | ||
2306349 | 2306349 | 2020-06-28 | Colombia | Cordoba | 642 | 40 | 200 | 402 | 8.0493 | -75.574 | 2020-06-29 04:33:44 | Cordoba, Colombia | ||
2039684 | 2039684 | 2020-06-27 | Colombia | Cordoba | 548 | 37 | 176 | 335 | 8.0493 | -75.574 | 2020-06-28 04:34:04 | Cordoba, Colombia | ||
1135965 | 1135965 | 2020-06-26 | Colombia | Cordoba | 525 | 34 | 150 | 341 | 8.0493 | -75.574 | 2020-06-27 04:33:35 | Cordoba, Colombia | ||
2624952 | 2624952 | 2020-06-25 | Colombia | Cordoba | 485 | 31 | 136 | 318 | 8.0493 | -75.574 | 2020-06-26 04:33:43 | Cordoba, Colombia | ||
2700592 | 2700592 | 2020-06-24 | Colombia | Cordoba | 467 | 30 | 119 | 318 | 8.0493 | -75.574 | 2020-06-25 05:26:54 | Cordoba, Colombia | ||
1522277 | 1522277 | 2020-06-23 | Colombia | Cordoba | 467 | 30 | 119 | 318 | 8.0493 | -75.574 | 2020-06-24 04:33:28 | Cordoba, Colombia | ||
1510471 | 1510471 | 2020-06-22 | Colombia | Cordoba | 458 | 28 | 115 | 315 | 8.0493 | -75.574 | 2020-06-23 04:33:22 | Cordoba, Colombia | ||
3249210 | 3249210 | 2020-06-21 | Colombia | Cordoba | 441 | 27 | 108 | 306 | 8.0493 | -75.574 | 2020-06-22 04:33:20 | Cordoba, Colombia | ||
2437803 | 2437803 | 2020-06-20 | Colombia | Cordoba | 407 | 21 | 100 | 286 | 8.0493 | -75.574 | 2020-06-21 04:33:19 | Cordoba, Colombia | ||
1691381 | 1691381 | 2020-06-19 | Colombia | Cordoba | 379 | 21 | 98 | 260 | 8.0493 | -75.574 | 2020-06-20 04:33:19 | Cordoba, Colombia | ||
3682530 | 3682530 | 2020-06-18 | Colombia | Cordoba | 311 | 17 | 88 | 206 | 8.0493 | -75.574 | 2020-06-19 04:33:17 | Cordoba, Colombia | ||
1195733 | 1195733 | 2020-06-17 | Colombia | Cordoba | 303 | 17 | 84 | 202 | 8.0493 | -75.574 | 2020-06-18 04:33:18 | Cordoba, Colombia | ||
2386496 | 2386496 | 2020-06-16 | Colombia | Cordoba | 279 | 16 | 81 | 182 | 8.0493 | -75.574 | 2020-06-17 04:33:21 | Cordoba, Colombia | ||
287059 | 287059 | 2020-06-15 | Colombia | Cordoba | 279 | 16 | 81 | 182 | 8.0493 | -75.574 | 2020-06-16 04:33:09 | Cordoba, Colombia | ||
1837010 | 1837010 | 2020-06-14 | Colombia | Cordoba | 253 | 13 | 78 | 162 | 8.0493 | -75.574 | 2020-06-15 03:33:14 | Cordoba, Colombia | ||
3061062 | 3061062 | 2020-06-13 | Colombia | Cordoba | 248 | 13 | 71 | 164 | 8.0493 | -75.574 | 2020-06-14 03:33:15 | Cordoba, Colombia | ||
737382 | 737382 | 2020-06-12 | Colombia | Cordoba | 243 | 13 | 70 | 160 | 8.0493 | -75.574 | 2020-06-13 03:33:14 | Cordoba, Colombia | ||
1273352 | 1273352 | 2020-06-11 | Colombia | Cordoba | 235 | 13 | 68 | 154 | 8.0493 | -75.574 | 2020-06-12 05:09:52 | Cordoba, Colombia | ||
2863796 | 2863796 | 2020-06-10 | Colombia | Cordoba | 231 | 13 | 68 | 150 | 8.0493 | -75.574 | 2020-06-11 03:33:41 | Cordoba, Colombia | ||
1210647 | 1210647 | 2020-06-09 | Colombia | Cordoba | 226 | 11 | 66 | 149 | 8.0493 | -75.574 | 2020-06-10 04:07:00 | Cordoba, Colombia | ||
217074 | 217074 | 2020-06-08 | Colombia | Cordoba | 226 | 11 | 66 | 149 | 8.0493 | -75.574 | 2020-06-09 03:33:03 | Cordoba, Colombia | ||
2799871 | 2799871 | 2020-06-07 | Colombia | Cordoba | 210 | 10 | 65 | 135 | 8.0493 | -75.574 | 2020-06-08 03:33:22 | Cordoba, Colombia | ||
573927 | 573927 | 2020-06-06 | Colombia | Cordoba | 195 | 9 | 64 | 122 | 8.0493 | -75.574 | 2020-06-07 03:53:30 | Cordoba, Colombia | ||
1269624 | 1269624 | 2020-06-05 | Colombia | Cordoba | 195 | 9 | 64 | 122 | 8.0493 | -75.574 | 2020-06-06 02:33:00 | Cordoba, Colombia | ||
1281104 | 1281104 | 2020-06-04 | Colombia | Cordoba | 163 | 7 | 56 | 100 | 8.0493 | -75.574 | 2020-06-05 02:33:06 | Cordoba, Colombia | ||
3866659 | 3866659 | 2020-06-03 | Colombia | Cordoba | 135 | 7 | 48 | 80 | 8.0493 | -75.574 | 2020-06-04 02:33:14 | Cordoba, Colombia | ||
2555702 | 2555702 | 2020-06-02 | Colombia | Cordoba | 135 | 7 | 46 | 82 | 8.0493 | -75.574 | 2020-06-03 02:33:13 | Cordoba, Colombia | ||
805238 | 805238 | 2020-06-01 | Colombia | Cordoba | 124 | 7 | 38 | 79 | 8.0493 | -75.574 | 2020-06-02 02:33:08 | Cordoba, Colombia | ||
1793866 | 1793866 | 2020-05-31 | Colombia | Cordoba | 121 | 6 | 27 | 88 | 8.0493 | -75.574 | 2020-06-01 02:32:46 | Cordoba, Colombia | ||
3638759 | 3638759 | 2020-05-30 | Colombia | Cordoba | 110 | 6 | 27 | 77 | 8.0493 | -75.574 | 2020-05-31 02:32:45 | Cordoba, Colombia | ||
1790300 | 1790300 | 2020-05-29 | Colombia | Cordoba | 101 | 6 | 25 | 70 | 8.0493 | -75.574 | 2020-05-30 02:32:48 | Cordoba, Colombia | ||
2712180 | 2712180 | 2020-05-28 | Colombia | Cordoba | 96 | 6 | 23 | 67 | 8.0493 | -75.574 | 2020-05-29 02:32:50 | Cordoba, Colombia |
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]);