daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,037 rows where country_or_region = "San Marino" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, day (date)
country_or_region 1
- San Marino · 1,037 ✖
province_or_state 0
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-02-27 | San Marino | 0 | 0 | 0 | 2020-02-27T21:13:10 | |||||||
2020-02-28 | San Marino | 0 | 0 | 0 | 2020-02-27T21:13:10 | |||||||
2020-02-29 | San Marino | 1 | 1 | 0 | 2020-02-27T21:13:10 | |||||||
2020-03-01 | San Marino | 1 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-01T07:13:07 | |||||
2020-03-02 | San Marino | 1 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-02T01:03:12 | |||||
2020-03-03 | San Marino | 9 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-03T15:23:03 | |||||
2020-03-04 | San Marino | 9 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-04T19:33:03 | |||||
2020-03-05 | San Marino | 16 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-05T13:53:03 | |||||
2020-03-06 | San Marino | 22 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-05T13:53:03 | |||||
2020-03-07 | San Marino | 24 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-07T02:13:08 | |||||
2020-03-08 | San Marino | 27 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-08T14:23:10 | |||||
2020-03-09 | San Marino | 37 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-08T14:23:10 | |||||
2020-03-10 | San Marino | 49 | 2 | 0 | 43.9424 | 12.4578 | 2020-03-10T05:13:07 | |||||
2020-03-11 | San Marino | 60 | 2 | 0 | 43.9424 | 12.4578 | 2020-03-11T20:53:02 | |||||
2020-03-12 | San Marino | 60 | 2 | 0 | 43.9424 | 12.4578 | 2020-03-12T08:53:02 | |||||
2020-03-13 | San Marino | 64 | 5 | 0 | 43.9424 | 12.4578 | 2020-03-11T20:00:00 | |||||
2020-03-14 | San Marino | 77 | 5 | 4 | 43.9424 | 12.4578 | 2020-03-14T22:53:02 | |||||
2020-03-15 | San Marino | 77 | 5 | 4 | 43.9424 | 12.4578 | 2020-03-15T18:20:18 | |||||
2020-03-16 | San Marino | 77 | 5 | 4 | 43.9424 | 12.4578 | 2020-03-16T01:33:03 | |||||
2020-03-17 | San Marino | 102 | 9 | 4 | 43.9424 | 12.4578 | 2020-03-16T01:33:03 | |||||
2020-03-18 | San Marino | 104 | 11 | 4 | 43.9424 | 12.4578 | 2020-03-18T02:53:03 | |||||
2020-03-19 | San Marino | 109 | 14 | 4 | 43.9424 | 12.4578 | 2020-03-18T02:53:03 | |||||
2020-03-20 | San Marino | 126 | 14 | 4 | 43.9424 | 12.4578 | 2020-03-20T01:43:03 | |||||
2020-03-21 | San Marino | 151 | 20 | 4 | 43.9424 | 12.4578 | 2020-03-21T17:43:03 | |||||
2020-03-22 | San Marino | 175 | 20 | 4 | 151 | 43.9424 | 12.4578 | 3/22/20 23:45 | San Marino | |||
2020-03-23 | San Marino | 187 | 20 | 4 | 163 | 43.9424 | 12.4578 | 2020-03-23 23:19:21 | San Marino | |||
2020-03-24 | San Marino | 187 | 21 | 4 | 162 | 43.9424 | 12.4578 | 2020-03-24 23:37:15 | San Marino | |||
2020-03-25 | San Marino | 208 | 21 | 4 | 183 | 43.9424 | 12.4578 | 2020-03-25 23:33:04 | San Marino | |||
2020-03-26 | San Marino | 218 | 21 | 4 | 193 | 43.9424 | 12.4578 | 2020-03-26 23:48:18 | San Marino | |||
2020-03-27 | San Marino | 223 | 21 | 4 | 198 | 43.9424 | 12.4578 | 2020-03-27 23:23:03 | San Marino | |||
2020-03-28 | San Marino | 228 | 22 | 6 | 200 | 43.9424 | 12.4578 | 3/28/20 23:05 | San Marino | |||
2020-03-29 | San Marino | 228 | 22 | 6 | 200 | 43.9424 | 12.4578 | 3/29/20 23:08 | San Marino | |||
2020-03-30 | San Marino | 230 | 25 | 13 | 192 | 43.9424 | 12.4578 | 3/30/20 22:52 | San Marino | |||
2020-03-31 | San Marino | 236 | 26 | 13 | 197 | 43.9424 | 12.4578 | 2020-03-31 23:43:43 | San Marino | |||
2020-04-01 | San Marino | 236 | 28 | 13 | 195 | 43.9424 | 12.4578 | 2020-04-01 21:58:34 | San Marino | |||
2020-04-02 | San Marino | 236 | 28 | 21 | 187 | 43.9424 | 12.4578 | 4/2/20 23:25 | San Marino | |||
2020-04-03 | San Marino | 245 | 30 | 21 | 194 | 43.9424 | 12.4578 | 2020-04-03 22:46:20 | San Marino | |||
2020-04-04 | San Marino | 252 | 32 | 27 | 193 | 43.9424 | 12.4578 | 4/4/20 23:34 | San Marino | |||
2020-04-05 | San Marino | 259 | 32 | 35 | 192 | 43.9424 | 12.4578 | 2020-04-05 23:06:26 | San Marino | |||
2020-04-06 | San Marino | 266 | 32 | 35 | 199 | 43.9424 | 12.4578 | 4/6/20 23:21 | San Marino | |||
2020-04-07 | San Marino | 277 | 32 | 40 | 205 | 43.9424 | 12.4578 | 2020-04-07 23:04:29 | San Marino | |||
2020-04-08 | San Marino | 279 | 34 | 40 | 205 | 43.9424 | 12.4578 | 2020-04-08 22:51:39 | San Marino | |||
2020-04-09 | San Marino | 308 | 34 | 49 | 225 | 43.9424 | 12.4578 | 2020-04-09 23:02:19 | San Marino | |||
2020-04-10 | San Marino | 344 | 34 | 50 | 260 | 43.9424 | 12.4578 | 2020-04-10 22:53:48 | San Marino | |||
2020-04-11 | San Marino | 344 | 34 | 53 | 257 | 43.9424 | 12.4578 | 2020-04-11 22:45:13 | San Marino | |||
2020-04-12 | San Marino | 356 | 35 | 53 | 268 | 43.9424 | 12.4578 | 2020-04-12 23:17:00 | San Marino | |||
2020-04-13 | San Marino | 356 | 35 | 53 | 268 | 43.9424 | 12.4578 | 2020-04-13 23:07:34 | San Marino | |||
2020-04-14 | San Marino | 371 | 36 | 53 | 282 | 43.9424 | 12.4578 | 2020-04-14 23:33:12 | San Marino | |||
2020-04-15 | San Marino | 372 | 36 | 53 | 283 | 43.9424 | 12.4578 | 2020-04-15 22:56:32 | San Marino | |||
2020-04-16 | San Marino | 393 | 36 | 55 | 302 | 43.9424 | 12.4578 | 2020-04-16 23:30:31 | San Marino | |||
2020-04-17 | San Marino | 426 | 38 | 57 | 331 | 43.9424 | 12.4578 | 2020-04-17 23:30:32 | San Marino | |||
2020-04-18 | San Marino | 426 | 38 | 60 | 328 | 43.9424 | 12.4578 | 2020-04-18 22:32:28 | San Marino | |||
2020-04-19 | San Marino | 455 | 39 | 60 | 356 | 43.9424 | 12.4578 | 2020-04-19 23:40:41 | San Marino | |||
2020-04-20 | San Marino | 461 | 39 | 61 | 361 | 43.9424 | 12.4578 | 2020-04-20 23:36:27 | San Marino | |||
2020-04-21 | San Marino | 462 | 39 | 62 | 361 | 43.9424 | 12.4578 | 2020-04-21 23:30:30 | San Marino | |||
2020-04-22 | San Marino | 476 | 40 | 62 | 374 | 43.9424 | 12.4578 | 2020-04-22 23:30:32 | San Marino | |||
2020-04-23 | San Marino | 488 | 40 | 63 | 385 | 43.9424 | 12.4578 | 2020-04-24 03:30:31 | San Marino | |||
2020-04-24 | San Marino | 501 | 40 | 64 | 397 | 43.9424 | 12.4578 | 2020-04-25 06:30:33 | San Marino | |||
2020-04-25 | San Marino | 513 | 40 | 64 | 409 | 43.9424 | 12.4578 | 2020-04-26 02:30:31 | San Marino | |||
2020-04-26 | San Marino | 513 | 40 | 64 | 409 | 43.9424 | 12.4578 | 2020-04-27 02:30:33 | San Marino | |||
2020-04-27 | San Marino | 538 | 41 | 64 | 433 | 43.9424 | 12.4578 | 2020-04-28 02:30:32 | San Marino | |||
2020-04-28 | San Marino | 538 | 41 | 64 | 433 | 43.9424 | 12.4578 | 2020-04-29 02:32:29 | San Marino | |||
2020-04-29 | San Marino | 553 | 41 | 69 | 443 | 43.9424 | 12.4578 | 2020-04-30 02:32:27 | San Marino | |||
2020-04-30 | San Marino | 563 | 41 | 78 | 444 | 43.9424 | 12.4578 | 2020-05-01 02:32:28 | San Marino | |||
2020-05-01 | San Marino | 569 | 41 | 82 | 446 | 43.9424 | 12.4578 | 2020-05-02 02:32:27 | San Marino | |||
2020-05-02 | San Marino | 580 | 41 | 83 | 456 | 43.9424 | 12.4578 | 2020-05-03 02:32:28 | San Marino | |||
2020-05-03 | San Marino | 580 | 41 | 86 | 453 | 43.9424 | 12.4578 | 2020-05-04 02:32:28 | San Marino | |||
2020-05-04 | San Marino | 582 | 41 | 86 | 455 | 43.9424 | 12.4578 | 2020-05-05 02:32:34 | San Marino | |||
2020-05-05 | San Marino | 582 | 41 | 92 | 449 | 43.9424 | 12.4578 | 2020-05-06 02:32:31 | San Marino | |||
2020-05-06 | San Marino | 589 | 41 | 97 | 451 | 43.9424 | 12.4578 | 2020-05-07 02:32:28 | San Marino | |||
2020-05-07 | San Marino | 608 | 41 | 106 | 461 | 43.9424 | 12.4578 | 2020-05-08 02:32:32 | San Marino | |||
2020-05-08 | San Marino | 632 | 41 | 114 | 477 | 43.9424 | 12.4578 | 2020-05-09 02:32:35 | San Marino | |||
2020-05-09 | San Marino | 632 | 41 | 126 | 465 | 43.9424 | 12.4578 | 2020-05-10 02:32:30 | San Marino | |||
2020-05-10 | San Marino | 632 | 41 | 126 | 465 | 43.9424 | 12.4578 | 2020-05-11 02:32:30 | San Marino | |||
2020-05-11 | San Marino | 637 | 41 | 130 | 466 | 43.9424 | 12.4578 | 2020-05-12 03:32:27 | San Marino | |||
2020-05-12 | San Marino | 647 | 41 | 161 | 445 | 43.9424 | 12.4578 | 2020-05-13 03:32:26 | San Marino | |||
2020-05-13 | San Marino | 647 | 41 | 161 | 445 | 43.9424 | 12.4578 | 2020-05-14 03:32:28 | San Marino | |||
2020-05-14 | San Marino | 647 | 41 | 172 | 434 | 43.9424 | 12.4578 | 2020-05-15 02:33:02 | San Marino | |||
2020-05-15 | San Marino | 647 | 41 | 189 | 417 | 43.9424 | 12.4578 | 2020-05-16 02:32:19 | San Marino | |||
2020-05-16 | San Marino | 652 | 41 | 198 | 413 | 43.9424 | 12.4578 | 2020-05-17 02:32:32 | San Marino | |||
2020-05-17 | San Marino | 652 | 41 | 201 | 410 | 43.9424 | 12.4578 | 2020-05-18 02:32:21 | San Marino | |||
2020-05-18 | San Marino | 668 | 41 | 203 | 424 | 43.9424 | 12.4578 | 2020-05-19 02:32:18 | San Marino | |||
2020-05-19 | San Marino | 668 | 41 | 211 | 416 | 43.9424 | 12.4578 | 2020-05-20 02:32:19 | San Marino | |||
2020-05-20 | San Marino | 668 | 41 | 220 | 407 | 43.9424 | 12.4578 | 2020-05-21 02:32:48 | San Marino | |||
2020-05-21 | San Marino | 670 | 41 | 235 | 394 | 43.9424 | 12.4578 | 2020-05-22 02:36:51 | San Marino | |||
2020-05-22 | San Marino | 672 | 41 | 254 | 377 | 43.9424 | 12.4578 | 2020-05-23 02:32:42 | San Marino | |||
2020-05-23 | San Marino | 672 | 41 | 266 | 365 | 43.9424 | 12.4578 | 2020-05-24 02:32:43 | San Marino | |||
2020-05-24 | San Marino | 672 | 42 | 266 | 364 | 43.9424 | 12.4578 | 2020-05-25 02:32:44 | San Marino | |||
2020-05-25 | San Marino | 672 | 42 | 270 | 360 | 43.9424 | 12.4578 | 2020-05-26 02:32:35 | San Marino | |||
2020-05-26 | San Marino | 672 | 42 | 275 | 355 | 43.9424 | 12.4578 | 2020-05-27 02:32:31 | San Marino | |||
2020-05-27 | San Marino | 672 | 42 | 294 | 336 | 43.9424 | 12.4578 | 2020-05-28 02:32:31 | San Marino | |||
2020-05-28 | San Marino | 672 | 42 | 322 | 308 | 43.9424 | 12.4578 | 2020-05-29 02:32:50 | San Marino | |||
2020-05-29 | San Marino | 687 | 42 | 344 | 301 | 43.9424 | 12.4578 | 2020-05-30 02:32:48 | San Marino | |||
2020-05-30 | San Marino | 687 | 42 | 357 | 288 | 43.9424 | 12.4578 | 2020-05-31 02:32:45 | San Marino | |||
2020-05-31 | San Marino | 687 | 42 | 357 | 288 | 43.9424 | 12.4578 | 2020-06-01 02:32:46 | San Marino | |||
2020-06-01 | San Marino | 687 | 42 | 359 | 286 | 43.9424 | 12.4578 | 2020-06-02 02:33:08 | San Marino | |||
2020-06-02 | San Marino | 687 | 42 | 384 | 261 | 43.9424 | 12.4578 | 2020-06-03 02:33:13 | San Marino | |||
2020-06-03 | San Marino | 687 | 42 | 391 | 254 | 43.9424 | 12.4578 | 2020-06-04 02:33:14 | San Marino | |||
2020-06-04 | San Marino | 687 | 42 | 408 | 237 | 43.9424 | 12.4578 | 2020-06-05 02:33:06 | San Marino | |||
2020-06-05 | San Marino | 695 | 42 | 428 | 225 | 43.9424 | 12.4578 | 2020-06-06 02:33:00 | San Marino |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;