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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235334 | 2235334 | 2022-06-12 | India | Tamil Nadu | 3457382 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-13 04:21:14 | Tamil Nadu, India | |||
3141532 | 3141532 | 2022-06-11 | India | Tamil Nadu | 3457133 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-12 04:20:53 | Tamil Nadu, India | |||
1944448 | 1944448 | 2022-06-10 | India | Tamil Nadu | 3456916 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-11 04:21:01 | Tamil Nadu, India | |||
3157587 | 3157587 | 2022-06-09 | India | Tamil Nadu | 3456697 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-10 04:20:55 | Tamil Nadu, India | |||
1421054 | 1421054 | 2022-06-08 | India | Tamil Nadu | 3456512 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-09 04:20:54 | Tamil Nadu, India | |||
3726168 | 3726168 | 2022-06-07 | India | Tamil Nadu | 3456317 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-08 04:20:55 | Tamil Nadu, India | |||
3887570 | 3887570 | 2022-06-06 | India | Tamil Nadu | 3456173 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-07 04:21:08 | Tamil Nadu, India | |||
3507339 | 3507339 | 2022-06-05 | India | Tamil Nadu | 3456083 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-06 04:20:57 | Tamil Nadu, India | |||
3527416 | 3527416 | 2022-06-04 | India | Tamil Nadu | 3455976 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-05 04:20:55 | Tamil Nadu, India | |||
3133502 | 3133502 | 2022-06-03 | India | Tamil Nadu | 3455871 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-04 04:20:58 | Tamil Nadu, India | |||
3578577 | 3578577 | 2022-06-02 | India | Tamil Nadu | 3455758 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-03 04:20:58 | Tamil Nadu, India | |||
970870 | 970870 | 2022-06-01 | India | Tamil Nadu | 3455613 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-02 05:20:39 | Tamil Nadu, India | |||
229177 | 229177 | 2022-05-31 | India | Tamil Nadu | 3455474 | 38025 | 0 | 11.006091 | 78.400624 | 2022-06-01 04:20:55 | Tamil Nadu, India | |||
3185942 | 3185942 | 2022-05-30 | India | Tamil Nadu | 3455376 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-31 04:20:51 | Tamil Nadu, India | |||
3198091 | 3198091 | 2022-05-29 | India | Tamil Nadu | 3455287 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-30 04:20:50 | Tamil Nadu, India | |||
2724969 | 2724969 | 2022-05-28 | India | Tamil Nadu | 3455210 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-29 04:20:53 | Tamil Nadu, India | |||
1314150 | 1314150 | 2022-05-27 | India | Tamil Nadu | 3455154 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-28 04:21:07 | Tamil Nadu, India | |||
1849942 | 1849942 | 2022-05-26 | India | Tamil Nadu | 3455099 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-27 04:20:56 | Tamil Nadu, India | |||
2047818 | 2047818 | 2022-05-25 | India | Tamil Nadu | 3455040 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-26 04:20:50 | Tamil Nadu, India | |||
2999256 | 2999256 | 2022-05-24 | India | Tamil Nadu | 3454984 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-25 04:20:56 | Tamil Nadu, India | |||
3592977 | 3592977 | 2022-05-23 | India | Tamil Nadu | 3454925 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-24 04:20:57 | Tamil Nadu, India | |||
621829 | 621829 | 2022-05-22 | India | Tamil Nadu | 3455040 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-26 04:20:50 | Tamil Nadu, India | |||
1109525 | 1109525 | 2022-05-21 | India | Tamil Nadu | 3454847 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-22 04:20:52 | Tamil Nadu, India | |||
1169149 | 1169149 | 2022-05-20 | India | Tamil Nadu | 3454801 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-21 04:20:58 | Tamil Nadu, India | |||
3895912 | 3895912 | 2022-05-19 | India | Tamil Nadu | 3454764 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-20 04:20:57 | Tamil Nadu, India | |||
1184696 | 1184696 | 2022-05-18 | India | Tamil Nadu | 3454722 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-19 04:20:54 | Tamil Nadu, India | |||
3582593 | 3582593 | 2022-05-17 | India | Tamil Nadu | 3454686 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-18 04:20:50 | Tamil Nadu, India | |||
1503550 | 1503550 | 2022-05-16 | India | Tamil Nadu | 3454652 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-17 04:20:59 | Tamil Nadu, India | |||
2083909 | 2083909 | 2022-05-15 | India | Tamil Nadu | 3454621 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-16 04:20:47 | Tamil Nadu, India | |||
3354620 | 3354620 | 2022-05-14 | India | Tamil Nadu | 3454591 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-15 04:20:53 | Tamil Nadu, India | |||
658265 | 658265 | 2022-05-13 | India | Tamil Nadu | 3454556 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-14 04:20:48 | Tamil Nadu, India | |||
2533348 | 2533348 | 2022-05-12 | India | Tamil Nadu | 3454512 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-13 04:20:51 | Tamil Nadu, India | |||
3444794 | 3444794 | 2022-05-11 | India | Tamil Nadu | 3454470 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-12 04:20:54 | Tamil Nadu, India | |||
3535411 | 3535411 | 2022-05-10 | India | Tamil Nadu | 3454431 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-11 04:20:48 | Tamil Nadu, India | |||
221946 | 221946 | 2022-05-09 | India | Tamil Nadu | 3454391 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-10 04:20:50 | Tamil Nadu, India | |||
2331331 | 2331331 | 2022-05-08 | India | Tamil Nadu | 3454353 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-09 04:20:54 | Tamil Nadu, India | |||
360293 | 360293 | 2022-05-07 | India | Tamil Nadu | 3454306 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-08 04:20:49 | Tamil Nadu, India | |||
1397644 | 1397644 | 2022-05-06 | India | Tamil Nadu | 3454217 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-07 04:21:09 | Tamil Nadu, India | |||
2597999 | 2597999 | 2022-05-05 | India | Tamil Nadu | 3454153 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-06 04:21:00 | Tamil Nadu, India | |||
3265448 | 3265448 | 2022-05-04 | India | Tamil Nadu | 3454095 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-05 04:20:55 | Tamil Nadu, India | |||
1572087 | 1572087 | 2022-05-03 | India | Tamil Nadu | 3454058 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-04 04:20:59 | Tamil Nadu, India | |||
463347 | 463347 | 2022-05-02 | India | Tamil Nadu | 3454019 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-03 04:21:00 | Tamil Nadu, India | |||
3915986 | 3915986 | 2022-05-01 | India | Tamil Nadu | 3453979 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-02 04:21:10 | Tamil Nadu, India | |||
2840790 | 2840790 | 2022-04-30 | India | Tamil Nadu | 3453932 | 38025 | 0 | 11.006091 | 78.400624 | 2022-05-01 04:20:57 | Tamil Nadu, India | |||
1157103 | 1157103 | 2022-04-29 | India | Tamil Nadu | 3453883 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-30 04:21:05 | Tamil Nadu, India | |||
1696285 | 1696285 | 2022-04-28 | India | Tamil Nadu | 3453829 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-29 04:20:59 | Tamil Nadu, India | |||
3851768 | 3851768 | 2022-04-27 | India | Tamil Nadu | 3453756 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-28 04:20:47 | Tamil Nadu, India | |||
1326198 | 1326198 | 2022-04-26 | India | Tamil Nadu | 3453679 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-27 04:20:52 | Tamil Nadu, India | |||
3722152 | 3722152 | 2022-04-25 | India | Tamil Nadu | 3453552 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-26 04:20:51 | Tamil Nadu, India | |||
2028720 | 2028720 | 2022-04-24 | India | Tamil Nadu | 3453552 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-25 04:20:56 | Tamil Nadu, India | |||
746295 | 746295 | 2022-04-23 | India | Tamil Nadu | 3453500 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-24 04:20:56 | Tamil Nadu, India | |||
3436780 | 3436780 | 2022-04-22 | India | Tamil Nadu | 3453447 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-23 04:20:50 | Tamil Nadu, India | |||
2892365 | 2892365 | 2022-04-21 | India | Tamil Nadu | 3453390 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-22 04:20:45 | Tamil Nadu, India | |||
2307237 | 2307237 | 2022-04-20 | India | Tamil Nadu | 3453351 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-21 04:20:46 | Tamil Nadu, India | |||
2251376 | 2251376 | 2022-04-19 | India | Tamil Nadu | 3453320 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-20 04:20:45 | Tamil Nadu, India | |||
1845926 | 1845926 | 2022-04-18 | India | Tamil Nadu | 3453290 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-19 04:21:00 | Tamil Nadu, India | |||
3416870 | 3416870 | 2022-04-17 | India | Tamil Nadu | 3453263 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-18 04:21:12 | Tamil Nadu, India | |||
303819 | 303819 | 2022-04-16 | India | Tamil Nadu | 3453233 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-17 04:20:59 | Tamil Nadu, India | |||
2669764 | 2669764 | 2022-04-15 | India | Tamil Nadu | 3453210 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-16 04:20:48 | Tamil Nadu, India | |||
1223549 | 1223549 | 2022-04-14 | India | Tamil Nadu | 3453188 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-15 04:20:57 | Tamil Nadu, India | |||
2442707 | 2442707 | 2022-04-13 | India | Tamil Nadu | 3453163 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-13 23:21:06 | Tamil Nadu, India | |||
1948464 | 1948464 | 2022-04-12 | India | Tamil Nadu | 3453134 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-13 04:21:03 | Tamil Nadu, India | |||
3206217 | 3206217 | 2022-04-11 | India | Tamil Nadu | 3453112 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-12 04:20:49 | Tamil Nadu, India | |||
1576103 | 1576103 | 2022-04-10 | India | Tamil Nadu | 3453084 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-11 04:21:02 | Tamil Nadu, India | |||
1652345 | 1652345 | 2022-04-09 | India | Tamil Nadu | 3453054 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-10 04:20:52 | Tamil Nadu, India | |||
2115667 | 2115667 | 2022-04-08 | India | Tamil Nadu | 3453033 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-09 04:20:42 | Tamil Nadu, India | |||
3320191 | 3320191 | 2022-04-07 | India | Tamil Nadu | 3453011 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-08 04:20:48 | Tamil Nadu, India | |||
2800727 | 2800727 | 2022-04-06 | India | Tamil Nadu | 3452985 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-07 04:20:53 | Tamil Nadu, India | |||
3867496 | 3867496 | 2022-04-05 | India | Tamil Nadu | 3452955 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-06 04:20:49 | Tamil Nadu, India | |||
2748838 | 2748838 | 2022-04-04 | India | Tamil Nadu | 3452931 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-05 04:20:48 | Tamil Nadu, India | |||
3730184 | 3730184 | 2022-04-03 | India | Tamil Nadu | 3452910 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-04 04:20:51 | Tamil Nadu, India | |||
499619 | 499619 | 2022-04-02 | India | Tamil Nadu | 3452887 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-03 04:20:48 | Tamil Nadu, India | |||
3350604 | 3350604 | 2022-04-01 | India | Tamil Nadu | 3452857 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-02 04:20:47 | Tamil Nadu, India | |||
1539909 | 1539909 | 2022-03-31 | India | Tamil Nadu | 3452825 | 38025 | 0 | 11.006091 | 78.400624 | 2022-04-01 04:20:28 | Tamil Nadu, India | |||
2477922 | 2477922 | 2022-03-30 | India | Tamil Nadu | 3452790 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-31 04:20:56 | Tamil Nadu, India | |||
157963 | 157963 | 2022-03-29 | India | Tamil Nadu | 3452751 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-30 04:20:45 | Tamil Nadu, India | |||
1436534 | 1436534 | 2022-03-28 | India | Tamil Nadu | 3452714 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-29 04:20:46 | Tamil Nadu, India | |||
876215 | 876215 | 2022-03-27 | India | Tamil Nadu | 3452681 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-28 04:20:33 | Tamil Nadu, India | |||
2163498 | 2163498 | 2022-03-26 | India | Tamil Nadu | 3452647 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-27 04:20:47 | Tamil Nadu, India | |||
1720434 | 1720434 | 2022-03-25 | India | Tamil Nadu | 3452612 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-26 04:20:23 | Tamil Nadu, India | |||
1468051 | 1468051 | 2022-03-24 | India | Tamil Nadu | 3452575 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-25 04:20:46 | Tamil Nadu, India | |||
3022225 | 3022225 | 2022-03-23 | India | Tamil Nadu | 3452534 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-24 04:20:43 | Tamil Nadu, India | |||
1905147 | 1905147 | 2022-03-22 | India | Tamil Nadu | 3452490 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-23 04:20:48 | Tamil Nadu, India | |||
3238278 | 3238278 | 2022-03-21 | India | Tamil Nadu | 3452442 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-22 04:20:54 | Tamil Nadu, India | |||
24351 | 24351 | 2022-03-20 | India | Tamil Nadu | 3452390 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-21 04:20:50 | Tamil Nadu, India | |||
1656361 | 1656361 | 2022-03-19 | India | Tamil Nadu | 3452334 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-20 04:20:45 | Tamil Nadu, India | |||
335887 | 335887 | 2022-03-18 | India | Tamil Nadu | 3452276 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-19 04:20:47 | Tamil Nadu, India | |||
694340 | 694340 | 2022-03-17 | India | Tamil Nadu | 3452215 | 38025 | 0 | 11.006091 | 78.400624 | 2022-03-18 04:20:55 | Tamil Nadu, India | |||
2319283 | 2319283 | 2022-03-16 | India | Tamil Nadu | 3452145 | 38024 | 0 | 11.006091 | 78.400624 | 2022-03-17 04:20:56 | Tamil Nadu, India | |||
261483 | 261483 | 2022-03-15 | India | Tamil Nadu | 3452073 | 38024 | 0 | 11.006091 | 78.400624 | 2022-03-16 04:20:50 | Tamil Nadu, India | |||
2263842 | 2263842 | 2022-03-14 | India | Tamil Nadu | 3451996 | 38024 | 0 | 11.006091 | 78.400624 | 2022-03-15 04:20:47 | Tamil Nadu, India | |||
3627908 | 3627908 | 2022-03-13 | India | Tamil Nadu | 3451910 | 38023 | 0 | 11.006091 | 78.400624 | 2022-03-14 04:20:46 | Tamil Nadu, India | |||
950816 | 950816 | 2022-03-12 | India | Tamil Nadu | 3451815 | 38023 | 0 | 11.006091 | 78.400624 | 2022-03-13 04:20:49 | Tamil Nadu, India | |||
356277 | 356277 | 2022-03-11 | India | Tamil Nadu | 3451710 | 38023 | 0 | 11.006091 | 78.400624 | 2022-03-12 04:20:50 | Tamil Nadu, India | |||
1865429 | 1865429 | 2022-03-10 | India | Tamil Nadu | 3451598 | 38023 | 0 | 11.006091 | 78.400624 | 2022-03-11 04:20:50 | Tamil Nadu, India | |||
2140124 | 2140124 | 2022-03-09 | India | Tamil Nadu | 3451469 | 38021 | 0 | 11.006091 | 78.400624 | 2022-03-10 04:20:48 | Tamil Nadu, India | |||
919635 | 919635 | 2022-03-08 | India | Tamil Nadu | 3451322 | 38019 | 0 | 11.006091 | 78.400624 | 2022-03-09 04:20:59 | Tamil Nadu, India | |||
1547922 | 1547922 | 2022-03-07 | India | Tamil Nadu | 3451171 | 38017 | 0 | 11.006091 | 78.400624 | 2022-03-08 04:20:54 | Tamil Nadu, India | |||
2199591 | 2199591 | 2022-03-06 | India | Tamil Nadu | 3451013 | 38015 | 0 | 11.006091 | 78.400624 | 2022-03-07 04:20:47 | Tamil Nadu, India | |||
2092048 | 2092048 | 2022-03-05 | India | Tamil Nadu | 3450817 | 38012 | 0 | 11.006091 | 78.400624 | 2022-03-06 04:20:49 | 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]);