johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

409 rows where country_or_region = "Thailand" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, longitude, day (date), last_update (date)

country_or_region

  • Thailand · 409 ✖

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
953655 953655 2021-03-05 Thailand       26241 85 25641 515 15.870032 100.992541 2021-03-06 04:23:41 Thailand
901015 901015 2021-03-04 Thailand       26162 85 25562 515 15.870032 100.992541 2021-03-05 05:26:29 Thailand
908740 908740 2021-03-03 Thailand       26108 85 25562 461 15.870032 100.992541 2021-03-04 05:24:24 Thailand
67140 67140 2021-03-02 Thailand       26073 84 25420 569 15.870032 100.992541 2021-03-03 05:23:28 Thailand
1299680 1299680 2021-03-01 Thailand       26031 83 25324 624 15.870032 100.992541 2021-03-02 05:23:30 Thailand
580133 580133 2021-02-28 Thailand       26031 83 25324 624 15.870032 100.992541 2021-03-01 05:23:01 Thailand
680859 680859 2021-02-27 Thailand       25951 83 25128 740 15.870032 100.992541 2021-02-28 05:22:20 Thailand
873887 873887 2021-02-26 Thailand       25809 83 24952 774 15.870032 100.992541 2021-02-27 05:22:28 Thailand
388542 388542 2021-02-25 Thailand       25764 83 24734 947 15.870032 100.992541 2021-02-26 05:22:40 Thailand
454973 454973 2021-02-24 Thailand       25692 83 24542 1067 15.870032 100.992541 2021-02-25 05:24:57 Thailand
1064117 1064117 2021-02-23 Thailand       25692 83 24542 1067 15.870032 100.992541 2021-02-24 05:29:16 Thailand
1241124 1241124 2021-02-22 Thailand       25504 83 24361 1060 15.870032 100.992541 2021-02-23 05:23:41 Thailand
1253062 1253062 2021-02-21 Thailand       25504 83 24361 1060 15.870032 100.992541 2021-02-22 05:24:21 Thailand
600055 600055 2021-02-20 Thailand       25323 83 24129 1111 15.870032 100.992541 2021-02-21 05:24:33 Thailand
443035 443035 2021-02-19 Thailand       25241 83 24129 1029 15.870032 100.992541 2021-02-20 05:22:51 Thailand
1276878 1276878 2021-02-18 Thailand       25111 83 24070 958 15.870032 100.992541 2021-02-19 05:24:16 Thailand
322558 322558 2021-02-17 Thailand       24961 82 23946 933 15.870032 100.992541 2021-02-18 05:22:58 Thailand
105805 105805 2021-02-16 Thailand       24786 82 23563 1141 15.870032 100.992541 2021-02-17 05:23:10 Thailand
1233163 1233163 2021-02-15 Thailand       24714 82 22883 1749 15.870032 100.992541 2021-02-16 05:24:38 Thailand
696361 696361 2021-02-14 Thailand       24571 80 22111 2380 15.870032 100.992541 2021-02-15 05:24:49 Thailand
1314613 1314613 2021-02-13 Thailand       24405 80 21180 3145 15.870032 100.992541 2021-02-14 05:23:43 Thailand
237237 237237 2021-02-12 Thailand       24279 80 20210 3989 15.870032 100.992541 2021-02-13 05:22:12 Thailand
927645 927645 2021-02-11 Thailand       24279 80 20210 3989 15.870032 100.992541 2021-02-12 05:23:29 Thailand
756255 756255 2021-02-10 Thailand       24104 80 19799 4225 15.870032 100.992541 2021-02-11 05:23:55 Thailand
229166 229166 2021-02-09 Thailand       23746 79 18366 5301 15.870032 100.992541 2021-02-10 05:22:41 Thailand
205931 205931 2021-02-08 Thailand       23557 79 17410 6068 15.870032 100.992541 2021-02-09 05:23:30 Thailand
760235 760235 2021-02-07 Thailand       23557 79 17410 6068 15.870032 100.992541 2021-02-08 05:22:39 Thailand
728133 728133 2021-02-06 Thailand       23371 79 16942 6350 15.870032 100.992541 2021-02-07 05:23:00 Thailand
63159 63159 2021-02-05 Thailand       23134 79 16274 6781 15.870032 100.992541 2021-02-06 05:23:55 Thailand
1127138 1127138 2021-02-04 Thailand       22058 79 14798 7181 15.870032 100.992541 2021-02-05 05:22:38 Thailand
447015 447015 2021-02-03 Thailand       21249 79 14001 7169 15.870032 100.992541 2021-02-04 05:22:26 Thailand
1303660 1303660 2021-02-02 Thailand       21249 79 14001 7169 15.870032 100.992541 2021-02-03 05:22:52 Thailand
889650 889650 2021-02-01 Thailand       20454 79 13217 7158 15.870032 100.992541 2021-02-02 05:22:49 Thailand
1020819 1020819 2021-01-31 Thailand       19618 77 12514 7027 15.870032 100.992541 2021-02-01 05:22:53 Thailand
588194 588194 2021-01-30 Thailand       18782 77 11615 7090 15.870032 100.992541 2021-01-31 05:22:42 Thailand
1028733 1028733 2021-01-29 Thailand       17953 77 11505 6371 15.870032 100.992541 2021-01-30 05:22:49 Thailand
270835 270835 2021-01-28 Thailand       16221 76 11287 4858 15.870032 100.992541 2021-01-29 05:22:23 Thailand
964310 964310 2021-01-27 Thailand       15465 76 11054 4335 15.870032 100.992541 2021-01-28 05:22:24 Thailand
1249081 1249081 2021-01-26 Thailand       14646 75 10892 3679 15.870032 100.992541 2021-01-27 05:23:41 Thailand
55236 55236 2021-01-25 Thailand       14646 75 10892 3679 15.870032 100.992541 2021-01-26 05:22:02 Thailand
1237143 1237143 2021-01-24 Thailand       13500 73 10567 2860 15.870032 100.992541 2021-01-25 05:22:16 Thailand
384561 384561 2021-01-23 Thailand       13302 72 10448 2782 15.870032 100.992541 2021-01-24 05:22:35 Thailand
618410 618410 2021-01-22 Thailand       13104 71 10224 2809 15.870032 100.992541 2021-01-23 05:22:03 Thailand
923365 923365 2021-01-21 Thailand       12795 71 10224 2500 15.870032 100.992541 2021-01-22 05:22:10 Thailand
747999 747999 2021-01-20 Thailand       12795 71 9842 2882 15.870032 100.992541 2021-01-21 05:22:01 Thailand
935373 935373 2021-01-19 Thailand       12653 71 9621 2961 15.870032 100.992541 2021-01-20 05:21:54 Thailand
1068096 1068096 2021-01-18 Thailand       12594 70 9356 3168 15.870032 100.992541 2021-01-19 05:22:15 Thailand
90105 90105 2021-01-17 Thailand       12423 70 9206 3147 15.870032 100.992541 2021-01-18 05:22:34 Thailand
708301 708301 2021-01-16 Thailand       12054 70 9015 2969 15.870032 100.992541 2021-01-17 05:22:17 Thailand
893629 893629 2021-01-15 Thailand       11680 70 8906 2704 15.870032 100.992541 2021-01-16 05:22:40 Thailand
241216 241216 2021-01-14 Thailand       11450 69 8288 3093 15.870032 100.992541 2021-01-15 05:22:24 Thailand
1322539 1322539 2021-01-13 Thailand       10991 67 6943 3981 15.870032 100.992541 2021-01-14 05:22:32 Thailand
672834 672834 2021-01-12 Thailand       10991 67 6943 3981 15.870032 100.992541 2021-01-13 05:22:15 Thailand
51257 51257 2021-01-11 Thailand       10834 67 6732 4035 15.870032 100.992541 2021-01-12 05:22:15 Thailand
744021 744021 2021-01-10 Thailand       10547 67 6566 3665 15.870032 100.992541 2021-01-11 05:21:50 Thailand
1165058 1165058 2021-01-09 Thailand       10298 67 6428 4440 15.870032 100.992541 2021-01-10 05:22:12 Thailand
943308 943308 2021-01-08 Thailand       10053 67 5546 4519 15.870032 100.992541 2021-01-09 05:22:18 Thailand
996469 996469 2021-01-07 Thailand       9841 67 5255 4519 15.870032 100.992541 2021-01-08 05:22:42 Thailand
1272899 1272899 2021-01-06 Thailand       9636 67 4521 5048 15.870032 100.992541 2021-01-07 05:22:03 Thailand
361365 361365 2021-01-05 Thailand       9331 66 4418 4847 15.870032 100.992541 2021-01-06 05:22:16 Thailand
156613 156613 2021-01-04 Thailand       8966 65 4397 4504 15.870032 100.992541 2021-01-05 05:21:49 Thailand
1291748 1291748 2021-01-03 Thailand       8439 65 4352 4022 15.870032 100.992541 2021-01-04 05:22:02 Thailand
376648 376648 2021-01-02 Thailand       7694 64 4337 3293 15.870032 100.992541 2021-01-03 05:22:52 Thailand
740043 740043 2021-01-01 Thailand       7379 64 4299 3016 15.870032 100.992541 2021-01-02 05:22:33 Thailand
1206177 1206177 2020-12-31 Thailand       7163 63 4273 2827 15.870032 100.992541 2021-01-01 05:23:07 Thailand
458951 458951 2020-12-30 Thailand       6884 61 4240 2417 15.870032 100.992541 2020-12-31 05:22:49 Thailand
1107477 1107477 2020-12-29 Thailand       6690 61 4212 2417 15.870032 100.992541 2020-12-30 05:22:34 Thailand
7669 7669 2020-12-28 Thailand       6440 61 4184 2200 15.870032 100.992541 2020-12-29 05:22:37 Thailand
172053 172053 2020-12-27 Thailand       6285 60 4180 1920 15.870032 100.992541 2020-12-28 05:22:06 Thailand
1217728 1217728 2020-12-26 Thailand       6141 60 4161 1902 15.870032 100.992541 2020-12-27 05:22:55 Thailand
288970 288970 2020-12-25 Thailand       6020 60 4152 1808 15.870032 100.992541 2020-12-26 05:22:28 Thailand
790690 790690 2020-12-24 Thailand       5910 60 4137 1720 15.870032 100.992541 2020-12-25 05:22:48 Thailand
652368 652368 2020-12-23 Thailand       5829 60 4116 1607 15.870032 100.992541 2020-12-24 05:23:04 Thailand
1153763 1153763 2020-12-22 Thailand       5762 60 4095 1578 15.870032 100.992541 2020-12-23 05:22:03 Thailand
720196 720196 2020-12-21 Thailand       5716 60 4078 1578 15.870032 100.992541 2020-12-22 05:22:33 Thailand
633938 633938 2020-12-20 Thailand       5289 60 4053 794 15.870032 100.992541 2020-12-21 05:27:58 Thailand
629961 629961 2020-12-19 Thailand       4907 60 4041 806 15.870032 100.992541 2020-12-20 05:27:32 Thailand
259730 259730 2020-12-18 Thailand       4331 60 4024 247 15.870032 100.992541 2020-12-19 05:27:52 Thailand
546461 546461 2020-12-17 Thailand       4297 60 4005 232 15.870032 100.992541 2020-12-18 05:28:18 Thailand
550438 550438 2020-12-16 Thailand       4281 60 3989 232 15.870032 100.992541 2020-12-17 05:28:12 Thailand
15604 15604 2020-12-15 Thailand       4261 60 3977 224 15.870032 100.992541 2020-12-16 05:28:04 Thailand
435103 435103 2020-12-14 Thailand       4246 60 3949 237 15.870032 100.992541 2020-12-15 05:26:38 Thailand
349977 349977 2020-12-13 Thailand       4237 60 3940 237 15.870032 100.992541 2020-12-14 05:26:27 Thailand
518942 518942 2020-12-12 Thailand       4209 60 3923 226 15.870032 100.992541 2020-12-13 05:27:20 Thailand
404391 404391 2020-12-11 Thailand       4192 60 3915 217 15.870032 100.992541 2020-12-12 05:26:19 Thailand
224942 224942 2020-12-10 Thailand       4180 60 3903 217 15.870032 100.992541 2020-12-11 05:26:59 Thailand
676811 676811 2020-12-09 Thailand       4169 60 3888 221 15.870032 100.992541 2020-12-10 05:26:19 Thailand
1229112 1229112 2020-12-08 Thailand       4151 60 3880 211 15.870032 100.992541 2020-12-09 05:28:01 Thailand
1052230 1052230 2020-12-07 Thailand       4126 60 3874 192 15.870032 100.992541 2020-12-08 05:27:42 Thailand
992491 992491 2020-12-06 Thailand       4107 60 3868 179 15.870032 100.992541 2020-12-07 05:26:14 Thailand
101826 101826 2020-12-05 Thailand       4086 60 3853 173 15.870032 100.992541 2020-12-06 05:26:18 Thailand
817629 817629 2020-12-04 Thailand       4072 60 3848 164 15.870032 100.992541 2020-12-05 05:27:36 Thailand
450993 450993 2020-12-03 Thailand       4053 60 3839 154 15.870032 100.992541 2020-12-04 05:27:27 Thailand
1245102 1245102 2020-12-02 Thailand       4039 60 3832 144 15.870032 100.992541 2020-12-03 05:28:22 Thailand
809548 809548 2020-12-01 Thailand       4026 60 3822 144 15.870032 100.992541 2020-12-02 05:27:41 Thailand
1264961 1264961 2020-11-30 Thailand       4008 60 3811 137 15.870032 100.992541 2020-12-01 05:26:18 Thailand
233258 233258 2020-11-29 Thailand       3998 60 3803 135 15.870032 100.992541 2020-11-30 05:26:13 Thailand
318495 318495 2020-11-28 Thailand       3977 60 3800 117 15.870032 100.992541 2020-11-29 05:25:55 Thailand
353954 353954 2020-11-27 Thailand       3966 60 3798 108 15.870032 100.992541 2020-11-28 05:25:50 Thailand
607237 607237 2020-11-26 Thailand       3961 60 3790 111 15.870032 100.992541 2020-11-27 05:26:53 Thailand

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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] INTEGER,
   [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]);