johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Novosibirsk Oblast" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016961 | 2016961 | 2022-09-20 | Russia | Novosibirsk Oblast | 287702 | 5712 | 0 | 54.9720169 | 79.4813924 | 2022-09-21 04:23:22 | Novosibirsk Oblast, Russia | |||
3570834 | 3570834 | 2022-09-19 | Russia | Novosibirsk Oblast | 286776 | 5712 | 0 | 54.9720169 | 79.4813924 | 2022-09-20 04:22:48 | Novosibirsk Oblast, Russia | |||
419573 | 419573 | 2022-09-18 | Russia | Novosibirsk Oblast | 285891 | 5711 | 0 | 54.9720169 | 79.4813924 | 2022-09-19 04:21:49 | Novosibirsk Oblast, Russia | |||
3373597 | 3373597 | 2022-09-17 | Russia | Novosibirsk Oblast | 284995 | 5711 | 0 | 54.9720169 | 79.4813924 | 2022-09-18 04:22:50 | Novosibirsk Oblast, Russia | |||
2355705 | 2355705 | 2022-09-16 | Russia | Novosibirsk Oblast | 284073 | 5711 | 0 | 54.9720169 | 79.4813924 | 2022-09-17 04:20:19 | Novosibirsk Oblast, Russia | |||
3986862 | 3986862 | 2022-09-15 | Russia | Novosibirsk Oblast | 283125 | 5710 | 0 | 54.9720169 | 79.4813924 | 2022-09-16 04:21:19 | Novosibirsk Oblast, Russia | |||
1889379 | 1889379 | 2022-09-14 | Russia | Novosibirsk Oblast | 282192 | 5710 | 0 | 54.9720169 | 79.4813924 | 2022-09-15 04:21:02 | Novosibirsk Oblast, Russia | |||
372434 | 372434 | 2022-09-13 | Russia | Novosibirsk Oblast | 281241 | 5710 | 0 | 54.9720169 | 79.4813924 | 2022-09-14 04:20:44 | Novosibirsk Oblast, Russia | |||
2395037 | 2395037 | 2022-09-12 | Russia | Novosibirsk Oblast | 280256 | 5709 | 0 | 54.9720169 | 79.4813924 | 2022-09-13 04:20:57 | Novosibirsk Oblast, Russia | |||
3766115 | 3766115 | 2022-09-11 | Russia | Novosibirsk Oblast | 279332 | 5709 | 0 | 54.9720169 | 79.4813924 | 2022-09-12 04:20:58 | Novosibirsk Oblast, Russia | |||
3824690 | 3824690 | 2022-09-10 | Russia | Novosibirsk Oblast | 278401 | 5709 | 0 | 54.9720169 | 79.4813924 | 2022-09-11 04:20:50 | Novosibirsk Oblast, Russia | |||
963147 | 963147 | 2022-09-09 | Russia | Novosibirsk Oblast | 277475 | 5709 | 0 | 54.9720169 | 79.4813924 | 2022-09-10 04:21:10 | Novosibirsk Oblast, Russia | |||
253549 | 253549 | 2022-09-08 | Russia | Novosibirsk Oblast | 276574 | 5707 | 0 | 54.9720169 | 79.4813924 | 2022-09-09 04:21:11 | Novosibirsk Oblast, Russia | |||
3745347 | 3745347 | 2022-09-07 | Russia | Novosibirsk Oblast | 275732 | 5706 | 0 | 54.9720169 | 79.4813924 | 2022-09-08 04:21:02 | Novosibirsk Oblast, Russia | |||
114987 | 114987 | 2022-09-06 | Russia | Novosibirsk Oblast | 274943 | 5706 | 0 | 54.9720169 | 79.4813924 | 2022-09-07 04:20:59 | Novosibirsk Oblast, Russia | |||
2633959 | 2633959 | 2022-09-05 | Russia | Novosibirsk Oblast | 274212 | 5706 | 0 | 54.9720169 | 79.4813924 | 2022-09-06 04:21:02 | Novosibirsk Oblast, Russia | |||
2987523 | 2987523 | 2022-09-04 | Russia | Novosibirsk Oblast | 273493 | 5705 | 0 | 54.9720169 | 79.4813924 | 2022-09-05 04:21:01 | Novosibirsk Oblast, Russia | |||
2713208 | 2713208 | 2022-09-03 | Russia | Novosibirsk Oblast | 272760 | 5705 | 0 | 54.9720169 | 79.4813924 | 2022-09-04 04:21:22 | Novosibirsk Oblast, Russia | |||
1393913 | 1393913 | 2022-09-02 | Russia | Novosibirsk Oblast | 272035 | 5705 | 0 | 54.9720169 | 79.4813924 | 2022-09-03 04:21:04 | Novosibirsk Oblast, Russia | |||
3547742 | 3547742 | 2022-09-01 | Russia | Novosibirsk Oblast | 271336 | 5704 | 0 | 54.9720169 | 79.4813924 | 2022-09-02 04:21:07 | Novosibirsk Oblast, Russia | |||
2343662 | 2343662 | 2022-08-31 | Russia | Novosibirsk Oblast | 270665 | 5704 | 0 | 54.9720169 | 79.4813924 | 2022-09-01 04:21:03 | Novosibirsk Oblast, Russia | |||
3774142 | 3774142 | 2022-08-30 | Russia | Novosibirsk Oblast | 270071 | 5704 | 0 | 54.9720169 | 79.4813924 | 2022-08-31 04:20:57 | Novosibirsk Oblast, Russia | |||
1680738 | 1680738 | 2022-08-29 | Russia | Novosibirsk Oblast | 269513 | 5704 | 0 | 54.9720169 | 79.4813924 | 2022-08-30 04:21:03 | Novosibirsk Oblast, Russia | |||
1877222 | 1877222 | 2022-08-28 | Russia | Novosibirsk Oblast | 268980 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-29 04:21:06 | Novosibirsk Oblast, Russia | |||
2096349 | 2096349 | 2022-08-27 | Russia | Novosibirsk Oblast | 268454 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-28 04:21:02 | Novosibirsk Oblast, Russia | |||
1532164 | 1532164 | 2022-08-26 | Russia | Novosibirsk Oblast | 267917 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-27 04:20:57 | Novosibirsk Oblast, Russia | |||
2829051 | 2829051 | 2022-08-25 | Russia | Novosibirsk Oblast | 267408 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-26 04:21:02 | Novosibirsk Oblast, Russia | |||
2323584 | 2323584 | 2022-08-24 | Russia | Novosibirsk Oblast | 266917 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-25 04:21:13 | Novosibirsk Oblast, Russia | |||
1250993 | 1250993 | 2022-08-23 | Russia | Novosibirsk Oblast | 266452 | 5703 | 0 | 54.9720169 | 79.4813924 | 2022-08-24 04:20:46 | Novosibirsk Oblast, Russia | |||
2853097 | 2853097 | 2022-08-22 | Russia | Novosibirsk Oblast | 266013 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-23 04:20:56 | Novosibirsk Oblast, Russia | |||
2403069 | 2403069 | 2022-08-21 | Russia | Novosibirsk Oblast | 265605 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-22 04:20:38 | Novosibirsk Oblast, Russia | |||
3798147 | 3798147 | 2022-08-20 | Russia | Novosibirsk Oblast | 265215 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-21 04:20:44 | Novosibirsk Oblast, Russia | |||
2363733 | 2363733 | 2022-08-19 | Russia | Novosibirsk Oblast | 264873 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-20 04:21:01 | Novosibirsk Oblast, Russia | |||
1161404 | 1161404 | 2022-08-18 | Russia | Novosibirsk Oblast | 264566 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-19 04:20:54 | Novosibirsk Oblast, Russia | |||
3950728 | 3950728 | 2022-08-17 | Russia | Novosibirsk Oblast | 264285 | 5702 | 0 | 54.9720169 | 79.4813924 | 2022-08-18 04:21:11 | Novosibirsk Oblast, Russia | |||
991230 | 991230 | 2022-08-16 | Russia | Novosibirsk Oblast | 264036 | 5701 | 0 | 54.9720169 | 79.4813924 | 2022-08-17 04:20:59 | Novosibirsk Oblast, Russia | |||
2494269 | 2494269 | 2022-08-15 | Russia | Novosibirsk Oblast | 263844 | 5701 | 0 | 54.9720169 | 79.4813924 | 2022-08-16 04:20:58 | Novosibirsk Oblast, Russia | |||
3647819 | 3647819 | 2022-08-14 | Russia | Novosibirsk Oblast | 263669 | 5701 | 0 | 54.9720169 | 79.4813924 | 2022-08-15 04:20:59 | Novosibirsk Oblast, Russia | |||
1968825 | 1968825 | 2022-08-13 | Russia | Novosibirsk Oblast | 263489 | 5701 | 0 | 54.9720169 | 79.4813924 | 2022-08-14 04:20:55 | Novosibirsk Oblast, Russia | |||
2888634 | 2888634 | 2022-08-12 | Russia | Novosibirsk Oblast | 263313 | 5700 | 0 | 54.9720169 | 79.4813924 | 2022-08-13 04:20:52 | Novosibirsk Oblast, Russia | |||
3908239 | 3908239 | 2022-08-11 | Russia | Novosibirsk Oblast | 263132 | 5700 | 0 | 54.9720169 | 79.4813924 | 2022-08-12 04:20:54 | Novosibirsk Oblast, Russia | |||
1346556 | 1346556 | 2022-08-10 | Russia | Novosibirsk Oblast | 262958 | 5700 | 0 | 54.9720169 | 79.4813924 | 2022-08-11 04:20:49 | Novosibirsk Oblast, Russia | |||
1086311 | 1086311 | 2022-08-09 | Russia | Novosibirsk Oblast | 262789 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-10 04:20:57 | Novosibirsk Oblast, Russia | |||
3543726 | 3543726 | 2022-08-08 | Russia | Novosibirsk Oblast | 262645 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-09 04:20:34 | Novosibirsk Oblast, Russia | |||
1070129 | 1070129 | 2022-08-07 | Russia | Novosibirsk Oblast | 262510 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-08 04:21:08 | Novosibirsk Oblast, Russia | |||
1940717 | 1940717 | 2022-08-06 | Russia | Novosibirsk Oblast | 262370 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-07 04:20:54 | Novosibirsk Oblast, Russia | |||
880516 | 880516 | 2022-08-05 | Russia | Novosibirsk Oblast | 262237 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-06 04:20:56 | Novosibirsk Oblast, Russia | |||
2008927 | 2008927 | 2022-08-04 | Russia | Novosibirsk Oblast | 262115 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-05 04:20:52 | Novosibirsk Oblast, Russia | |||
1098354 | 1098354 | 2022-08-03 | Russia | Novosibirsk Oblast | 262010 | 5699 | 0 | 54.9720169 | 79.4813924 | 2022-08-04 04:20:58 | Novosibirsk Oblast, Russia | |||
1405279 | 1405279 | 2022-08-02 | Russia | Novosibirsk Oblast | 261921 | 5698 | 0 | 54.9720169 | 79.4813924 | 2022-08-03 04:20:59 | Novosibirsk Oblast, Russia | |||
3617317 | 3617317 | 2022-08-01 | Russia | Novosibirsk Oblast | 261839 | 5698 | 0 | 54.9720169 | 79.4813924 | 2022-08-02 04:20:53 | Novosibirsk Oblast, Russia | |||
3871797 | 3871797 | 2022-07-31 | Russia | Novosibirsk Oblast | 261768 | 5698 | 0 | 54.9720169 | 79.4813924 | 2022-08-01 04:21:03 | Novosibirsk Oblast, Russia | |||
674551 | 674551 | 2022-07-30 | Russia | Novosibirsk Oblast | 261699 | 5697 | 0 | 54.9720169 | 79.4813924 | 2022-07-31 04:21:02 | Novosibirsk Oblast, Russia | |||
1783750 | 1783750 | 2022-07-29 | Russia | Novosibirsk Oblast | 261633 | 5697 | 0 | 54.9720169 | 79.4813924 | 2022-07-30 04:20:42 | Novosibirsk Oblast, Russia | |||
1066113 | 1066113 | 2022-07-28 | Russia | Novosibirsk Oblast | 261572 | 5697 | 0 | 54.9720169 | 79.4813924 | 2022-07-29 04:20:45 | Novosibirsk Oblast, Russia | |||
2335632 | 2335632 | 2022-07-27 | Russia | Novosibirsk Oblast | 261508 | 5697 | 0 | 54.9720169 | 79.4813924 | 2022-07-28 04:20:56 | Novosibirsk Oblast, Russia | |||
1487822 | 1487822 | 2022-07-26 | Russia | Novosibirsk Oblast | 261449 | 5697 | 0 | 54.9720169 | 79.4813924 | 2022-07-27 04:21:04 | Novosibirsk Oblast, Russia | |||
2594268 | 2594268 | 2022-07-25 | Russia | Novosibirsk Oblast | 261396 | 5696 | 0 | 54.9720169 | 79.4813924 | 2022-07-26 04:20:58 | Novosibirsk Oblast, Russia | |||
896383 | 896383 | 2022-07-24 | Russia | Novosibirsk Oblast | 261346 | 5696 | 0 | 54.9720169 | 79.4813924 | 2022-07-25 04:20:51 | Novosibirsk Oblast, Russia | |||
91377 | 91377 | 2022-07-23 | Russia | Novosibirsk Oblast | 261294 | 5696 | 0 | 54.9720169 | 79.4813924 | 2022-07-24 04:20:47 | Novosibirsk Oblast, Russia | |||
900399 | 900399 | 2022-07-22 | Russia | Novosibirsk Oblast | 261239 | 5696 | 0 | 54.9720169 | 79.4813924 | 2022-07-23 04:20:53 | Novosibirsk Oblast, Russia | |||
670535 | 670535 | 2022-07-21 | Russia | Novosibirsk Oblast | 261185 | 5695 | 0 | 54.9720169 | 79.4813924 | 2022-07-22 04:21:15 | Novosibirsk Oblast, Russia | |||
1608498 | 1608498 | 2022-07-20 | Russia | Novosibirsk Oblast | 261129 | 5695 | 0 | 54.9720169 | 79.4813924 | 2022-07-21 04:21:10 | Novosibirsk Oblast, Russia | |||
959131 | 959131 | 2022-07-19 | Russia | Novosibirsk Oblast | 261076 | 5695 | 0 | 54.9720169 | 79.4813924 | 2022-07-20 04:20:59 | Novosibirsk Oblast, Russia | |||
3210518 | 3210518 | 2022-07-18 | Russia | Novosibirsk Oblast | 261028 | 5694 | 0 | 54.9720169 | 79.4813924 | 2022-07-19 04:20:58 | Novosibirsk Oblast, Russia | |||
3405693 | 3405693 | 2022-07-17 | Russia | Novosibirsk Oblast | 260984 | 5694 | 0 | 54.9720169 | 79.4813924 | 2022-07-18 04:20:59 | Novosibirsk Oblast, Russia | |||
2151893 | 2151893 | 2022-07-16 | Russia | Novosibirsk Oblast | 260937 | 5693 | 0 | 54.9720169 | 79.4813924 | 2022-07-17 04:21:15 | Novosibirsk Oblast, Russia | |||
2419126 | 2419126 | 2022-07-15 | Russia | Novosibirsk Oblast | 260886 | 5693 | 0 | 54.9720169 | 79.4813924 | 2022-07-16 04:21:05 | Novosibirsk Oblast, Russia | |||
3429201 | 3429201 | 2022-07-14 | Russia | Novosibirsk Oblast | 260836 | 5692 | 0 | 54.9720169 | 79.4813924 | 2022-07-15 04:20:53 | Novosibirsk Oblast, Russia | |||
3109721 | 3109721 | 2022-07-13 | Russia | Novosibirsk Oblast | 260789 | 5692 | 0 | 54.9720169 | 79.4813924 | 2022-07-14 04:20:57 | Novosibirsk Oblast, Russia | |||
630144 | 630144 | 2022-07-12 | Russia | Novosibirsk Oblast | 260740 | 5691 | 0 | 54.9720169 | 79.4813924 | 2022-07-13 04:20:58 | Novosibirsk Oblast, Russia | |||
1211788 | 1211788 | 2022-07-11 | Russia | Novosibirsk Oblast | 260694 | 5691 | 0 | 54.9720169 | 79.4813924 | 2022-07-12 04:20:51 | Novosibirsk Oblast, Russia | |||
2789270 | 2789270 | 2022-07-10 | Russia | Novosibirsk Oblast | 260651 | 5691 | 0 | 54.9720169 | 79.4813924 | 2022-07-11 04:20:46 | Novosibirsk Oblast, Russia | |||
142223 | 142223 | 2022-07-09 | Russia | Novosibirsk Oblast | 260606 | 5690 | 0 | 54.9720169 | 79.4813924 | 2022-07-10 04:20:54 | Novosibirsk Oblast, Russia | |||
1417323 | 1417323 | 2022-07-08 | Russia | Novosibirsk Oblast | 260557 | 5690 | 0 | 54.9720169 | 79.4813924 | 2022-07-09 04:20:59 | Novosibirsk Oblast, Russia | |||
2741248 | 2741248 | 2022-07-07 | Russia | Novosibirsk Oblast | 260510 | 5689 | 0 | 54.9720169 | 79.4813924 | 2022-07-08 04:20:56 | Novosibirsk Oblast, Russia | |||
1200043 | 1200043 | 2022-07-06 | Russia | Novosibirsk Oblast | 260460 | 5688 | 0 | 54.9720169 | 79.4813924 | 2022-07-07 04:20:55 | Novosibirsk Oblast, Russia | |||
3966786 | 3966786 | 2022-07-05 | Russia | Novosibirsk Oblast | 260412 | 5688 | 0 | 54.9720169 | 79.4813924 | 2022-07-06 04:20:58 | Novosibirsk Oblast, Russia | |||
3078297 | 3078297 | 2022-07-04 | Russia | Novosibirsk Oblast | 260360 | 5687 | 0 | 54.9720169 | 79.4813924 | 2022-07-05 04:20:45 | Novosibirsk Oblast, Russia | |||
1767579 | 1767579 | 2022-07-03 | Russia | Novosibirsk Oblast | 260313 | 5687 | 0 | 54.9720169 | 79.4813924 | 2022-07-04 04:20:54 | Novosibirsk Oblast, Russia | |||
3365565 | 3365565 | 2022-07-02 | Russia | Novosibirsk Oblast | 260264 | 5686 | 0 | 54.9720169 | 79.4813924 | 2022-07-03 04:20:59 | Novosibirsk Oblast, Russia | |||
593894 | 593894 | 2022-07-01 | Russia | Novosibirsk Oblast | 260212 | 5686 | 0 | 54.9720169 | 79.4813924 | 2022-07-02 04:21:16 | Novosibirsk Oblast, Russia | |||
3940295 | 3940295 | 2022-06-30 | Russia | Novosibirsk Oblast | 260162 | 5686 | 0 | 54.9720169 | 79.4813924 | 2022-07-01 04:21:10 | Novosibirsk Oblast, Russia | |||
2490253 | 2490253 | 2022-06-29 | Russia | Novosibirsk Oblast | 260109 | 5685 | 0 | 54.9720169 | 79.4813924 | 2022-06-30 04:21:01 | Novosibirsk Oblast, Russia | |||
2239635 | 2239635 | 2022-06-28 | Russia | Novosibirsk Oblast | 260058 | 5684 | 0 | 54.9720169 | 79.4813924 | 2022-06-29 04:20:59 | Novosibirsk Oblast, Russia | |||
2147877 | 2147877 | 2022-06-27 | Russia | Novosibirsk Oblast | 260004 | 5684 | 0 | 54.9720169 | 79.4813924 | 2022-06-28 04:20:58 | Novosibirsk Oblast, Russia | |||
475678 | 475678 | 2022-06-26 | Russia | Novosibirsk Oblast | 259955 | 5683 | 0 | 54.9720169 | 79.4813924 | 2022-06-27 04:21:00 | Novosibirsk Oblast, Russia | |||
939053 | 939053 | 2022-06-25 | Russia | Novosibirsk Oblast | 259903 | 5683 | 0 | 54.9720169 | 79.4813924 | 2022-06-26 04:21:02 | Novosibirsk Oblast, Russia | |||
3346873 | 3346873 | 2022-06-24 | Russia | Novosibirsk Oblast | 259853 | 5683 | 0 | 54.9720169 | 79.4813924 | 2022-06-25 04:20:57 | Novosibirsk Oblast, Russia | |||
1648614 | 1648614 | 2022-06-23 | Russia | Novosibirsk Oblast | 259801 | 5682 | 0 | 54.9720169 | 79.4813924 | 2022-06-24 04:20:58 | Novosibirsk Oblast, Russia | |||
2187849 | 2187849 | 2022-06-22 | Russia | Novosibirsk Oblast | 259743 | 5682 | 0 | 54.9720169 | 79.4813924 | 2022-06-23 04:20:55 | Novosibirsk Oblast, Russia | |||
166280 | 166280 | 2022-06-21 | Russia | Novosibirsk Oblast | 259687 | 5681 | 0 | 54.9720169 | 79.4813924 | 2022-06-22 04:20:54 | Novosibirsk Oblast, Russia | |||
1763563 | 1763563 | 2022-06-20 | Russia | Novosibirsk Oblast | 259634 | 5681 | 0 | 54.9720169 | 79.4813924 | 2022-06-21 04:20:56 | Novosibirsk Oblast, Russia | |||
3269749 | 3269749 | 2022-06-19 | Russia | Novosibirsk Oblast | 259584 | 5681 | 0 | 54.9720169 | 79.4813924 | 2022-06-20 04:21:01 | Novosibirsk Oblast, Russia | |||
3397661 | 3397661 | 2022-06-18 | Russia | Novosibirsk Oblast | 259531 | 5680 | 0 | 54.9720169 | 79.4813924 | 2022-06-19 04:20:51 | Novosibirsk Oblast, Russia | |||
2311538 | 2311538 | 2022-06-17 | Russia | Novosibirsk Oblast | 259472 | 5680 | 0 | 54.9720169 | 79.4813924 | 2022-06-18 04:21:10 | Novosibirsk Oblast, Russia | |||
559042 | 559042 | 2022-06-16 | Russia | Novosibirsk Oblast | 259416 | 5680 | 0 | 54.9720169 | 79.4813924 | 2022-06-17 04:20:56 | Novosibirsk Oblast, Russia | |||
3982844 | 3982844 | 2022-06-15 | Russia | Novosibirsk Oblast | 259358 | 5679 | 0 | 54.9720169 | 79.4813924 | 2022-06-16 04:20:55 | Novosibirsk Oblast, Russia | |||
947085 | 947085 | 2022-06-14 | Russia | Novosibirsk Oblast | 259303 | 5679 | 0 | 54.9720169 | 79.4813924 | 2022-06-15 04:20:54 | Novosibirsk Oblast, Russia | |||
2979493 | 2979493 | 2022-06-13 | Russia | Novosibirsk Oblast | 259249 | 5678 | 0 | 54.9720169 | 79.4813924 | 2022-06-14 04:20:52 | Novosibirsk Oblast, Russia |
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]);