johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
122 rows where confirmed = 5392 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 116
- Iceland 1
- India 1
- Mongolia 1
- Peru 1
- Trinidad and Tobago 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310737 | 310737 | 2022-12-13 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-14 04:21:04 | Beadle, South Dakota, US | |
1151798 | 1151798 | 2022-12-12 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-13 04:21:01 | Beadle, South Dakota, US | |
871652 | 871652 | 2022-12-11 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-12 04:21:01 | Beadle, South Dakota, US | |
260182 | 260182 | 2022-12-10 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-11 04:20:50 | Beadle, South Dakota, US | |
3938896 | 3938896 | 2022-12-09 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-10 04:21:02 | Beadle, South Dakota, US | |
3380228 | 3380228 | 2022-12-08 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-09 04:21:05 | Beadle, South Dakota, US | |
1987499 | 1987499 | 2022-12-07 | US | South Dakota | Beadle | 46005 | 5392 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-12-08 04:21:07 | Beadle, South Dakota, US | |
2559349 | 2559349 | 2022-11-29 | US | Puerto Rico | Loiza | 72087 | 5392 | 0 | 0 | 18.425688 | -65.89943 | 2022-11-30 04:21:07 | Loiza, Puerto Rico, US | |
483096 | 483096 | 2022-11-08 | US | West Virginia | Monroe | 54063 | 5392 | 49 | 0 | 37.56274716 | -80.54577965 | 2022-11-09 04:21:22 | Monroe, West Virginia, US | |
2442246 | 2442246 | 2022-11-07 | US | West Virginia | Monroe | 54063 | 5392 | 49 | 0 | 37.56274716 | -80.54577965 | 2022-11-08 04:21:21 | Monroe, West Virginia, US | |
1832893 | 1832893 | 2022-10-25 | US | Puerto Rico | Comerio | 72045 | 5392 | 0 | 0 | 18.224687 | -66.221622 | 2022-10-26 04:22:19 | Comerio, Puerto Rico, US | |
2273938 | 2273938 | 2022-10-20 | US | Montana | Lincoln | 30053 | 5392 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-10-21 04:22:23 | Lincoln, Montana, US | |
200273 | 200273 | 2022-10-19 | US | Montana | Lincoln | 30053 | 5392 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-10-20 04:22:59 | Lincoln, Montana, US | |
2758934 | 2758934 | 2022-10-18 | US | Montana | Lincoln | 30053 | 5392 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-10-19 04:22:26 | Lincoln, Montana, US | |
2026768 | 2026768 | 2022-10-17 | US | Montana | Lincoln | 30053 | 5392 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-10-18 04:22:42 | Lincoln, Montana, US | |
1811157 | 1811157 | 2022-10-05 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-06 04:21:22 | Henry, Alabama, US | |
131131 | 131131 | 2022-10-04 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-05 04:23:06 | Henry, Alabama, US | |
2686078 | 2686078 | 2022-10-03 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-04 04:22:55 | Henry, Alabama, US | |
2260145 | 2260145 | 2022-10-02 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-03 04:23:11 | Henry, Alabama, US | |
2995671 | 2995671 | 2022-10-01 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-02 04:21:23 | Henry, Alabama, US | |
853997 | 853997 | 2022-09-30 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-10-01 04:23:01 | Henry, Alabama, US | |
2375923 | 2375923 | 2022-09-29 | US | Alabama | Henry | 1067 | 5392 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-09-30 04:23:09 | Henry, Alabama, US | |
3997331 | 3997331 | 2022-09-27 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-28 04:23:01 | Montour, Pennsylvania, US | |
2771659 | 2771659 | 2022-09-26 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-27 04:23:01 | Montour, Pennsylvania, US | |
1979312 | 1979312 | 2022-09-25 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-26 04:20:52 | Montour, Pennsylvania, US | |
2652479 | 2652479 | 2022-09-24 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-25 04:23:31 | Montour, Pennsylvania, US | |
386919 | 386919 | 2022-09-23 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-24 04:21:40 | Montour, Pennsylvania, US | |
1626985 | 1626985 | 2022-09-22 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-23 04:23:13 | Montour, Pennsylvania, US | |
1373189 | 1373189 | 2022-09-21 | US | Pennsylvania | Montour | 42093 | 5392 | 94 | 0 | 41.03023987 | -76.66345939 | 2022-09-22 04:22:56 | Montour, Pennsylvania, US | |
3574187 | 3574187 | 2022-09-19 | US | Wisconsin | Taylor | 55119 | 5392 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-09-20 04:22:48 | Taylor, Wisconsin, US | |
3827169 | 3827169 | 2022-09-10 | US | Puerto Rico | Adjuntas | 72001 | 5392 | 0 | 0 | 18.180117 | -66.754367 | 2022-09-11 04:20:50 | Adjuntas, Puerto Rico, US | |
965626 | 965626 | 2022-09-09 | US | Puerto Rico | Adjuntas | 72001 | 5392 | 0 | 0 | 18.180117 | -66.754367 | 2022-09-10 04:21:10 | Adjuntas, Puerto Rico, US | |
2789695 | 2789695 | 2022-07-10 | US | Colorado | Teller | 8119 | 5392 | 58 | 0 | 38.88133511 | -105.1614893 | 2022-07-11 04:20:46 | Teller, Colorado, US | |
3942991 | 3942991 | 2022-06-30 | US | Tennessee | Crockett | 47033 | 5392 | 88 | 0 | 35.81830662 | -89.14916269 | 2022-07-01 04:21:10 | Crockett, Tennessee, US | |
3400145 | 3400145 | 2022-06-18 | US | Puerto Rico | Anasco | 72011 | 5392 | 0 | 0 | 18.287985 | -67.120611 | 2022-06-19 04:20:51 | Anasco, Puerto Rico, US | |
3158137 | 3158137 | 2022-06-09 | US | Arkansas | Lawrence | 5075 | 5392 | 81 | 0 | 36.04188196 | -91.10867198 | 2022-06-10 04:20:55 | Lawrence, Arkansas, US | |
3891211 | 3891211 | 2022-06-06 | US | Wisconsin | Vilas | 55125 | 5392 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-06-07 04:21:08 | Vilas, Wisconsin, US | |
2332434 | 2332434 | 2022-05-08 | US | Illinois | Union | 17181 | 5392 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-05-09 04:20:54 | Union, Illinois, US | |
361396 | 361396 | 2022-05-07 | US | Illinois | Union | 17181 | 5392 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-05-08 04:20:49 | Union, Illinois, US | |
1398747 | 1398747 | 2022-05-06 | US | Illinois | Union | 17181 | 5392 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-05-07 04:21:09 | Union, Illinois, US | |
3268828 | 3268828 | 2022-05-04 | US | Virginia | Dinwiddie | 51053 | 5392 | 93 | 0 | 37.07544585 | -77.63451754 | 2022-05-05 04:20:55 | Dinwiddie, Virginia, US | |
158830 | 158830 | 2022-03-29 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-30 04:20:45 | Haralson, Georgia, US | |
1437401 | 1437401 | 2022-03-28 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-29 04:20:46 | Haralson, Georgia, US | |
877082 | 877082 | 2022-03-27 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-28 04:20:33 | Haralson, Georgia, US | |
2164365 | 2164365 | 2022-03-26 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-27 04:20:47 | Haralson, Georgia, US | |
1721301 | 1721301 | 2022-03-25 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-26 04:20:23 | Haralson, Georgia, US | |
1468918 | 1468918 | 2022-03-24 | US | Georgia | Haralson | 13143 | 5392 | 165 | 0 | 33.79602175 | -85.21005667 | 2022-03-25 04:20:46 | Haralson, Georgia, US | |
3023092 | 3023092 | 2022-03-23 | US | Georgia | Haralson | 13143 | 5392 | 164 | 0 | 33.79602175 | -85.21005667 | 2022-03-24 04:20:43 | Haralson, Georgia, US | |
953646 | 953646 | 2022-03-12 | US | Puerto Rico | San Sebastian | 72131 | 5392 | 0 | 0 | 18.328646 | -66.971214 | 2022-03-13 04:20:49 | San Sebastian, Puerto Rico, US | |
2092611 | 2092611 | 2022-03-05 | US | Arkansas | Ouachita | 5103 | 5392 | 95 | 0 | 33.58839816 | -92.87795984 | 2022-03-06 04:20:49 | Ouachita, Arkansas, US | |
3048706 | 3048706 | 2022-02-26 | US | Ohio | Wyandot | 39175 | 5392 | 103 | 0 | 40.84339621 | -83.30734173 | 2022-02-27 04:21:04 | Wyandot, Ohio, US | |
577361 | 577361 | 2022-02-25 | US | Ohio | Wyandot | 39175 | 5392 | 102 | 0 | 40.84339621 | -83.30734173 | 2022-02-26 04:21:12 | Wyandot, Ohio, US | |
1511885 | 1511885 | 2022-02-24 | US | Arkansas | Conway | 5029 | 5392 | 58 | 0 | 35.26205537 | -92.70506566 | 2022-02-25 04:21:11 | Conway, Arkansas, US | |
189163 | 189163 | 2022-02-13 | US | Texas | Frio | 48163 | 5392 | 85 | 0 | 28.86751206 | -99.10804207 | 2022-02-14 04:20:51 | Frio, Texas, US | |
186931 | 186931 | 2022-02-13 | US | Georgia | Pierce | 13229 | 5392 | 116 | 0 | 31.35928155 | -82.21598442 | 2022-02-14 04:20:51 | Pierce, Georgia, US | |
316777 | 316777 | 2022-02-12 | US | Georgia | Pierce | 13229 | 5392 | 116 | 0 | 31.35928155 | -82.21598442 | 2022-02-13 04:21:00 | Pierce, Georgia, US | |
234103 | 234103 | 2022-02-11 | US | Georgia | Pierce | 13229 | 5392 | 116 | 0 | 31.35928155 | -82.21598442 | 2022-02-12 04:21:06 | Pierce, Georgia, US | |
1365505 | 1365505 | 2022-02-08 | US | Texas | Lampasas | 48281 | 5392 | 78 | 0 | 31.19531316 | -98.24206613 | 2022-02-09 04:21:04 | Lampasas, Texas, US | |
1364145 | 1364145 | 2022-02-08 | US | Mississippi | Chickasaw | 28017 | 5392 | 85 | 0 | 33.91983202 | -88.9481545 | 2022-02-09 04:21:04 | Chickasaw, Mississippi, US | |
2475401 | 2475401 | 2022-02-03 | US | Kentucky | Meade | 21163 | 5392 | 59 | 0 | 37.96163597 | -86.21028219 | 2022-02-04 04:21:10 | Meade, Kentucky, US | |
3230008 | 3230008 | 2022-01-19 | US | Wisconsin | Kewaunee | 55061 | 5392 | 51 | 0 | 44.51727459 | -87.61468386 | 2022-01-20 04:21:07 | Kewaunee, Wisconsin, US | |
3229971 | 3229971 | 2022-01-19 | US | West Virginia | Upshur | 54097 | 5392 | 77 | 0 | 38.89285061 | -80.23689136 | 2022-01-20 04:21:07 | Upshur, West Virginia, US | |
128363 | 128363 | 2022-01-09 | US | Michigan | Dickinson | 26043 | 5392 | 94 | 0 | 46.00999672 | -87.86961634 | 2022-01-10 04:22:07 | Dickinson, Michigan, US | |
1217198 | 1217198 | 2022-01-08 | US | Michigan | Dickinson | 26043 | 5392 | 94 | 0 | 46.00999672 | -87.86961634 | 2022-01-09 04:21:46 | Dickinson, Michigan, US | |
1391291 | 1391291 | 2022-01-07 | US | Michigan | Dickinson | 26043 | 5392 | 94 | 0 | 46.00999672 | -87.86961634 | 2022-01-08 04:21:53 | Dickinson, Michigan, US | |
2963757 | 2963757 | 2021-12-24 | US | Alabama | Dallas | 1047 | 5392 | 212 | 0 | 32.32688101 | -87.10866709999998 | 2021-12-25 04:21:37 | Dallas, Alabama, US | |
1255739 | 1255739 | 2021-12-20 | US | Illinois | Bureau | 17011 | 5392 | 103 | 0 | 41.40385234 | -89.5283051 | 2021-12-21 03:21:27 | Bureau, Illinois, US | |
784889 | 784889 | 2021-12-13 | US | Ohio | Morrow | 39117 | 5392 | 72 | 0 | 40.52363560000001 | -82.7892599 | 2021-12-14 04:22:38 | Morrow, Ohio, US | |
1661861 | 1661861 | 2021-12-12 | US | Kentucky | Logan | 21141 | 5392 | 95 | 0 | 36.85949479 | -86.877635 | 2021-12-13 04:22:02 | Logan, Kentucky, US | |
406031 | 406031 | 2021-12-07 | US | Minnesota | Lyon | 27083 | 5392 | 62 | 0 | 44.41327865 | -95.83806103 | 2021-12-08 04:22:46 | Lyon, Minnesota, US | |
1033435 | 1033435 | 2021-12-06 | US | Texas | Cooke | 48097 | 5392 | 105 | 0 | 33.63979567 | -97.21240912 | 2021-12-07 04:22:34 | Cooke, Texas, US | |
152008 | 152008 | 2021-11-29 | US | Montana | Ravalli | 30081 | 5392 | 72 | 0 | 46.08520862 | -114.11891640000002 | 2021-11-30 04:22:53 | Ravalli, Montana, US | |
3070419 | 3070419 | 2021-11-23 | US | Alabama | Marion | 1093 | 5392 | 129 | 0 | 34.13697363 | -87.88704173 | 2021-11-24 04:22:14 | Marion, Alabama, US | |
1016789 | 1016789 | 2021-11-21 | US | Ohio | Coshocton | 39031 | 5392 | 108 | 0 | 40.30096166 | -81.91729018 | 2021-11-22 04:22:20 | Coshocton, Ohio, US | |
689017 | 689017 | 2021-11-13 | US | Pennsylvania | Clarion | 42031 | 5392 | 131 | 0 | 41.19265812 | -79.42413524 | 2021-11-14 04:21:31 | Clarion, Pennsylvania, US | |
2848174 | 2848174 | 2021-11-10 | US | Virginia | Charlottesville | 51540 | 5392 | 59 | 0 | 38.03527919 | -78.48569588 | 2021-11-11 04:21:45 | Charlottesville, Virginia, US | |
90444 | 90444 | 2021-11-09 | US | Virginia | Charlottesville | 51540 | 5392 | 59 | 0 | 38.03527919 | -78.48569588 | 2021-11-10 04:21:38 | Charlottesville, Virginia, US | |
88514 | 88514 | 2021-11-09 | US | Kentucky | Clark | 21049 | 5392 | 42 | 0 | 37.9689263 | -84.14615986 | 2021-11-10 04:21:38 | Clark, Kentucky, US | |
3494868 | 3494868 | 2021-10-26 | US | Pennsylvania | Pike | 42103 | 5392 | 61 | 0 | 41.33155042 | -75.03208106 | 2021-10-27 04:22:32 | Pike, Pennsylvania, US | |
426870 | 426870 | 2021-10-10 | US | West Virginia | Wayne | 54099 | 5392 | 63 | 0 | 38.14901357 | -82.42287994 | 2021-10-11 04:21:31 | Wayne, West Virginia, US | |
2878676 | 2878676 | 2021-10-09 | US | Ohio | Guernsey | 39059 | 5392 | 71 | 0 | 40.05026529 | -81.49248905 | 2021-10-10 04:21:38 | Guernsey, Ohio, US | |
2960947 | 2960947 | 2021-10-08 | US | Maryland | Calvert | 24009 | 5392 | 98 | 0 | 38.53961642 | -76.56820632 | 2021-10-09 04:21:34 | Calvert, Maryland, US | |
989076 | 989076 | 2021-10-04 | US | Nebraska | Madison | 31119 | 5392 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-05 04:21:27 | Madison, Nebraska, US | |
3931048 | 3931048 | 2021-10-02 | US | Tennessee | White | 47185 | 5392 | 91 | 0 | 35.92929884 | -85.45591799 | 2021-10-03 04:21:24 | White, Tennessee, US | |
1236498 | 1236498 | 2021-09-27 | US | Georgia | Oconee | 13219 | 5392 | 78 | 0 | 33.83749973 | -83.43679568 | 2021-09-28 04:21:28 | Oconee, Georgia, US | |
1388862 | 1388862 | 2021-09-13 | US | Texas | Titus | 48449 | 5392 | 90 | 0 | 33.21339719 | -94.96797273 | 2021-09-14 04:21:41 | Titus, Texas, US | |
1888231 | 1888231 | 2021-09-12 | US | Texas | Titus | 48449 | 5392 | 90 | 0 | 33.21339719 | -94.96797273 | 2021-09-13 04:21:15 | Titus, Texas, US | |
3809134 | 3809134 | 2021-09-11 | US | Texas | Titus | 48449 | 5392 | 90 | 0 | 33.21339719 | -94.96797273 | 2021-09-12 04:21:13 | Titus, Texas, US | |
3197656 | 3197656 | 2021-09-06 | United Kingdom | Gibraltar | 5392 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-07 04:21:35 | Gibraltar, United Kingdom | |||
1599562 | 1599562 | 2021-08-26 | US | Virginia | James City | 51095 | 5392 | 77 | 0 | 37.31156958 | -76.76950618 | 2021-08-27 04:21:37 | James City, Virginia, US | |
247506 | 247506 | 2021-08-17 | US | New York | Herkimer | 36043 | 5392 | 110 | 0 | 43.42034246 | -74.96145307 | 2021-08-18 04:21:35 | Herkimer, New York, US | |
3221877 | 3221877 | 2021-07-26 | US | Wisconsin | Shawano | 55115 | 5392 | 85 | 0 | 44.78902246 | -88.76443896 | 2021-07-27 04:21:18 | Shawano, Wisconsin, US | |
2423441 | 2423441 | 2021-06-23 | US | California | Lassen | 6035 | 5392 | 19 | 0 | 40.67311306 | -120.59350990000002 | 2021-06-24 04:21:55 | Lassen, California, US | |
3677175 | 3677175 | 2021-05-04 | US | Louisiana | St. Charles | 22089 | 5392 | 94 | 0 | 29.90709658 | -90.35555967 | 2021-05-05 04:20:43 | St. Charles, Louisiana, US | |
2762442 | 2762442 | 2021-05-03 | US | Louisiana | St. Charles | 22089 | 5392 | 93 | 0 | 29.90709658 | -90.35555967 | 2021-05-04 04:20:34 | St. Charles, Louisiana, US | |
2573913 | 2573913 | 2021-04-13 | US | New York | Jefferson | 36045 | 5392 | 63 | 0 | 44.04200959 | -75.94653457 | 2021-04-14 04:20:41 | Jefferson, New York, US | |
388576 | 388576 | 2021-04-04 | US | Alabama | Coffee | 1031 | 5392 | 112 | 0 | 31.39932826 | -85.98901039 | 2021-04-05 04:20:35 | Coffee, Alabama, US | |
1304525 | 1304525 | 2021-04-01 | US | Ohio | Lawrence | 39087 | 5392 | 101 | 0 | 38.59743452 | -82.53466552 | 2021-04-02 04:20:36 | Lawrence, Ohio, US | |
1798749 | 1798749 | 2021-03-23 | Mongolia | 5392 | 5 | 3947 | 1658 | 46.8625 | 103.8467 | 2021-03-24 05:25:40 | Mongolia | |||
3670587 | 3670587 | 2021-03-06 | US | Tennessee | Monroe | 47123 | 5392 | 91 | 0 | 5304 | 35.44550387 | -84.24902965 | 2021-03-07 05:21:54 | Monroe, Tennessee, 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]);