johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Tamil Nadu" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687431 | 3687431 | 2022-01-13 | India | Tamil Nadu | 2847589 | 36905 | 0 | 11.006091 | 78.400624 | 2022-01-14 04:21:54 | Tamil Nadu, India | |||
3613015 | 3613015 | 2022-01-12 | India | Tamil Nadu | 2847589 | 36905 | 0 | 11.006091 | 78.400624 | 2022-01-13 08:00:09 | Tamil Nadu, India | |||
1113540 | 1113540 | 2022-01-11 | India | Tamil Nadu | 2814276 | 36866 | 0 | 11.006091 | 78.400624 | 2022-01-12 04:21:44 | Tamil Nadu, India | |||
1692268 | 1692268 | 2022-01-10 | India | Tamil Nadu | 2814276 | 36866 | 0 | 11.006091 | 78.400624 | 2022-01-11 04:22:01 | Tamil Nadu, India | |||
126683 | 126683 | 2022-01-09 | India | Tamil Nadu | 2800286 | 36855 | 0 | 11.006091 | 78.400624 | 2022-01-10 04:22:07 | Tamil Nadu, India | |||
1215518 | 1215518 | 2022-01-08 | India | Tamil Nadu | 2787391 | 36843 | 0 | 11.006091 | 78.400624 | 2022-01-09 04:21:46 | Tamil Nadu, India | |||
1389611 | 1389611 | 2022-01-07 | India | Tamil Nadu | 2776413 | 36833 | 0 | 11.006091 | 78.400624 | 2022-01-08 04:21:53 | Tamil Nadu, India | |||
2609998 | 2609998 | 2022-01-06 | India | Tamil Nadu | 2767432 | 36825 | 0 | 11.006091 | 78.400624 | 2022-01-07 04:22:09 | Tamil Nadu, India | |||
1281940 | 1281940 | 2022-01-05 | India | Tamil Nadu | 2760449 | 36814 | 0 | 11.006091 | 78.400624 | 2022-01-06 04:22:09 | Tamil Nadu, India | |||
1285956 | 1285956 | 2022-01-04 | India | Tamil Nadu | 2755587 | 36805 | 0 | 11.006091 | 78.400624 | 2022-01-05 04:21:59 | Tamil Nadu, India | |||
1700300 | 1700300 | 2022-01-03 | India | Tamil Nadu | 2752856 | 36796 | 0 | 11.006091 | 78.400624 | 2022-01-04 04:22:17 | Tamil Nadu, India | |||
3519383 | 3519383 | 2022-01-02 | India | Tamil Nadu | 2751128 | 36790 | 0 | 11.006091 | 78.400624 | 2022-01-03 02:22:25 | Tamil Nadu, India | |||
2167513 | 2167513 | 2022-01-01 | India | Tamil Nadu | 2749534 | 36784 | 0 | 11.006091 | 78.400624 | 2022-01-02 04:20:52 | Tamil Nadu, India | |||
2776944 | 2776944 | 2021-12-31 | India | Tamil Nadu | 2748045 | 36776 | 0 | 11.006091 | 78.400624 | 2022-01-01 04:22:14 | Tamil Nadu, India | |||
3998601 | 3998601 | 2021-12-30 | India | Tamil Nadu | 2746890 | 36765 | 0 | 11.006091 | 78.400624 | 2021-12-31 04:21:50 | Tamil Nadu, India | |||
1668408 | 1668408 | 2021-12-29 | India | Tamil Nadu | 2746000 | 36758 | 0 | 11.006091 | 78.400624 | 2021-12-30 04:21:25 | Tamil Nadu, India | |||
1432517 | 1432517 | 2021-12-28 | India | Tamil Nadu | 2745261 | 36750 | 0 | 11.006091 | 78.400624 | 2021-12-29 03:21:43 | Tamil Nadu, India | |||
730478 | 730478 | 2021-12-27 | India | Tamil Nadu | 2744642 | 36744 | 0 | 11.006091 | 78.400624 | 2021-12-28 04:21:47 | Tamil Nadu, India | |||
2111650 | 2111650 | 2021-12-26 | India | Tamil Nadu | 2744037 | 36735 | 0 | 11.006091 | 78.400624 | 2021-12-27 04:21:58 | Tamil Nadu, India | |||
3605022 | 3605022 | 2021-12-25 | India | Tamil Nadu | 2743427 | 36725 | 0 | 11.006091 | 78.400624 | 2021-12-26 04:21:50 | Tamil Nadu, India | |||
2963340 | 2963340 | 2021-12-24 | India | Tamil Nadu | 2742821 | 36714 | 0 | 11.006091 | 78.400624 | 2021-12-25 04:21:37 | Tamil Nadu, India | |||
3816372 | 3816372 | 2021-12-23 | India | Tamil Nadu | 2742224 | 36707 | 0 | 11.006091 | 78.400624 | 2021-12-24 04:21:34 | Tamil Nadu, India | |||
798380 | 798380 | 2021-12-22 | India | Tamil Nadu | 2741617 | 36699 | 0 | 11.006091 | 78.400624 | 2021-12-23 04:21:21 | Tamil Nadu, India | |||
3828420 | 3828420 | 2021-12-21 | India | Tamil Nadu | 2741013 | 36691 | 0 | 11.006091 | 78.400624 | 2021-12-22 04:21:54 | Tamil Nadu, India | |||
1254723 | 1254723 | 2021-12-20 | India | Tamil Nadu | 2740411 | 36686 | 0 | 11.006091 | 78.400624 | 2021-12-21 03:21:27 | Tamil Nadu, India | |||
2903666 | 2903666 | 2021-12-19 | India | Tamil Nadu | 2739806 | 36680 | 0 | 11.006091 | 78.400624 | 2021-12-20 04:21:43 | Tamil Nadu, India | |||
1258739 | 1258739 | 2021-12-18 | India | Tamil Nadu | 2738583 | 36667 | 0 | 11.006091 | 78.400624 | 2021-12-19 04:21:11 | Tamil Nadu, India | |||
2398767 | 2398767 | 2021-12-17 | India | Tamil Nadu | 2737962 | 36656 | 0 | 11.006091 | 78.400624 | 2021-12-18 02:22:20 | Tamil Nadu, India | |||
1716305 | 1716305 | 2021-12-16 | India | Tamil Nadu | 2737962 | 36656 | 0 | 11.006091 | 78.400624 | 2021-12-17 04:22:14 | Tamil Nadu, India | |||
3496139 | 3496139 | 2021-12-15 | India | Tamil Nadu | 2737335 | 36644 | 0 | 11.006091 | 78.400624 | 2021-12-16 04:22:11 | Tamil Nadu, India | |||
2087924 | 2087924 | 2021-12-14 | India | Tamil Nadu | 2736695 | 36633 | 0 | 11.006091 | 78.400624 | 2021-12-15 03:22:16 | Tamil Nadu, India | |||
782341 | 782341 | 2021-12-13 | India | Tamil Nadu | 2736046 | 36624 | 0 | 11.006091 | 78.400624 | 2021-12-14 04:22:38 | Tamil Nadu, India | |||
1660376 | 1660376 | 2021-12-12 | India | Tamil Nadu | 2735389 | 36612 | 0 | 11.006091 | 78.400624 | 2021-12-13 04:22:02 | Tamil Nadu, India | |||
1664392 | 1664392 | 2021-12-11 | India | Tamil Nadu | 2734715 | 36599 | 0 | 11.006091 | 78.400624 | 2021-12-12 04:22:12 | Tamil Nadu, India | |||
3655544 | 3655544 | 2021-12-10 | India | Tamil Nadu | 2734034 | 36586 | 0 | 11.006091 | 78.400624 | 2021-12-11 04:22:45 | Tamil Nadu, India | |||
1077875 | 1077875 | 2021-12-09 | India | Tamil Nadu | 2733346 | 36575 | 0 | 11.006091 | 78.400624 | 2021-12-10 04:22:28 | Tamil Nadu, India | |||
550724 | 550724 | 2021-12-08 | India | Tamil Nadu | 2732648 | 36560 | 0 | 11.006091 | 78.400624 | 2021-12-09 04:22:49 | Tamil Nadu, India | |||
404244 | 404244 | 2021-12-07 | India | Tamil Nadu | 2731945 | 36549 | 0 | 11.006091 | 78.400624 | 2021-12-08 04:22:46 | Tamil Nadu, India | |||
1030326 | 1030326 | 2021-12-06 | India | Tamil Nadu | 2731235 | 36539 | 0 | 11.006091 | 78.400624 | 2021-12-07 04:22:34 | Tamil Nadu, India | |||
1740489 | 1740489 | 2021-12-05 | India | Tamil Nadu | 2730516 | 36529 | 0 | 11.006091 | 78.400624 | 2021-12-06 04:22:34 | Tamil Nadu, India | |||
137921 | 137921 | 2021-12-04 | India | Tamil Nadu | 2729061 | 36513 | 0 | 11.006091 | 78.400624 | 2021-12-05 04:22:25 | Tamil Nadu, India | |||
2195574 | 2195574 | 2021-12-03 | India | Tamil Nadu | 2729061 | 36513 | 0 | 11.006091 | 78.400624 | 2021-12-04 04:22:18 | Tamil Nadu, India | |||
280 | 280 | 2021-12-02 | India | Tamil Nadu | 2728350 | 36504 | 0 | 11.006091 | 78.400624 | 2021-12-03 04:23:05 | Tamil Nadu, India | |||
1144879 | 1144879 | 2021-12-01 | India | Tamil Nadu | 2727635 | 36492 | 0 | 11.006091 | 78.400624 | 2021-12-02 04:22:37 | Tamil Nadu, India | |||
3401391 | 3401391 | 2021-11-30 | India | Tamil Nadu | 2726917 | 36481 | 0 | 11.006091 | 78.400624 | 2021-12-01 04:22:29 | Tamil Nadu, India | |||
149934 | 149934 | 2021-11-29 | India | Tamil Nadu | 2726197 | 36472 | 0 | 11.006091 | 78.400624 | 2021-11-30 04:22:53 | Tamil Nadu, India | |||
1231580 | 1231580 | 2021-11-28 | India | Tamil Nadu | 2725467 | 36463 | 0 | 11.006091 | 78.400624 | 2021-11-29 04:22:30 | Tamil Nadu, India | |||
1358287 | 1358287 | 2021-11-27 | India | Tamil Nadu | 2724731 | 36454 | 0 | 11.006091 | 78.400624 | 2021-11-28 04:22:43 | Tamil Nadu, India | |||
758278 | 758278 | 2021-11-26 | India | Tamil Nadu | 2723991 | 36443 | 0 | 11.006091 | 78.400624 | 2021-11-27 04:22:45 | Tamil Nadu, India | |||
1802695 | 1802695 | 2021-11-25 | India | Tamil Nadu | 2723245 | 36432 | 0 | 11.006091 | 78.400624 | 2021-11-26 04:22:33 | Tamil Nadu, India | |||
904129 | 904129 | 2021-11-24 | India | Tamil Nadu | 2722506 | 36415 | 0 | 11.006091 | 78.400624 | 2021-11-25 04:22:33 | Tamil Nadu, India | |||
3069979 | 3069979 | 2021-11-23 | India | Tamil Nadu | 2721762 | 36401 | 0 | 11.006091 | 78.400624 | 2021-11-24 04:22:14 | Tamil Nadu, India | |||
3749077 | 3749077 | 2021-11-22 | India | Tamil Nadu | 2721021 | 36388 | 0 | 11.006091 | 78.400624 | 2021-11-23 04:22:39 | Tamil Nadu, India | |||
1014284 | 1014284 | 2021-11-21 | India | Tamil Nadu | 2720271 | 36375 | 0 | 11.006091 | 78.400624 | 2021-11-22 04:22:20 | Tamil Nadu, India | |||
722448 | 722448 | 2021-11-20 | India | Tamil Nadu | 2719515 | 36361 | 0 | 11.006091 | 78.400624 | 2021-11-21 04:22:13 | Tamil Nadu, India | |||
161978 | 161978 | 2021-11-19 | India | Tamil Nadu | 2718750 | 36349 | 0 | 11.006091 | 78.400624 | 2021-11-20 04:22:17 | Tamil Nadu, India | |||
3288865 | 3288865 | 2021-11-18 | India | Tamil Nadu | 2717978 | 36336 | 0 | 11.006091 | 78.400624 | 2021-11-19 04:21:40 | Tamil Nadu, India | |||
447321 | 447321 | 2021-11-17 | India | Tamil Nadu | 2717203 | 36324 | 0 | 11.006091 | 78.400624 | 2021-11-18 04:21:33 | Tamil Nadu, India | |||
3342571 | 3342571 | 2021-11-16 | India | Tamil Nadu | 2716421 | 36311 | 0 | 11.006091 | 78.400624 | 2021-11-17 04:21:48 | Tamil Nadu, India | |||
2287407 | 2287407 | 2021-11-15 | India | Tamil Nadu | 2715632 | 36296 | 0 | 11.006091 | 78.400624 | 2021-11-16 04:21:10 | Tamil Nadu, India | |||
1322181 | 1322181 | 2021-11-14 | India | Tamil Nadu | 2714830 | 36284 | 0 | 11.006091 | 78.400624 | 2021-11-15 04:21:36 | Tamil Nadu, India | |||
686307 | 686307 | 2021-11-13 | India | Tamil Nadu | 2714025 | 36273 | 0 | 11.006091 | 78.400624 | 2021-11-14 04:21:31 | Tamil Nadu, India | |||
714416 | 714416 | 2021-11-12 | India | Tamil Nadu | 2713216 | 36259 | 0 | 11.006091 | 78.400624 | 2021-11-13 04:21:38 | Tamil Nadu, India | |||
28366 | 28366 | 2021-11-11 | India | Tamil Nadu | 2712404 | 36251 | 0 | 11.006091 | 78.400624 | 2021-11-12 04:22:01 | Tamil Nadu, India | |||
2844805 | 2844805 | 2021-11-10 | India | Tamil Nadu | 2711584 | 36247 | 0 | 11.006091 | 78.400624 | 2021-11-11 04:21:45 | Tamil Nadu, India | |||
87075 | 87075 | 2021-11-09 | India | Tamil Nadu | 2710756 | 36238 | 0 | 11.006091 | 78.400624 | 2021-11-10 04:21:38 | Tamil Nadu, India | |||
3639503 | 3639503 | 2021-11-08 | India | Tamil Nadu | 2709921 | 36226 | 0 | 11.006091 | 78.400624 | 2021-11-09 04:21:36 | Tamil Nadu, India | |||
2000611 | 2000611 | 2021-11-07 | India | Tamil Nadu | 2709080 | 36220 | 0 | 11.006091 | 78.400624 | 2021-11-08 04:21:43 | Tamil Nadu, India | |||
495602 | 495602 | 2021-11-06 | India | Tamil Nadu | 2708230 | 36214 | 0 | 11.006091 | 78.400624 | 2021-11-07 04:21:53 | Tamil Nadu, India | |||
3121457 | 3121457 | 2021-11-05 | India | Tamil Nadu | 2707368 | 36204 | 0 | 11.006091 | 78.400624 | 2021-11-06 04:21:51 | Tamil Nadu, India | |||
698355 | 698355 | 2021-11-04 | India | Tamil Nadu | 2706493 | 36191 | 0 | 11.006091 | 78.400624 | 2021-11-05 04:21:54 | Tamil Nadu, India | |||
276133 | 276133 | 2021-11-03 | India | Tamil Nadu | 2705548 | 36176 | 0 | 11.006091 | 78.400624 | 2021-11-04 04:22:20 | Tamil Nadu, India | |||
43658 | 43658 | 2021-11-02 | India | Tamil Nadu | 2704586 | 36157 | 0 | 11.006091 | 78.400624 | 2021-11-03 06:22:09 | Tamil Nadu, India | |||
3511354 | 3511354 | 2021-11-01 | India | Tamil Nadu | 2703613 | 36136 | 0 | 11.006091 | 78.400624 | 2021-11-02 04:22:03 | Tamil Nadu, India | |||
287946 | 287946 | 2021-10-31 | India | Tamil Nadu | 2702623 | 36116 | 0 | 11.006091 | 78.400624 | 2021-11-01 04:22:01 | Tamil Nadu, India | |||
2720952 | 2720952 | 2021-10-30 | India | Tamil Nadu | 2701614 | 36097 | 0 | 11.006091 | 78.400624 | 2021-10-31 04:22:08 | Tamil Nadu, India | |||
567054 | 567054 | 2021-10-29 | India | Tamil Nadu | 2700593 | 36083 | 0 | 11.006091 | 78.400624 | 2021-10-30 04:22:03 | Tamil Nadu, India | |||
4296 | 4296 | 2021-10-28 | India | Tamil Nadu | 2699554 | 36072 | 0 | 11.006091 | 78.400624 | 2021-10-29 04:22:03 | Tamil Nadu, India | |||
534686 | 534686 | 2021-10-27 | India | Tamil Nadu | 2698493 | 36060 | 0 | 11.006091 | 78.400624 | 2021-10-28 04:22:08 | Tamil Nadu, India | |||
3492123 | 3492123 | 2021-10-26 | India | Tamil Nadu | 2697418 | 36048 | 0 | 11.006091 | 78.400624 | 2021-10-27 04:22:32 | Tamil Nadu, India | |||
3793845 | 3793845 | 2021-10-25 | India | Tamil Nadu | 2696328 | 36033 | 0 | 11.006091 | 78.400624 | 2021-10-26 04:22:09 | Tamil Nadu, India | |||
682291 | 682291 | 2021-10-24 | India | Tamil Nadu | 2695216 | 36019 | 0 | 11.006091 | 78.400624 | 2021-10-25 04:22:31 | Tamil Nadu, India | |||
770299 | 770299 | 2021-10-23 | India | Tamil Nadu | 2694089 | 36004 | 0 | 11.006091 | 78.400624 | 2021-10-24 04:21:22 | Tamil Nadu, India | |||
653946 | 653946 | 2021-10-22 | India | Tamil Nadu | 2692949 | 35987 | 0 | 11.006091 | 78.400624 | 2021-10-23 04:21:32 | Tamil Nadu, India | |||
2123693 | 2123693 | 2021-10-21 | India | Tamil Nadu | 2691797 | 35968 | 0 | 11.006091 | 78.400624 | 2021-10-22 04:21:14 | Tamil Nadu, India | |||
443305 | 443305 | 2021-10-20 | India | Tamil Nadu | 2690633 | 35948 | 0 | 11.006091 | 78.400624 | 2021-10-21 04:21:18 | Tamil Nadu, India | |||
597624 | 597624 | 2021-10-19 | India | Tamil Nadu | 2689463 | 35928 | 0 | 11.006091 | 78.400624 | 2021-10-20 04:21:00 | Tamil Nadu, India | |||
2043801 | 2043801 | 2021-10-18 | India | Tamil Nadu | 2688284 | 35912 | 0 | 11.006091 | 78.400624 | 2021-10-19 04:20:54 | Tamil Nadu, India | |||
1909162 | 1909162 | 2021-10-17 | India | Tamil Nadu | 2687092 | 35899 | 0 | 11.006091 | 78.400624 | 2021-10-18 04:21:10 | Tamil Nadu, India | |||
934751 | 934751 | 2021-10-16 | India | Tamil Nadu | 2685874 | 35884 | 0 | 11.006091 | 78.400624 | 2021-10-17 04:21:29 | Tamil Nadu, India | |||
2943306 | 2943306 | 2021-10-15 | India | Tamil Nadu | 2684641 | 35869 | 0 | 11.006091 | 78.400624 | 2021-10-16 04:21:15 | Tamil Nadu, India | |||
491586 | 491586 | 2021-10-14 | India | Tamil Nadu | 2683396 | 35853 | 0 | 11.006091 | 78.400624 | 2021-10-15 04:21:26 | Tamil Nadu, India | |||
633874 | 633874 | 2021-10-13 | India | Tamil Nadu | 2682137 | 35833 | 0 | 11.006091 | 78.400624 | 2021-10-14 04:21:29 | Tamil Nadu, India | |||
1491552 | 1491552 | 2021-10-12 | India | Tamil Nadu | 2680857 | 35814 | 0 | 11.006091 | 78.400624 | 2021-10-13 04:20:51 | Tamil Nadu, India | |||
3007285 | 3007285 | 2021-10-11 | India | Tamil Nadu | 2679568 | 35796 | 0 | 11.006091 | 78.400624 | 2021-10-12 04:21:09 | Tamil Nadu, India | |||
423301 | 423301 | 2021-10-10 | India | Tamil Nadu | 2678265 | 35783 | 0 | 11.006091 | 78.400624 | 2021-10-11 04:21:31 | Tamil Nadu, India | |||
2876158 | 2876158 | 2021-10-09 | India | Tamil Nadu | 2676936 | 35768 | 0 | 11.006091 | 78.400624 | 2021-10-10 04:21:38 | Tamil Nadu, India | |||
2959324 | 2959324 | 2021-10-08 | India | Tamil Nadu | 2675592 | 35754 | 0 | 11.006091 | 78.400624 | 2021-10-09 04:21:34 | Tamil Nadu, India | |||
467362 | 467362 | 2021-10-07 | India | Tamil Nadu | 2674233 | 35734 | 0 | 11.006091 | 78.400624 | 2021-10-08 04:21:25 | Tamil Nadu, India | |||
2458742 | 2458742 | 2021-10-06 | India | Tamil Nadu | 2672843 | 35707 | 0 | 11.006091 | 78.400624 | 2021-10-07 04:21:36 | Tamil Nadu, India |
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]);