johns_hopkins_csse_daily_reports

⚠️ 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

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

✎ View and edit SQL

This data as json, CSV (advanced)

country_or_region

  • Thailand · 168 ✖

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
242976 242976 2020-07-07 Thailand       3197 58 3074 65 15.870032 100.992541 2020-07-08 05:33:48 Thailand
56567 56567 2020-07-06 Thailand       3195 58 3072 65 15.870032 100.992541 2020-07-07 04:34:00 Thailand
348004 348004 2020-07-05 Thailand       3190 58 3071 61 15.870032 100.992541 2020-07-06 04:33:57 Thailand
319892 319892 2020-07-04 Thailand       3185 58 3066 61 15.870032 100.992541 2020-07-05 04:33:46 Thailand
260326 260326 2020-07-03 Thailand       3180 58 3066 56 15.870032 100.992541 2020-07-04 04:33:51 Thailand
207905 207905 2020-07-02 Thailand       3179 58 3059 62 15.870032 100.992541 2020-07-03 04:33:54 Thailand
164146 164146 2020-07-01 Thailand       3173 58 3059 56 15.870032 100.992541 2020-07-02 04:33:46 Thailand
333944 333944 2020-06-30 Thailand       3171 58 3056 57 15.870032 100.992541 2020-07-01 04:33:52 Thailand
50143 50143 2020-06-29 Thailand       3169 58 3053 58 15.870032 100.992541 2020-06-30 04:33:48 Thailand
60651 60651 2020-06-28 Thailand       3162 58 3053 51 15.870032 100.992541 2020-06-29 04:33:44 Thailand
84102 84102 2020-06-27 Thailand       3162 58 3053 51 15.870032 100.992541 2020-06-28 04:34:04 Thailand
98290 98290 2020-06-26 Thailand       3162 58 3040 64 15.870032 100.992541 2020-06-27 04:33:35 Thailand
371324 371324 2020-06-25 Thailand       3158 58 3038 62 15.870032 100.992541 2020-06-26 04:33:43 Thailand
119643 119643 2020-06-24 Thailand       3158 58 3038 62 15.870032 100.992541 2020-06-25 05:26:54 Thailand
109245 109245 2020-06-23 Thailand       3156 58 3023 75 15.870032 100.992541 2020-06-24 04:33:28 Thailand
183909 183909 2020-06-22 Thailand       3151 58 3022 71 15.870032 100.992541 2020-06-23 04:33:22 Thailand
190746 190746 2020-06-21 Thailand       3148 58 3018 72 15.870032 100.992541 2020-06-22 04:33:20 Thailand
239175 239175 2020-06-20 Thailand       3147 58 3018 71 15.870032 100.992541 2020-06-21 04:33:19 Thailand
90733 90733 2020-06-19 Thailand       3146 58 3008 80 15.870032 100.992541 2020-06-20 04:33:19 Thailand
6588 6588 2020-06-18 Thailand       3141 58 2997 86 15.870032 100.992541 2020-06-19 04:33:17 Thailand
39448 39448 2020-06-17 Thailand       3135 58 2996 81 15.870032 100.992541 2020-06-18 04:33:18 Thailand
235422 235422 2020-06-16 Thailand       3135 58 2993 84 15.870032 100.992541 2020-06-17 04:33:21 Thailand
134945 134945 2020-06-15 Thailand       3135 58 2987 90 15.870032 100.992541 2020-06-16 04:33:09 Thailand
337933 337933 2020-06-14 Thailand       3135 58 2987 90 15.870032 100.992541 2020-06-15 03:33:14 Thailand
225258 225258 2020-06-13 Thailand       3134 58 2987 89 15.870032 100.992541 2020-06-14 03:33:15 Thailand
156634 156634 2020-06-12 Thailand       3129 58 2987 84 15.870032 100.992541 2020-06-13 03:33:14 Thailand
160357 160357 2020-06-11 Thailand       3125 58 2987 80 15.870032 100.992541 2020-06-12 05:09:52 Thailand
152621 152621 2020-06-10 Thailand       3125 58 2981 86 15.870032 100.992541 2020-06-11 03:33:41 Thailand
279099 279099 2020-06-09 Thailand       3121 58 2973 90 15.870032 100.992541 2020-06-10 04:07:00 Thailand
102251 102251 2020-06-08 Thailand       3119 58 2973 88 15.870032 100.992541 2020-06-09 03:33:03 Thailand
148833 148833 2020-06-07 Thailand       3112 58 2972 82 15.870032 100.992541 2020-06-08 03:33:22 Thailand
267787 267787 2020-06-06 Thailand       3104 58 2971 75 15.870032 100.992541 2020-06-07 03:53:30 Thailand
263995 263995 2020-06-05 Thailand       3102 58 2971 73 15.870032 100.992541 2020-06-06 02:33:00 Thailand
173847 173847 2020-06-04 Thailand       3101 58 2968 75 15.870032 100.992541 2020-06-05 02:33:06 Thailand
326896 326896 2020-06-03 Thailand       3084 58 2968 58 15.870032 100.992541 2020-06-04 02:33:14 Thailand
299500 299500 2020-06-02 Thailand       3083 58 2966 59 15.870032 100.992541 2020-06-03 02:33:13 Thailand
197454 197454 2020-06-01 Thailand       3082 57 2965 60 15.870032 100.992541 2020-06-02 02:33:08 Thailand
94257 94257 2020-05-31 Thailand       3081 57 2963 61 15.870032 100.992541 2020-06-01 02:32:46 Thailand
253084 253084 2020-05-30 Thailand       3077 57 2961 59 15.870032 100.992541 2020-05-31 02:32:45 Thailand
211566 211566 2020-05-29 Thailand       3076 57 2945 74 15.870032 100.992541 2020-05-30 02:32:48 Thailand
22740 22740 2020-05-28 Thailand       3065 57 2945 63 15.870032 100.992541 2020-05-29 02:32:50 Thailand
306609 306609 2020-05-27 Thailand       3054 57 2931 66 15.870032 100.992541 2020-05-28 02:32:31 Thailand
46356 46356 2020-05-26 Thailand       3045 57 2929 59 15.870032 100.992541 2020-05-27 02:32:31 Thailand
249559 249559 2020-05-25 Thailand       3042 57 2928 57 15.870032 100.992541 2020-05-26 02:32:35 Thailand
204111 204111 2020-05-24 Thailand       3040 56 2921 63 15.870032 100.992541 2020-05-25 02:32:44 Thailand
131197 131197 2020-05-23 Thailand       3040 56 2916 68 15.870032 100.992541 2020-05-24 02:32:43 Thailand
19222 19222 2020-05-22 Thailand       3037 56 2910 71 15.870032 100.992541 2020-05-23 02:32:42 Thailand
303120 303120 2020-05-21 Thailand       3037 56 2897 84 15.870032 100.992541 2020-05-22 02:36:51 Thailand
115867 115867 2020-05-20 Thailand       3034 56 2888 90 15.870032 100.992541 2020-05-21 02:32:48 Thailand
221515 221515 2020-05-19 Thailand       3033 56 2857 120 15.870032 100.992541 2020-05-20 02:32:19 Thailand
323251 323251 2020-05-18 Thailand       3031 56 2857 118 15.870032 100.992541 2020-05-19 02:32:18 Thailand
26047 26047 2020-05-17 Thailand       3028 56 2856 116 15.870032 100.992541 2020-05-18 02:32:21 Thailand
275158 275158 2020-05-16 Thailand       3025 56 2855 114 15.870032 100.992541 2020-05-17 02:32:32 Thailand
228556 228556 2020-05-15 Thailand       3025 56 2854 115 15.870032 100.992541 2020-05-16 02:32:19 Thailand
170201 170201 2020-05-14 Thailand       3018 56 2850 112 15.870032 100.992541 2020-05-15 02:33:02 Thailand
42799 42799 2020-05-13 Thailand       3017 56 2844 117 15.870032 100.992541 2020-05-14 03:32:28 Thailand
271278 271278 2020-05-12 Thailand       3017 56 2798 163 15.870032 100.992541 2020-05-13 03:32:26 Thailand
289240 289240 2020-05-11 Thailand       3015 56 2796 163 15.870032 100.992541 2020-05-12 03:32:27 Thailand
309843 309843 2020-05-10 Thailand       3009 56 2794 159 15.870032 100.992541 2020-05-11 02:32:30 Thailand
105482 105482 2020-05-09 Thailand       3004 56 2787 161 15.870032 100.992541 2020-05-10 02:32:30 Thailand
112473 112473 2020-05-08 Thailand       3000 55 2784 161 15.870032 100.992541 2020-05-09 02:32:35 Thailand
313066 313066 2020-05-07 Thailand       2992 55 2772 165 15.870032 100.992541 2020-05-08 02:32:32 Thailand
142019 142019 2020-05-06 Thailand       2989 55 2761 173 15.870032 100.992541 2020-05-07 02:32:28 Thailand
357356 357356 2020-05-05 Thailand       2988 54 2747 187 15.870032 100.992541 2020-05-06 02:32:31 Thailand
292441 292441 2020-05-04 Thailand       2987 54 2740 193 15.870032 100.992541 2020-05-05 02:32:34 Thailand
367283 367283 2020-05-03 Thailand       2969 54 2739 176 15.870032 100.992541 2020-05-04 02:32:28 Thailand
341123 341123 2020-05-02 Thailand       2966 54 2732 180 15.870032 100.992541 2020-05-03 02:32:28 Thailand
67276 67276 2020-05-01 Thailand       2960 54 2719 187 15.870032 100.992541 2020-05-02 02:32:27 Thailand
200702 200702 2020-04-30 Thailand       2954 54 2684 216 15.870032 100.992541 2020-05-01 02:32:28 Thailand
256252 256252 2020-04-29 Thailand       2947 54 2665 228 15.870032 100.992541 2020-04-30 02:32:27 Thailand
177009 177009 2020-04-28 Thailand       2938 54 2652 232 15.870032 100.992541 2020-04-29 02:32:29 Thailand
330147 330147 2020-04-27 Thailand       2931 52 2609 270 15.870032 100.992541 2020-04-28 02:30:32 Thailand
138795 138795 2020-04-26 Thailand       2922 51 2594 277 15.870032 100.992541 2020-04-27 02:30:33 Thailand
214764 214764 2020-04-25 Thailand       2907 51 2547 309 15.870032 100.992541 2020-04-26 02:30:31 Thailand
363986 363986 2020-04-24 Thailand       2907 51 2547 309 15.870032 100.992541 2020-04-25 06:30:33 Thailand
231668 231668 2020-04-23 Thailand       2839 50 2430 359 15.870032 100.992541 2020-04-24 03:30:31 Thailand
246150 246150 2020-04-22 Thailand       2826 49 2352 425 15.870032 100.992541 2020-04-22 23:30:32 Thailand
354147 354147 2020-04-21 Thailand       2811 48 2108 655 15.870032 100.992541 2020-04-21 23:30:30 Thailand
344204 344204 2020-04-20 Thailand       2792 47 1999 746 15.870032 100.992541 2020-04-20 23:36:27 Thailand
193816 193816 2020-04-19 Thailand       2765 47 1928 790 15.870032 100.992541 2020-04-19 23:40:41 Thailand
351056 351056 2020-04-18 Thailand       2733 47 1787 899 15.870032 100.992541 2020-04-18 22:32:28 Thailand
73751 73751 2020-04-17 Thailand       2700 47 1689 964 15.870032 100.992541 2020-04-17 23:30:32 Thailand
145161 145161 2020-04-16 Thailand       2672 46 1593 1033 15.870032 100.992541 2020-04-16 23:30:31 Thailand
15658 15658 2020-04-15 Thailand       2643 43 1497 1103 15.870032 100.992541 2020-04-15 22:56:32 Thailand
80317 80317 2020-04-14 Thailand       2613 41 1405 1167 15.870032 100.992541 2020-04-14 23:33:12 Thailand
29173 29173 2020-04-13 Thailand       2579 40 1288 1251 15.870032 100.992541 2020-04-13 23:07:34 Thailand
122628 122628 2020-04-12 Thailand       2551 38 1218 1295 15.870032 100.992541 2020-04-12 23:17:00 Thailand
32209 32209 2020-04-11 Thailand       2518 35 1135 1348 15.870032 100.992541 2020-04-11 22:45:13 Thailand
186847 186847 2020-04-10 Thailand       2473 33 1013 1427 15.870032 100.992541 2020-04-10 22:53:48 Thailand
77075 77075 2020-04-09 Thailand       2423 32 940 1451 15.870032 100.992541 2020-04-09 23:02:19 Thailand
86983 86983 2020-04-08 Thailand       2369 30 888 1451 15.870032 100.992541 2020-04-08 22:51:39 Thailand
2839 2839 2020-04-07 Thailand       2258 27 888 1343 15.870032 100.992541 2020-04-07 23:04:29 Thailand
316093 316093 2020-04-06 Thailand       2220 26 793 1401 15.870032 100.992541 4/6/20 23:21 Thailand
166907 166907 2020-04-05 Thailand       2169 23 793 1353 15.870032 100.992541 2020-04-05 23:06:26 Thailand
180085 180085 2020-04-04 Thailand       2067 20 674 1373 15.870032 100.992541 4/4/20 23:34 Thailand
52766 52766 2020-04-03 Thailand       1978 19 612 1347 15.870032 100.992541 2020-04-03 22:46:20 Thailand
125199 125199 2020-04-02 Thailand       1875 15 505 1355 15.870032 100.992541 4/2/20 23:25 Thailand
12634 12634 2020-04-01 Thailand       1771 12 505 1254 15.870032 100.992541 2020-04-01 21:58:34 Thailand
127634 127634 2020-03-31 Thailand       1651 10 342 1299 15.870032 100.992541 2020-03-31 23:43:43 Thailand
64090 64090 2020-03-30 Thailand       1524 9 229 1286 15.870032 100.992541 3/30/20 22:52 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
);
Powered by Datasette · Query took 2364.008ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette