johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
179 rows where confirmed = 3625 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62877 | 62877 | 2022-11-12 | China | Zhejiang | 3625 | 1 | 0 | 29.1832 | 120.0934 | 2022-11-13 04:21:14 | Zhejiang, China | |||
200834 | 200834 | 2022-10-19 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-20 04:22:59 | Love, Oklahoma, US | |
2759495 | 2759495 | 2022-10-18 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-19 04:22:26 | Love, Oklahoma, US | |
2027329 | 2027329 | 2022-10-17 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-18 04:22:42 | Love, Oklahoma, US | |
2162107 | 2162107 | 2022-10-16 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-17 04:20:31 | Love, Oklahoma, US | |
518304 | 518304 | 2022-10-15 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-16 04:22:39 | Love, Oklahoma, US | |
2035361 | 2035361 | 2022-10-14 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-15 04:22:00 | Love, Oklahoma, US | |
3756049 | 3756049 | 2022-10-13 | US | Oklahoma | Love | 40085 | 3625 | 43 | 0 | 33.95273467 | -97.23906784 | 2022-10-14 04:22:28 | Love, Oklahoma, US | |
3776681 | 3776681 | 2022-08-30 | US | Puerto Rico | Rincon | 72117 | 3625 | 0 | 0 | 18.335443 | -67.23174 | 2022-08-31 04:20:57 | Rincon, Puerto Rico, US | |
1683277 | 1683277 | 2022-08-29 | US | Puerto Rico | Rincon | 72117 | 3625 | 0 | 0 | 18.335443 | -67.23174 | 2022-08-30 04:21:03 | Rincon, Puerto Rico, US | |
2404353 | 2404353 | 2022-08-21 | US | Louisiana | Madison | 22065 | 3625 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-08-22 04:20:38 | Madison, Louisiana, US | |
3799431 | 3799431 | 2022-08-20 | US | Louisiana | Madison | 22065 | 3625 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-08-21 04:20:44 | Madison, Louisiana, US | |
2365017 | 2365017 | 2022-08-19 | US | Louisiana | Madison | 22065 | 3625 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-08-20 04:21:01 | Madison, Louisiana, US | |
1162688 | 1162688 | 2022-08-18 | US | Louisiana | Madison | 22065 | 3625 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-08-19 04:20:54 | Madison, Louisiana, US | |
3911429 | 3911429 | 2022-08-11 | US | Virginia | Westmoreland | 51193 | 3625 | 55 | 0 | 38.11021557 | -76.80213247 | 2022-08-12 04:20:54 | Westmoreland, Virginia, US | |
1068314 | 1068314 | 2022-07-28 | US | North Dakota | Walsh | 38099 | 3625 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-07-29 04:20:45 | Walsh, North Dakota, US | |
2594540 | 2594540 | 2022-07-25 | US | Arkansas | Marion | 5089 | 3625 | 89 | 0 | 36.26844485 | -92.68451899 | 2022-07-26 04:20:58 | Marion, Arkansas, US | |
899949 | 899949 | 2022-07-22 | China | Fujian | 3625 | 1 | 0 | 26.0789 | 117.9874 | 2022-07-23 04:20:53 | Fujian, China | |||
948469 | 948469 | 2022-06-14 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-15 04:20:54 | Benzie, Michigan, US | |
2980877 | 2980877 | 2022-06-13 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-14 04:20:52 | Benzie, Michigan, US | |
2237003 | 2237003 | 2022-06-12 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-13 04:21:14 | Benzie, Michigan, US | |
3143201 | 3143201 | 2022-06-11 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-12 04:20:53 | Benzie, Michigan, US | |
1946117 | 1946117 | 2022-06-10 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-11 04:21:01 | Benzie, Michigan, US | |
3159256 | 3159256 | 2022-06-09 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-10 04:20:55 | Benzie, Michigan, US | |
1422723 | 1422723 | 2022-06-08 | US | Michigan | Benzie | 26019 | 3625 | 69 | 0 | 44.63899297 | -86.01608482 | 2022-06-09 04:20:54 | Benzie, Michigan, US | |
3187489 | 3187489 | 2022-05-30 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-31 04:20:51 | Caldwell, Louisiana, US | |
3199638 | 3199638 | 2022-05-29 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-30 04:20:50 | Caldwell, Louisiana, US | |
2726516 | 2726516 | 2022-05-28 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-29 04:20:53 | Caldwell, Louisiana, US | |
1315697 | 1315697 | 2022-05-27 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-28 04:21:07 | Caldwell, Louisiana, US | |
1851489 | 1851489 | 2022-05-26 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-27 04:20:56 | Caldwell, Louisiana, US | |
2049365 | 2049365 | 2022-05-25 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-26 04:20:50 | Caldwell, Louisiana, US | |
3584140 | 3584140 | 2022-05-17 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-18 04:20:50 | Caldwell, Louisiana, US | |
1505097 | 1505097 | 2022-05-16 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-17 04:20:59 | Caldwell, Louisiana, US | |
2085456 | 2085456 | 2022-05-15 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-16 04:20:47 | Caldwell, Louisiana, US | |
3356166 | 3356166 | 2022-05-14 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-15 04:20:53 | Caldwell, Louisiana, US | |
659811 | 659811 | 2022-05-13 | US | Louisiana | Caldwell | 22021 | 3625 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-14 04:20:48 | Caldwell, Louisiana, US | |
2334157 | 2334157 | 2022-05-08 | US | Puerto Rico | Salinas | 72123 | 3625 | 0 | 0 | 18.010387 | -66.256592 | 2022-05-09 04:20:54 | Salinas, Puerto Rico, US | |
465817 | 465817 | 2022-05-02 | US | North Dakota | Ramsey | 38071 | 3625 | 57 | 0 | 48.26886249 | -98.72223879 | 2022-05-03 04:21:00 | Ramsey, North Dakota, US | |
1327797 | 1327797 | 2022-04-26 | US | Louisiana | West Carroll | 22123 | 3625 | 66 | 0 | 32.78550125 | -91.461201 | 2022-04-27 04:20:52 | West Carroll, Louisiana, US | |
3723751 | 3723751 | 2022-04-25 | US | Louisiana | West Carroll | 22123 | 3625 | 66 | 0 | 32.78550125 | -91.461201 | 2022-04-26 04:20:51 | West Carroll, Louisiana, US | |
2030319 | 2030319 | 2022-04-24 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-25 04:20:56 | West Carroll, Louisiana, US | |
747894 | 747894 | 2022-04-23 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-24 04:20:56 | West Carroll, Louisiana, US | |
3438379 | 3438379 | 2022-04-22 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-23 04:20:50 | West Carroll, Louisiana, US | |
2893964 | 2893964 | 2022-04-21 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-22 04:20:45 | West Carroll, Louisiana, US | |
2308836 | 2308836 | 2022-04-20 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-21 04:20:46 | West Carroll, Louisiana, US | |
2252975 | 2252975 | 2022-04-19 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-20 04:20:45 | West Carroll, Louisiana, US | |
1847525 | 1847525 | 2022-04-18 | US | Louisiana | West Carroll | 22123 | 3625 | 65 | 0 | 32.78550125 | -91.461201 | 2022-04-19 04:21:00 | West Carroll, Louisiana, US | |
879823 | 879823 | 2022-03-27 | US | Wisconsin | Lafayette | 55065 | 3625 | 22 | 0 | 42.66005229 | -90.1317729 | 2022-03-28 04:20:33 | Lafayette, Wisconsin, US | |
2167106 | 2167106 | 2022-03-26 | US | Wisconsin | Lafayette | 55065 | 3625 | 22 | 0 | 42.66005229 | -90.1317729 | 2022-03-27 04:20:47 | Lafayette, Wisconsin, US | |
1724042 | 1724042 | 2022-03-25 | US | Wisconsin | Lafayette | 55065 | 3625 | 22 | 0 | 42.66005229 | -90.1317729 | 2022-03-26 04:20:23 | Lafayette, Wisconsin, US | |
3240964 | 3240964 | 2022-03-21 | US | Oregon | Tillamook | 41057 | 3625 | 60 | 0 | 45.46248721 | -123.712066 | 2022-03-22 04:20:54 | Tillamook, Oregon, US | |
2200468 | 2200468 | 2022-03-06 | US | Georgia | Jefferson | 13163 | 3625 | 107 | 0 | 33.05867328 | -82.41609057 | 2022-03-07 04:20:47 | Jefferson, Georgia, US | |
2092925 | 2092925 | 2022-03-05 | US | Georgia | Jefferson | 13163 | 3625 | 107 | 0 | 33.05867328 | -82.41609057 | 2022-03-06 04:20:49 | Jefferson, Georgia, US | |
2666625 | 2666625 | 2022-03-04 | US | Georgia | Jefferson | 13163 | 3625 | 107 | 0 | 33.05867328 | -82.41609057 | 2022-03-05 04:21:10 | Jefferson, Georgia, US | |
2525989 | 2525989 | 2022-03-02 | US | Colorado | Grand | 8049 | 3625 | 26 | 0 | 40.10603347 | -106.11780420000001 | 2022-03-03 04:21:01 | Grand, Colorado, US | |
1993283 | 1993283 | 2022-03-01 | US | Colorado | Grand | 8049 | 3625 | 26 | 0 | 40.10603347 | -106.11780420000001 | 2022-03-02 04:21:07 | Grand, Colorado, US | |
3673091 | 3673091 | 2022-02-15 | US | Kentucky | Magoffin | 21153 | 3625 | 38 | 0 | 37.70820545 | -83.0657714 | 2022-02-16 04:21:10 | Magoffin, Kentucky, US | |
1363833 | 1363833 | 2022-02-08 | US | Kentucky | Washington | 21229 | 3625 | 54 | 0 | 37.75599461 | -85.17407732 | 2022-02-09 04:21:04 | Washington, Kentucky, US | |
2330080 | 2330080 | 2022-02-04 | US | Puerto Rico | Aguas Buenas | 72007 | 3625 | 0 | 0 | 18.251619 | -66.126806 | 2022-02-05 04:21:05 | Aguas Buenas, Puerto Rico, US | |
2658276 | 2658276 | 2022-01-31 | US | Arkansas | Franklin | 5047 | 3625 | 63 | 0 | 35.51202821 | -93.89299569 | 2022-02-01 04:21:11 | Franklin, Arkansas, US | |
3811868 | 3811868 | 2022-01-28 | US | Missouri | Moniteau | 29135 | 3625 | 48 | 0 | 38.63571781 | -92.57976951 | 2022-01-29 04:21:10 | Moniteau, Missouri, US | |
1472115 | 1472115 | 2022-01-17 | Japan | Iwate | 3625 | 53 | 0 | 39.593287 | 141.361777 | 2022-01-18 04:21:04 | Iwate, Japan | |||
99113 | 99113 | 2022-01-14 | China | Guangdong | 3625 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-15 04:21:07 | Guangdong, China | |||
1695748 | 1695748 | 2022-01-10 | US | Washington | Adams | 53001 | 3625 | 35 | 0 | 46.98299757 | -118.56017340000001 | 2022-01-11 04:22:01 | Adams, Washington, US | |
1282505 | 1282505 | 2022-01-05 | US | Arkansas | Phillips | 5107 | 3625 | 83 | 0 | 34.43268455 | -90.84800154 | 2022-01-06 04:22:09 | Phillips, Arkansas, US | |
1288936 | 1288936 | 2022-01-04 | US | Tennessee | Crockett | 47033 | 3625 | 75 | 0 | 35.81830662 | -89.14916269 | 2022-01-05 04:21:59 | Crockett, Tennessee, US | |
4001993 | 4001993 | 2021-12-30 | US | Virginia | Fredericksburg | 51630 | 3625 | 27 | 0 | 38.2977863 | -77.4922454 | 2021-12-31 04:21:50 | Fredericksburg, Virginia, US | |
2963889 | 2963889 | 2021-12-24 | US | Arkansas | Lawrence | 5075 | 3625 | 62 | 0 | 36.04188196 | -91.10867198 | 2021-12-25 04:21:37 | Lawrence, Arkansas, US | |
1719904 | 1719904 | 2021-12-16 | US | Wisconsin | Green Lake | 55047 | 3625 | 44 | 0 | 43.80025981 | -89.04679553 | 2021-12-17 04:22:14 | Green Lake, Wisconsin, US | |
1078902 | 1078902 | 2021-12-09 | US | Illinois | Crawford | 17033 | 3625 | 31 | 0 | 39.0032229 | -87.75954624 | 2021-12-10 04:22:28 | Crawford, Illinois, US | |
1033751 | 1033751 | 2021-12-06 | US | Virginia | Mecklenburg | 51117 | 3625 | 90 | 0 | 36.67882005 | -78.36131056 | 2021-12-07 04:22:34 | Mecklenburg, Virginia, US | |
1743464 | 1743464 | 2021-12-05 | US | Tennessee | Chester | 47023 | 3625 | 78 | 0 | 35.42527478 | -88.6095842 | 2021-12-06 04:22:34 | Chester, Tennessee, US | |
141070 | 141070 | 2021-12-04 | US | Texas | Gonzales | 48177 | 3625 | 85 | 0 | 29.45634206 | -97.49424032 | 2021-12-05 04:22:25 | Gonzales, Texas, US | |
1148316 | 1148316 | 2021-12-01 | US | Virginia | Page | 51139 | 3625 | 88 | 0 | 38.61807452 | -78.48797204 | 2021-12-02 04:22:37 | Page, Virginia, US | |
1147217 | 1147217 | 2021-12-01 | US | North Carolina | Ashe | 37009 | 3625 | 54 | 0 | 36.43296207 | -81.49862729 | 2021-12-02 04:22:37 | Ashe, North Carolina, US | |
278032 | 278032 | 2021-11-03 | US | Mississippi | Stone | 28131 | 3625 | 65 | 0 | 30.79187949 | -89.11547539 | 2021-11-04 04:22:20 | Stone, Mississippi, US | |
569058 | 569058 | 2021-10-29 | US | Missouri | Randolph | 29175 | 3625 | 36 | 0 | 39.44007257 | -92.49713740000001 | 2021-10-30 04:22:03 | Randolph, Missouri, US | |
2126216 | 2126216 | 2021-10-21 | US | Ohio | Henry | 39069 | 3625 | 73 | 0 | 41.333964200000004 | -84.06830637 | 2021-10-22 04:21:14 | Henry, Ohio, US | |
599827 | 599827 | 2021-10-19 | US | New Hampshire | Carroll | 33003 | 3625 | 19 | 0 | 43.87498583 | -71.20430216 | 2021-10-20 04:21:00 | Carroll, New Hampshire, US | |
2876708 | 2876708 | 2021-10-09 | US | Arkansas | Lincoln | 5079 | 3625 | 55 | 0 | 33.95317155 | -91.74002806 | 2021-10-10 04:21:38 | Lincoln, Arkansas, US | |
2133890 | 2133890 | 2021-10-01 | US | Missouri | Audrain | 29007 | 3625 | 64 | 0 | 39.215877 | -91.84242683 | 2021-10-02 04:21:25 | Audrain, Missouri, US | |
1335216 | 1335216 | 2021-09-28 | US | Idaho | Jefferson | 16051 | 3625 | 35 | 0 | 43.82078483 | -112.3131749 | 2021-09-29 04:21:45 | Jefferson, Idaho, US | |
180810 | 180810 | 2021-09-02 | US | Puerto Rico | Vega Baja | 72145 | 3625 | 0 | 0 | 18.428262 | -66.397924 | 2021-09-03 04:21:20 | Vega Baja, Puerto Rico, US | |
1776804 | 1776804 | 2021-08-30 | US | Kentucky | Montgomery | 21173 | 3625 | 35 | 0 | 38.03253032 | -83.9145241 | 2021-08-31 04:21:46 | Montgomery, Kentucky, US | |
33873 | 33873 | 2021-08-25 | US | Kentucky | Perry | 21193 | 3625 | 70 | 0 | 37.25023553 | -83.22922731 | 2021-08-26 04:21:28 | Perry, Kentucky, US | |
3108050 | 3108050 | 2021-08-24 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-25 04:21:41 | Texas, Oklahoma, US | |
3168221 | 3168221 | 2021-08-23 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-24 04:21:19 | Texas, Oklahoma, US | |
2178148 | 2178148 | 2021-08-22 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-23 04:21:27 | Texas, Oklahoma, US | |
3558244 | 3558244 | 2021-08-21 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-22 04:21:29 | Texas, Oklahoma, US | |
1856586 | 1856586 | 2021-08-20 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-21 04:21:38 | Texas, Oklahoma, US | |
514293 | 514293 | 2021-08-19 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-20 04:21:33 | Texas, Oklahoma, US | |
513084 | 513084 | 2021-08-19 | US | Kentucky | Clay | 21051 | 3625 | 46 | 0 | 37.16451126 | -83.712575 | 2021-08-20 04:21:33 | Clay, Kentucky, US | |
2520772 | 2520772 | 2021-08-18 | US | Oklahoma | Texas | 40139 | 3625 | 35 | 0 | 36.74777635 | -101.4889765 | 2021-08-19 04:21:15 | Texas, Oklahoma, US | |
2901534 | 2901534 | 2021-08-12 | US | Mississippi | Tate | 28137 | 3625 | 88 | 0 | 34.65133709 | -89.94485778 | 2021-08-13 04:21:24 | Tate, Mississippi, US | |
1344136 | 1344136 | 2021-08-11 | US | Mississippi | Sunflower | 28133 | 3625 | 95 | 0 | 33.60192578 | -90.58882684 | 2021-08-12 04:21:25 | Sunflower, Mississippi, US | |
1344005 | 1344005 | 2021-08-11 | US | Minnesota | Freeborn | 27047 | 3625 | 36 | 0 | 43.67385583 | -93.34884422 | 2021-08-12 04:21:25 | Freeborn, Minnesota, US | |
591602 | 591602 | 2021-08-08 | US | Missouri | Warren | 29219 | 3625 | 29 | 0 | 38.76529479 | -91.16124662 | 2021-08-09 04:21:24 | Warren, Missouri, US | |
3137905 | 3137905 | 2021-07-23 | US | Alabama | Clarke | 1025 | 3625 | 62 | 0 | 31.68099859 | -87.83548597 | 2021-07-24 00:21:36 | Clarke, Alabama, US | |
2948734 | 2948734 | 2021-07-16 | US | Kentucky | Calloway | 21035 | 3625 | 50 | 0 | 36.62093411 | -88.2731593 | 2021-07-17 04:22:22 | Calloway, Kentucky, US | |
298483 | 298483 | 2021-07-15 | US | Ohio | Highland | 39071 | 3625 | 68 | 0 | 39.1839264 | -83.60331456 | 2021-07-16 04:21:22 | Highland, Ohio, US |
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]);