participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,016 rows where station_code = "US0037" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5134276 | 5134276 | 20240916074555_C1oay | US0037 | 2024-09-19T12:17:34.960Z | 2024-09-19T12:17:34.960Z |
5134234 | 5134234 | 20240916072100_ziBE1 | US0037 | 2024-09-19T12:17:32.755Z | 2024-09-19T12:17:32.755Z |
5122712 | 5122712 | 20240914073555_9uFt2 | US0037 | 2024-09-18T12:11:29.106Z | 2024-09-19T12:20:05.827Z |
5122436 | 5122436 | 20240914062222_4rbFF | US0037 | 2024-09-18T12:11:18.383Z | 2024-09-19T12:20:04.337Z |
5122297 | 5122297 | 20240914052825_S0oM6 | US0037 | 2024-09-18T12:11:13.271Z | 2024-09-19T12:20:03.768Z |
5122226 | 5122226 | 20240914050231_cJeu3 | US0037 | 2024-09-18T12:11:10.821Z | 2024-09-19T12:20:03.305Z |
5120746 | 5120746 | 20240914033435_ejHdR | US0037 | 2024-09-18T12:10:46.528Z | 2024-09-19T12:20:00.847Z |
5118426 | 5118426 | 20240915094506_ZckM9 | US0037 | 2024-09-18T12:08:43.530Z | 2024-09-19T12:19:22.778Z |
5118368 | 5118368 | 20240915092922_pvRyg | US0037 | 2024-09-18T12:08:40.559Z | 2024-09-19T12:19:22.378Z |
5118203 | 5118203 | 20240915085122_iFDCv | US0037 | 2024-09-18T12:08:29.821Z | 2024-09-19T12:19:21.257Z |
5118133 | 5118133 | 20240915084029_zZlZQ | US0037 | 2024-09-18T12:08:26.267Z | 2024-09-19T12:19:20.712Z |
5118082 | 5118082 | 20240915082749_FqosZ | US0037 | 2024-09-18T12:08:22.527Z | 2024-09-19T12:19:20.221Z |
5118044 | 5118044 | 20240915081507_TEh3m | US0037 | 2024-09-18T12:08:20.474Z | 2024-09-19T12:19:19.936Z |
5117958 | 5117958 | 20240915075739_zyDbG | US0037 | 2024-09-18T12:08:11.636Z | 2024-09-19T12:19:19.325Z |
5117813 | 5117813 | 20240915070811_Ia0He | US0037 | 2024-09-18T12:08:01.086Z | 2024-09-19T12:19:18.165Z |
5117720 | 5117720 | 20240915063604_pwjxj | US0037 | 2024-09-18T12:07:53.468Z | 2024-09-19T12:19:17.212Z |
5108933 | 5108933 | 20240913080708_IoUu1 | US0037 | 2024-09-17T12:14:19.338Z | 2024-09-19T12:20:51.204Z |
5108863 | 5108863 | 20240913074857_EufOv | US0037 | 2024-09-17T12:14:11.246Z | 2024-09-19T12:20:50.959Z |
5108736 | 5108736 | 20240913071403_M43JA | US0037 | 2024-09-17T12:14:02.386Z | 2024-09-19T12:20:50.541Z |
5108489 | 5108489 | 20240913055809_f2X2u | US0037 | 2024-09-17T12:13:47.458Z | 2024-09-19T12:20:49.030Z |
5108435 | 5108435 | 20240913053210_R4fwh | US0037 | 2024-09-17T12:13:44.628Z | 2024-09-19T12:20:48.825Z |
5108399 | 5108399 | 20240913052516_VyssV | US0037 | 2024-09-17T12:13:42.844Z | 2024-09-19T12:20:48.673Z |
5106753 | 5106753 | 20240913033332_RhcyN | US0037 | 2024-09-17T12:13:00.693Z | 2024-09-19T12:20:46.381Z |
5106004 | 5106004 | 20240913030603_7eIxp | US0037 | 2024-09-17T12:12:37.078Z | 2024-09-19T12:20:45.128Z |
5095459 | 5095459 | 20240912073934_A81sW | US0037 | 2024-09-16T12:15:41.251Z | 2024-09-19T12:21:18.585Z |
5095399 | 5095399 | 20240912072819_xRmvs | US0037 | 2024-09-16T12:15:38.815Z | 2024-09-19T12:21:18.412Z |
5095312 | 5095312 | 20240912071139_NA1cw | US0037 | 2024-09-16T12:15:31.955Z | 2024-09-19T12:21:18.091Z |
5095127 | 5095127 | 20240912060507_aFVPV | US0037 | 2024-09-16T12:15:17.159Z | 2024-09-19T12:21:17.308Z |
5095125 | 5095125 | 20240912060505_IvNNF | US0037 | 2024-09-16T12:15:17.063Z | 2024-09-19T12:21:17.307Z |
5094988 | 5094988 | 20240912050144_K3E9U | US0037 | 2024-09-16T12:15:07.610Z | 2024-09-19T12:21:16.858Z |
5082066 | 5082066 | 20240911091707_2A6i0 | US0037 | 2024-09-15T12:18:01.068Z | 2024-09-19T12:21:47.141Z |
5082062 | 5082062 | 20240911091644_3wQDr | US0037 | 2024-09-15T12:18:00.997Z | 2024-09-19T12:21:47.130Z |
5082004 | 5082004 | 20240911091147_UwioT | US0037 | 2024-09-15T12:17:58.963Z | 2024-09-19T12:21:46.964Z |
5081882 | 5081882 | 20240911085755_Xd2O2 | US0037 | 2024-09-15T12:17:53.162Z | 2024-09-19T12:21:46.625Z |
5081556 | 5081556 | 20240911080136_FLrCC | US0037 | 2024-09-15T12:17:37.759Z | 2024-09-19T12:21:45.727Z |
5081530 | 5081530 | 20240911075617_l2A2D | US0037 | 2024-09-15T12:17:36.879Z | 2024-09-19T12:21:45.638Z |
5081263 | 5081263 | 20240911070928_gWcSX | US0037 | 2024-09-15T12:17:28.371Z | 2024-09-19T12:21:44.938Z |
5081129 | 5081129 | 20240911064035_eNFVO | US0037 | 2024-09-15T12:17:24.671Z | 2024-09-19T12:21:44.664Z |
5081008 | 5081008 | 20240911055909_K0H32 | US0037 | 2024-09-15T12:17:20.345Z | 2024-09-19T12:21:44.370Z |
5080974 | 5080974 | 20240911054851_n4GGB | US0037 | 2024-09-15T12:17:18.964Z | 2024-09-19T12:21:44.156Z |
5080819 | 5080819 | 20240911045551_XA0pe | US0037 | 2024-09-15T12:17:14.425Z | 2024-09-19T12:21:43.711Z |
5078978 | 5078978 | 20240911022743_ATNpd | US0037 | 2024-09-15T12:16:01.342Z | 2024-09-19T12:21:40.951Z |
5067465 | 5067465 | 20240910093505_13FOV | US0037 | 2024-09-14T12:18:44.588Z | 2024-09-18T12:15:24.166Z |
5067238 | 5067238 | 20240910091003_1RwOn | US0037 | 2024-09-14T12:18:36.959Z | 2024-09-18T12:15:23.668Z |
5067212 | 5067212 | 20240910090741_vp2bt | US0037 | 2024-09-14T12:18:35.915Z | 2024-09-18T12:15:23.597Z |
5067169 | 5067169 | 20240910090235_XGsvb | US0037 | 2024-09-14T12:18:34.556Z | 2024-09-18T12:15:23.522Z |
5066578 | 5066578 | 20240910075140_afCS2 | US0037 | 2024-09-14T12:18:03.360Z | 2024-09-18T12:15:22.245Z |
5066549 | 5066549 | 20240910074838_yKgam | US0037 | 2024-09-14T12:18:02.286Z | 2024-09-18T12:15:22.161Z |
5066189 | 5066189 | 20240910064943_tGrqz | US0037 | 2024-09-14T12:17:44.070Z | 2024-09-18T12:15:21.348Z |
5066143 | 5066143 | 20240910064339_HSLuD | US0037 | 2024-09-14T12:17:41.720Z | 2024-09-18T12:15:21.240Z |
5066127 | 5066127 | 20240910064126_cDItx | US0037 | 2024-09-14T12:17:40.175Z | 2024-09-18T12:15:21.215Z |
5065993 | 5065993 | 20240910061433_vsT3L | US0037 | 2024-09-14T12:17:34.018Z | 2024-09-18T12:15:20.956Z |
5065894 | 5065894 | 20240910055702_6fv9r | US0037 | 2024-09-14T12:17:27.232Z | 2024-09-18T12:15:20.639Z |
5065829 | 5065829 | 20240910054436_2j3gW | US0037 | 2024-09-14T12:17:25.089Z | 2024-09-18T12:15:20.492Z |
5065645 | 5065645 | 20240910045925_qicSS | US0037 | 2024-09-14T12:17:16.484Z | 2024-09-18T12:15:20.063Z |
5064939 | 5064939 | 20240910023738_zHWTN | US0037 | 2024-09-14T12:16:11.195Z | 2024-09-18T12:15:17.855Z |
5055756 | 5055756 | 20240908085400_GODKt | US0037 | 2024-09-13T12:17:21.453Z | 2024-09-16T12:21:21.860Z |
5055668 | 5055668 | 20240908083635_upSiO | US0037 | 2024-09-13T12:17:19.584Z | 2024-09-16T12:21:21.462Z |
5055570 | 5055570 | 20240908082401_Cvu8V | US0037 | 2024-09-13T12:17:17.374Z | 2024-09-16T12:21:20.383Z |
5055442 | 5055442 | 20240908080346_Mgnln | US0037 | 2024-09-13T12:17:13.896Z | 2024-09-16T12:21:19.800Z |
5055425 | 5055425 | 20240908080146_QtpSW | US0037 | 2024-09-13T12:17:12.456Z | 2024-09-16T12:21:19.623Z |
5055325 | 5055325 | 20240908074845_ZJDig | US0037 | 2024-09-13T12:17:09.866Z | 2024-09-16T12:21:18.796Z |
5055239 | 5055239 | 20240908073051_ey6vR | US0037 | 2024-09-13T12:17:08.269Z | 2024-09-16T12:21:18.517Z |
5055229 | 5055229 | 20240908072947_D3qEB | US0037 | 2024-09-13T12:17:08.164Z | 2024-09-16T12:21:18.502Z |
5055182 | 5055182 | 20240908071626_sdAa8 | US0037 | 2024-09-13T12:17:07.282Z | 2024-09-16T12:21:18.294Z |
5055176 | 5055176 | 20240908071205_SXjMS | US0037 | 2024-09-13T12:17:07.013Z | 2024-09-16T12:21:18.277Z |
5055117 | 5055117 | 20240908064925_OrVX2 | US0037 | 2024-09-13T12:17:05.507Z | 2024-09-16T12:21:17.966Z |
5055033 | 5055033 | 20240908061647_l4zd2 | US0037 | 2024-09-13T12:17:03.944Z | 2024-09-16T12:21:17.762Z |
5055003 | 5055003 | 20240908060002_w9f00 | US0037 | 2024-09-13T12:17:01.870Z | 2024-09-16T12:21:17.642Z |
5054970 | 5054970 | 20240908054847_iel5S | US0037 | 2024-09-13T12:17:00.567Z | 2024-09-16T12:21:17.487Z |
5054933 | 5054933 | 20240908052943_bmJqA | US0037 | 2024-09-13T12:16:59.873Z | 2024-09-16T12:21:17.255Z |
5054846 | 5054846 | 20240908042820_2EQ37 | US0037 | 2024-09-13T12:16:56.927Z | 2024-09-16T12:21:17.008Z |
5054838 | 5054838 | 20240908042512_5Ux43 | US0037 | 2024-09-13T12:16:56.779Z | 2024-09-16T12:21:16.997Z |
5054689 | 5054689 | 20240908033731_jmtq5 | US0037 | 2024-09-13T12:16:52.054Z | 2024-09-16T12:21:16.638Z |
5054654 | 5054654 | 20240908032939_e6X5L | US0037 | 2024-09-13T12:16:51.015Z | 2024-09-16T12:21:16.406Z |
5054637 | 5054637 | 20240908032715_4HK9W | US0037 | 2024-09-13T12:16:50.670Z | 2024-09-16T12:21:16.370Z |
5053459 | 5053459 | 20240908003829_C8KjI | US0037 | 2024-09-13T12:16:04.915Z | 2024-09-16T12:21:11.291Z |
5048877 | 5048877 | 20240909092313_F7jvy | US0037 | 2024-09-13T12:11:20.556Z | 2024-09-17T12:19:08.561Z |
5048860 | 5048860 | 20240909092135_9IZ0u | US0037 | 2024-09-13T12:11:19.489Z | 2024-09-17T12:19:08.543Z |
5048730 | 5048730 | 20240909090138_nGr64 | US0037 | 2024-09-13T12:11:12.398Z | 2024-09-17T12:19:08.175Z |
5048515 | 5048515 | 20240909082324_ihald | US0037 | 2024-09-13T12:10:45.918Z | 2024-09-17T12:19:07.303Z |
5048493 | 5048493 | 20240909081725_LxVvJ | US0037 | 2024-09-13T12:10:41.346Z | 2024-09-17T12:19:07.222Z |
5048363 | 5048363 | 20240909075249_axDWm | US0037 | 2024-09-13T12:10:30.370Z | 2024-09-17T12:19:06.623Z |
5048272 | 5048272 | 20240909073341_NKWAP | US0037 | 2024-09-13T12:10:24.489Z | 2024-09-17T12:19:06.222Z |
5048135 | 5048135 | 20240909070924_ZZSID | US0037 | 2024-09-13T12:10:16.919Z | 2024-09-17T12:19:05.876Z |
5048103 | 5048103 | 20240909070607_0c72v | US0037 | 2024-09-13T12:10:15.344Z | 2024-09-17T12:19:05.716Z |
5048065 | 5048065 | 20240909065929_l8FxL | US0037 | 2024-09-13T12:10:13.274Z | 2024-09-17T12:19:05.505Z |
5047578 | 5047578 | 20240909044914_ctiM2 | US0037 | 2024-09-13T12:09:25.494Z | 2024-09-17T12:19:03.187Z |
5047220 | 5047220 | 20240909030719_LB0mG | US0037 | 2024-09-13T12:08:40.461Z | 2024-09-17T12:19:01.724Z |
5047076 | 5047076 | 20240909023512_EP0u2 | US0037 | 2024-09-13T12:08:14.846Z | 2024-09-17T12:19:01.022Z |
5046853 | 5046853 | 20240909013846_G2EQ2 | US0037 | 2024-09-13T12:07:39.330Z | 2024-09-17T12:19:00.495Z |
5046768 | 5046768 | 20240909011734_zXl8P | US0037 | 2024-09-13T12:07:28.823Z | 2024-09-17T12:19:00.293Z |
4957162 | 4957162 | 20240811081554_aUPUQ | US0037 | 2024-09-03T12:20:53.061Z | 2024-09-06T12:31:07.100Z |
4956903 | 4956903 | 20240811075934_jCWKN | US0037 | 2024-09-03T12:20:42.724Z | 2024-09-06T12:30:54.132Z |
4956686 | 4956686 | 20240811074005_BlTf5 | US0037 | 2024-09-03T12:20:35.806Z | 2024-09-06T12:30:43.479Z |
4956548 | 4956548 | 20240811073030_mpkQo | US0037 | 2024-09-03T12:20:31.322Z | 2024-09-06T12:30:37.782Z |
4956487 | 4956487 | 20240811072500_EFOMN | US0037 | 2024-09-03T12:20:29.249Z | 2024-09-06T12:30:35.220Z |
4956416 | 4956416 | 20240811071556_Tty4r | US0037 | 2024-09-03T12:20:23.400Z | 2024-09-06T12:30:31.036Z |
4956411 | 4956411 | 20240811071545_E21pb | US0037 | 2024-09-03T12:20:23.100Z | 2024-09-06T12:30:30.751Z |
4956254 | 4956254 | 20240811070103_qG3kt | US0037 | 2024-09-03T12:20:07.995Z | 2024-09-06T12:30:22.654Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);