johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,068 rows where country_or_region = "Sri Lanka" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-02-08 31
- 2020-01-31 6
- 2020-03-11 3
- 2022-04-13 2
- 2022-05-26 2
- 2020-03-10 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- …
country_or_region 1
- Sri Lanka · 968 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2017034 | 2017034 | 2022-09-20 | Sri Lanka | 670641 | 16748 | 0 | 7.873054 | 80.771797 | 2022-09-21 04:23:22 | Sri Lanka | ||||
3570907 | 3570907 | 2022-09-19 | Sri Lanka | 670617 | 16748 | 0 | 7.873054 | 80.771797 | 2022-09-20 04:22:48 | Sri Lanka | ||||
419646 | 419646 | 2022-09-18 | Sri Lanka | 670596 | 16747 | 0 | 7.873054 | 80.771797 | 2022-09-19 04:21:49 | Sri Lanka | ||||
3373670 | 3373670 | 2022-09-17 | Sri Lanka | 670583 | 16744 | 0 | 7.873054 | 80.771797 | 2022-09-18 04:22:50 | Sri Lanka | ||||
2355778 | 2355778 | 2022-09-16 | Sri Lanka | 670570 | 16742 | 0 | 7.873054 | 80.771797 | 2022-09-17 04:20:19 | Sri Lanka | ||||
3986935 | 3986935 | 2022-09-15 | Sri Lanka | 670519 | 16737 | 0 | 7.873054 | 80.771797 | 2022-09-16 04:21:19 | Sri Lanka | ||||
1889452 | 1889452 | 2022-09-14 | Sri Lanka | 670519 | 16737 | 0 | 7.873054 | 80.771797 | 2022-09-15 04:21:02 | Sri Lanka | ||||
372507 | 372507 | 2022-09-13 | Sri Lanka | 670501 | 16736 | 0 | 7.873054 | 80.771797 | 2022-09-14 04:20:44 | Sri Lanka | ||||
2395110 | 2395110 | 2022-09-12 | Sri Lanka | 670471 | 16731 | 0 | 7.873054 | 80.771797 | 2022-09-13 04:20:57 | Sri Lanka | ||||
3766188 | 3766188 | 2022-09-11 | Sri Lanka | 670444 | 16728 | 0 | 7.873054 | 80.771797 | 2022-09-12 04:20:58 | Sri Lanka | ||||
3824763 | 3824763 | 2022-09-10 | Sri Lanka | 670408 | 16727 | 0 | 7.873054 | 80.771797 | 2022-09-11 04:20:50 | Sri Lanka | ||||
963220 | 963220 | 2022-09-09 | Sri Lanka | 670376 | 16725 | 0 | 7.873054 | 80.771797 | 2022-09-10 04:21:10 | Sri Lanka | ||||
253622 | 253622 | 2022-09-08 | Sri Lanka | 670341 | 16724 | 0 | 7.873054 | 80.771797 | 2022-09-09 04:21:11 | Sri Lanka | ||||
3745420 | 3745420 | 2022-09-07 | Sri Lanka | 670297 | 16719 | 0 | 7.873054 | 80.771797 | 2022-09-08 04:21:02 | Sri Lanka | ||||
115060 | 115060 | 2022-09-06 | Sri Lanka | 670251 | 16716 | 0 | 7.873054 | 80.771797 | 2022-09-07 04:20:59 | Sri Lanka | ||||
2634032 | 2634032 | 2022-09-05 | Sri Lanka | 670218 | 16712 | 0 | 7.873054 | 80.771797 | 2022-09-06 04:21:02 | Sri Lanka | ||||
2987596 | 2987596 | 2022-09-04 | Sri Lanka | 670176 | 16711 | 0 | 7.873054 | 80.771797 | 2022-09-05 04:21:01 | Sri Lanka | ||||
2713281 | 2713281 | 2022-09-03 | Sri Lanka | 670127 | 16707 | 0 | 7.873054 | 80.771797 | 2022-09-04 04:21:22 | Sri Lanka | ||||
1393986 | 1393986 | 2022-09-02 | Sri Lanka | 670077 | 16703 | 0 | 7.873054 | 80.771797 | 2022-09-03 04:21:04 | Sri Lanka | ||||
3547815 | 3547815 | 2022-09-01 | Sri Lanka | 670018 | 16699 | 0 | 7.873054 | 80.771797 | 2022-09-02 04:21:07 | Sri Lanka | ||||
2343735 | 2343735 | 2022-08-31 | Sri Lanka | 669957 | 16698 | 0 | 7.873054 | 80.771797 | 2022-09-01 04:21:03 | Sri Lanka | ||||
3774215 | 3774215 | 2022-08-30 | Sri Lanka | 669893 | 16695 | 0 | 7.873054 | 80.771797 | 2022-08-31 04:20:57 | Sri Lanka | ||||
1680811 | 1680811 | 2022-08-29 | Sri Lanka | 669819 | 16692 | 0 | 7.873054 | 80.771797 | 2022-08-30 04:21:03 | Sri Lanka | ||||
1877295 | 1877295 | 2022-08-28 | Sri Lanka | 669749 | 16687 | 0 | 7.873054 | 80.771797 | 2022-08-29 04:21:06 | Sri Lanka | ||||
2096422 | 2096422 | 2022-08-27 | Sri Lanka | 669693 | 16685 | 0 | 7.873054 | 80.771797 | 2022-08-28 04:21:02 | Sri Lanka | ||||
1532237 | 1532237 | 2022-08-26 | Sri Lanka | 669639 | 16679 | 0 | 7.873054 | 80.771797 | 2022-08-27 04:20:57 | Sri Lanka | ||||
2829124 | 2829124 | 2022-08-25 | Sri Lanka | 669581 | 16675 | 0 | 7.873054 | 80.771797 | 2022-08-26 04:21:02 | Sri Lanka | ||||
2323657 | 2323657 | 2022-08-24 | Sri Lanka | 669467 | 16669 | 0 | 7.873054 | 80.771797 | 2022-08-25 04:21:13 | Sri Lanka | ||||
1251066 | 1251066 | 2022-08-23 | Sri Lanka | 669362 | 16664 | 0 | 7.873054 | 80.771797 | 2022-08-24 04:20:46 | Sri Lanka | ||||
2853170 | 2853170 | 2022-08-22 | Sri Lanka | 669136 | 16660 | 0 | 7.873054 | 80.771797 | 2022-08-23 04:20:56 | Sri Lanka | ||||
2403142 | 2403142 | 2022-08-21 | Sri Lanka | 669033 | 16654 | 0 | 7.873054 | 80.771797 | 2022-08-22 04:20:38 | Sri Lanka | ||||
3798220 | 3798220 | 2022-08-20 | Sri Lanka | 668827 | 16646 | 0 | 7.873054 | 80.771797 | 2022-08-21 04:20:44 | Sri Lanka | ||||
2363806 | 2363806 | 2022-08-19 | Sri Lanka | 668827 | 16646 | 0 | 7.873054 | 80.771797 | 2022-08-20 04:21:01 | Sri Lanka | ||||
1161477 | 1161477 | 2022-08-18 | Sri Lanka | 668663 | 16640 | 0 | 7.873054 | 80.771797 | 2022-08-19 04:20:54 | Sri Lanka | ||||
3950801 | 3950801 | 2022-08-17 | Sri Lanka | 668497 | 16635 | 0 | 7.873054 | 80.771797 | 2022-08-18 04:21:11 | Sri Lanka | ||||
991303 | 991303 | 2022-08-16 | Sri Lanka | 668336 | 16630 | 0 | 7.873054 | 80.771797 | 2022-08-17 04:20:59 | Sri Lanka | ||||
2494342 | 2494342 | 2022-08-15 | Sri Lanka | 668141 | 16624 | 0 | 7.873054 | 80.771797 | 2022-08-16 04:20:58 | Sri Lanka | ||||
3647892 | 3647892 | 2022-08-14 | Sri Lanka | 668012 | 16621 | 0 | 7.873054 | 80.771797 | 2022-08-15 04:20:59 | Sri Lanka | ||||
1968898 | 1968898 | 2022-08-13 | Sri Lanka | 667916 | 16619 | 0 | 7.873054 | 80.771797 | 2022-08-14 04:20:55 | Sri Lanka | ||||
2888707 | 2888707 | 2022-08-12 | Sri Lanka | 667735 | 16614 | 0 | 7.873054 | 80.771797 | 2022-08-13 04:20:52 | Sri Lanka | ||||
3908312 | 3908312 | 2022-08-11 | Sri Lanka | 667573 | 16605 | 0 | 7.873054 | 80.771797 | 2022-08-12 04:20:54 | Sri Lanka | ||||
1346629 | 1346629 | 2022-08-10 | Sri Lanka | 667385 | 16603 | 0 | 7.873054 | 80.771797 | 2022-08-11 04:20:49 | Sri Lanka | ||||
1086384 | 1086384 | 2022-08-09 | Sri Lanka | 667158 | 16594 | 0 | 7.873054 | 80.771797 | 2022-08-10 04:20:57 | Sri Lanka | ||||
3543799 | 3543799 | 2022-08-08 | Sri Lanka | 666944 | 16588 | 0 | 7.873054 | 80.771797 | 2022-08-09 04:20:34 | Sri Lanka | ||||
1070202 | 1070202 | 2022-08-07 | Sri Lanka | 666764 | 16586 | 0 | 7.873054 | 80.771797 | 2022-08-08 04:21:08 | Sri Lanka | ||||
1940790 | 1940790 | 2022-08-06 | Sri Lanka | 666580 | 16583 | 0 | 7.873054 | 80.771797 | 2022-08-07 04:20:54 | Sri Lanka | ||||
880589 | 880589 | 2022-08-05 | Sri Lanka | 666413 | 16578 | 0 | 7.873054 | 80.771797 | 2022-08-06 04:20:56 | Sri Lanka | ||||
2009000 | 2009000 | 2022-08-04 | Sri Lanka | 666232 | 16574 | 0 | 7.873054 | 80.771797 | 2022-08-05 04:20:52 | Sri Lanka | ||||
1098427 | 1098427 | 2022-08-03 | Sri Lanka | 666086 | 16574 | 0 | 7.873054 | 80.771797 | 2022-08-04 04:20:58 | Sri Lanka | ||||
1405352 | 1405352 | 2022-08-02 | Sri Lanka | 665964 | 16566 | 0 | 7.873054 | 80.771797 | 2022-08-03 04:20:59 | Sri Lanka | ||||
3617390 | 3617390 | 2022-08-01 | Sri Lanka | 665847 | 16559 | 0 | 7.873054 | 80.771797 | 2022-08-02 04:20:53 | Sri Lanka | ||||
3871870 | 3871870 | 2022-07-31 | Sri Lanka | 665739 | 16556 | 0 | 7.873054 | 80.771797 | 2022-08-01 04:21:03 | Sri Lanka | ||||
674624 | 674624 | 2022-07-30 | Sri Lanka | 665626 | 16556 | 0 | 7.873054 | 80.771797 | 2022-07-31 04:21:02 | Sri Lanka | ||||
1783823 | 1783823 | 2022-07-29 | Sri Lanka | 665543 | 16553 | 0 | 7.873054 | 80.771797 | 2022-07-30 04:20:42 | Sri Lanka | ||||
1066186 | 1066186 | 2022-07-28 | Sri Lanka | 665379 | 16548 | 0 | 7.873054 | 80.771797 | 2022-07-29 04:20:45 | Sri Lanka | ||||
2335705 | 2335705 | 2022-07-27 | Sri Lanka | 665094 | 16544 | 0 | 7.873054 | 80.771797 | 2022-07-28 04:20:56 | Sri Lanka | ||||
1487895 | 1487895 | 2022-07-26 | Sri Lanka | 665094 | 16544 | 0 | 7.873054 | 80.771797 | 2022-07-27 04:21:04 | Sri Lanka | ||||
2594341 | 2594341 | 2022-07-25 | Sri Lanka | 664975 | 16539 | 0 | 7.873054 | 80.771797 | 2022-07-26 04:20:58 | Sri Lanka | ||||
896456 | 896456 | 2022-07-24 | Sri Lanka | 664900 | 16537 | 0 | 7.873054 | 80.771797 | 2022-07-25 04:20:51 | Sri Lanka | ||||
91450 | 91450 | 2022-07-23 | Sri Lanka | 664844 | 16537 | 0 | 7.873054 | 80.771797 | 2022-07-24 04:20:47 | Sri Lanka | ||||
900472 | 900472 | 2022-07-22 | Sri Lanka | 664772 | 16536 | 0 | 7.873054 | 80.771797 | 2022-07-23 04:20:53 | Sri Lanka | ||||
670608 | 670608 | 2022-07-21 | Sri Lanka | 664704 | 16535 | 0 | 7.873054 | 80.771797 | 2022-07-22 04:21:15 | Sri Lanka | ||||
1608571 | 1608571 | 2022-07-20 | Sri Lanka | 664647 | 16533 | 0 | 7.873054 | 80.771797 | 2022-07-21 04:21:10 | Sri Lanka | ||||
959204 | 959204 | 2022-07-19 | Sri Lanka | 664572 | 16531 | 0 | 7.873054 | 80.771797 | 2022-07-20 04:20:59 | Sri Lanka | ||||
3210591 | 3210591 | 2022-07-18 | Sri Lanka | 664510 | 16528 | 0 | 7.873054 | 80.771797 | 2022-07-19 04:20:58 | Sri Lanka | ||||
3405766 | 3405766 | 2022-07-17 | Sri Lanka | 664448 | 16528 | 0 | 7.873054 | 80.771797 | 2022-07-18 04:20:59 | Sri Lanka | ||||
2151966 | 2151966 | 2022-07-16 | Sri Lanka | 664414 | 16528 | 0 | 7.873054 | 80.771797 | 2022-07-17 04:21:15 | Sri Lanka | ||||
2419199 | 2419199 | 2022-07-15 | Sri Lanka | 664389 | 16527 | 0 | 7.873054 | 80.771797 | 2022-07-16 04:21:05 | Sri Lanka | ||||
3429274 | 3429274 | 2022-07-14 | Sri Lanka | 664364 | 16526 | 0 | 7.873054 | 80.771797 | 2022-07-15 04:20:53 | Sri Lanka | ||||
3109794 | 3109794 | 2022-07-13 | Sri Lanka | 664345 | 16526 | 0 | 7.873054 | 80.771797 | 2022-07-14 04:20:57 | Sri Lanka | ||||
630217 | 630217 | 2022-07-12 | Sri Lanka | 664315 | 16526 | 0 | 7.873054 | 80.771797 | 2022-07-13 04:20:58 | Sri Lanka | ||||
1211861 | 1211861 | 2022-07-11 | Sri Lanka | 664292 | 16526 | 0 | 7.873054 | 80.771797 | 2022-07-12 04:20:51 | Sri Lanka | ||||
2789343 | 2789343 | 2022-07-10 | Sri Lanka | 664273 | 16525 | 0 | 7.873054 | 80.771797 | 2022-07-11 04:20:46 | Sri Lanka | ||||
142296 | 142296 | 2022-07-09 | Sri Lanka | 664256 | 16525 | 0 | 7.873054 | 80.771797 | 2022-07-10 04:20:54 | Sri Lanka | ||||
1417396 | 1417396 | 2022-07-08 | Sri Lanka | 664235 | 16525 | 0 | 7.873054 | 80.771797 | 2022-07-09 04:20:59 | Sri Lanka | ||||
2741321 | 2741321 | 2022-07-07 | Sri Lanka | 664217 | 16525 | 0 | 7.873054 | 80.771797 | 2022-07-08 04:20:56 | Sri Lanka | ||||
1200116 | 1200116 | 2022-07-06 | Sri Lanka | 664197 | 16524 | 0 | 7.873054 | 80.771797 | 2022-07-07 04:20:55 | Sri Lanka | ||||
3966859 | 3966859 | 2022-07-05 | Sri Lanka | 664194 | 16523 | 0 | 7.873054 | 80.771797 | 2022-07-06 04:20:58 | Sri Lanka | ||||
3078370 | 3078370 | 2022-07-04 | Sri Lanka | 664181 | 16522 | 0 | 7.873054 | 80.771797 | 2022-07-05 04:20:45 | Sri Lanka | ||||
1767652 | 1767652 | 2022-07-03 | Sri Lanka | 664167 | 16522 | 0 | 7.873054 | 80.771797 | 2022-07-04 04:20:54 | Sri Lanka | ||||
3365638 | 3365638 | 2022-07-02 | Sri Lanka | 664150 | 16521 | 0 | 7.873054 | 80.771797 | 2022-07-03 04:20:59 | Sri Lanka | ||||
593967 | 593967 | 2022-07-01 | Sri Lanka | 664138 | 16521 | 0 | 7.873054 | 80.771797 | 2022-07-02 04:21:16 | Sri Lanka | ||||
3940368 | 3940368 | 2022-06-30 | Sri Lanka | 664123 | 16521 | 0 | 7.873054 | 80.771797 | 2022-07-01 04:21:10 | Sri Lanka | ||||
2490326 | 2490326 | 2022-06-29 | Sri Lanka | 664110 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-30 04:21:01 | Sri Lanka | ||||
2239708 | 2239708 | 2022-06-28 | Sri Lanka | 664098 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-29 04:20:59 | Sri Lanka | ||||
2147950 | 2147950 | 2022-06-27 | Sri Lanka | 664090 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-28 04:20:58 | Sri Lanka | ||||
475751 | 475751 | 2022-06-26 | Sri Lanka | 664080 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-27 04:21:00 | Sri Lanka | ||||
939126 | 939126 | 2022-06-25 | Sri Lanka | 664065 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-26 04:21:02 | Sri Lanka | ||||
3346946 | 3346946 | 2022-06-24 | Sri Lanka | 664052 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-25 04:20:57 | Sri Lanka | ||||
1648687 | 1648687 | 2022-06-23 | Sri Lanka | 664047 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-24 04:20:58 | Sri Lanka | ||||
2187922 | 2187922 | 2022-06-22 | Sri Lanka | 664036 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-23 04:20:55 | Sri Lanka | ||||
166353 | 166353 | 2022-06-21 | Sri Lanka | 664018 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-22 04:20:54 | Sri Lanka | ||||
1763636 | 1763636 | 2022-06-20 | Sri Lanka | 664010 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-21 04:20:56 | Sri Lanka | ||||
3269822 | 3269822 | 2022-06-19 | Sri Lanka | 663989 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-20 04:21:01 | Sri Lanka | ||||
3397734 | 3397734 | 2022-06-18 | Sri Lanka | 663984 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-19 04:20:51 | Sri Lanka | ||||
2311611 | 2311611 | 2022-06-17 | Sri Lanka | 663984 | 16520 | 0 | 7.873054 | 80.771797 | 2022-06-18 04:21:10 | Sri Lanka | ||||
559115 | 559115 | 2022-06-16 | Sri Lanka | 663975 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-17 04:20:56 | Sri Lanka | ||||
3982917 | 3982917 | 2022-06-15 | Sri Lanka | 663965 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-16 04:20:55 | Sri Lanka | ||||
947158 | 947158 | 2022-06-14 | Sri Lanka | 663965 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-15 04:20:54 | Sri Lanka | ||||
2979566 | 2979566 | 2022-06-13 | Sri Lanka | 663960 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-14 04:20:52 | Sri Lanka |
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]);