participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
80 rows where station_code = "NZ004U" 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 |
---|---|---|---|---|---|
5569472 | 5569472 | 20241121153609_J0S4e | NZ004U | 2024-11-22T14:10:55.599Z | 2024-11-22T14:10:55.599Z |
5569411 | 5569411 | 20241121152543_Uijd1 | NZ004U | 2024-11-22T14:10:51.255Z | 2024-11-22T14:10:51.255Z |
5569283 | 5569283 | 20241121150418_cquL0 | NZ004U | 2024-11-22T14:10:43.543Z | 2024-11-22T14:10:43.543Z |
5569276 | 5569276 | 20241121150353_T3ogZ | NZ004U | 2024-11-22T14:10:43.379Z | 2024-11-22T14:10:43.379Z |
5569189 | 5569189 | 20241121144922_snSP3 | NZ004U | 2024-11-22T14:10:28.972Z | 2024-11-22T14:10:28.972Z |
5569169 | 5569169 | 20241121144551_Tv8R5 | NZ004U | 2024-11-22T14:10:25.952Z | 2024-11-22T14:10:25.952Z |
5569138 | 5569138 | 20241121144015_IjYio | NZ004U | 2024-11-22T14:10:23.278Z | 2024-11-22T14:10:23.278Z |
5569131 | 5569131 | 20241121144014_WXvPf | NZ004U | 2024-11-22T14:10:22.901Z | 2024-11-22T14:10:22.901Z |
5569121 | 5569121 | 20241121143808_FthPx | NZ004U | 2024-11-22T14:10:22.160Z | 2024-11-22T14:10:22.160Z |
5569040 | 5569040 | 20241121142404_PMi3h | NZ004U | 2024-11-22T14:10:13.775Z | 2024-11-22T14:10:13.775Z |
5569006 | 5569006 | 20241121141731_3unle | NZ004U | 2024-11-22T14:10:10.445Z | 2024-11-22T14:10:10.445Z |
5568999 | 5568999 | 20241121141415_NBYT3 | NZ004U | 2024-11-22T14:10:09.780Z | 2024-11-22T14:10:09.780Z |
5568815 | 5568815 | 20241121134223_jZLb7 | NZ004U | 2024-11-22T14:09:48.434Z | 2024-11-22T14:09:48.434Z |
5568761 | 5568761 | 20241121133044_KvoHH | NZ004U | 2024-11-22T14:09:40.370Z | 2024-11-22T14:09:40.370Z |
5568684 | 5568684 | 20241121132041_ZgUGv | NZ004U | 2024-11-22T14:09:33.069Z | 2024-11-22T14:09:33.069Z |
5568615 | 5568615 | 20241121131127_a10FS | NZ004U | 2024-11-22T14:09:26.045Z | 2024-11-22T14:09:26.045Z |
5568606 | 5568606 | 20241121131041_uHFhH | NZ004U | 2024-11-22T14:09:25.297Z | 2024-11-22T14:09:25.297Z |
5568581 | 5568581 | 20241121130621_BVzTr | NZ004U | 2024-11-22T14:09:22.953Z | 2024-11-22T14:09:22.953Z |
5568315 | 5568315 | 20241121122252_1kLHu | NZ004U | 2024-11-22T14:08:41.506Z | 2024-11-22T14:08:41.506Z |
5568148 | 5568148 | 20241121115527_hBX1A | NZ004U | 2024-11-22T14:08:12.889Z | 2024-11-22T14:08:12.889Z |
5568091 | 5568091 | 20241121114655_aZQI8 | NZ004U | 2024-11-22T14:08:04.696Z | 2024-11-22T14:08:04.696Z |
5568079 | 5568079 | 20241121114611_7u4D7 | NZ004U | 2024-11-22T14:08:03.786Z | 2024-11-22T14:08:03.786Z |
5567771 | 5567771 | 20241121110412_Jt2DF | NZ004U | 2024-11-22T14:07:14.285Z | 2024-11-22T14:07:14.285Z |
5567292 | 5567292 | 20241121095823_QgWzV | NZ004U | 2024-11-22T14:05:46.703Z | 2024-11-22T14:05:46.703Z |
5560962 | 5560962 | 20241120153104_UbfsX | NZ004U | 2024-11-21T14:10:06.056Z | 2024-11-22T14:19:21.771Z |
5560957 | 5560957 | 20241120152811_FMTuN | NZ004U | 2024-11-21T14:10:05.527Z | 2024-11-22T14:19:21.770Z |
5560921 | 5560921 | 20241120152147_Zl0O4 | NZ004U | 2024-11-21T14:09:58.471Z | 2024-11-22T14:19:21.761Z |
5560917 | 5560917 | 20241120151934_59X9L | NZ004U | 2024-11-21T14:09:57.898Z | 2024-11-22T14:19:21.759Z |
5560621 | 5560621 | 20241120132710_OPo21 | NZ004U | 2024-11-21T14:09:16.280Z | 2024-11-22T14:19:21.698Z |
5559382 | 5559382 | 20241120101330_C5FLH | NZ004U | 2024-11-21T14:06:12.272Z | 2024-11-22T14:19:21.433Z |
5559360 | 5559360 | 20241120101210_eLoe2 | NZ004U | 2024-11-21T14:06:09.665Z | 2024-11-22T14:19:21.427Z |
5559328 | 5559328 | 20241120100401_3eMG3 | NZ004U | 2024-11-21T14:05:59.712Z | 2024-11-22T14:19:21.418Z |
5559154 | 5559154 | 20241120092959_BlUhT | NZ004U | 2024-11-21T14:05:29.182Z | 2024-11-22T14:19:21.375Z |
5555650 | 5555650 | 20241119142312_EL3PH | NZ004U | 2024-11-20T14:06:18.887Z | 2024-11-22T14:20:11.783Z |
5555643 | 5555643 | 20241119142004_3HKcU | NZ004U | 2024-11-20T14:06:13.370Z | 2024-11-22T14:20:11.532Z |
5555602 | 5555602 | 20241119140341_OvcmW | NZ004U | 2024-11-20T14:06:04.750Z | 2024-11-22T14:20:10.744Z |
5555566 | 5555566 | 20241119135403_DI3LV | NZ004U | 2024-11-20T14:06:00.533Z | 2024-11-22T14:20:09.778Z |
5555413 | 5555413 | 20241119130630_OAiyo | NZ004U | 2024-11-20T14:05:34.374Z | 2024-11-22T14:20:05.577Z |
5555373 | 5555373 | 20241119125636_yERC8 | NZ004U | 2024-11-20T14:05:20.032Z | 2024-11-22T14:20:04.912Z |
5555317 | 5555317 | 20241119124008_MGeHP | NZ004U | 2024-11-20T14:05:10.427Z | 2024-11-22T14:20:03.777Z |
5555262 | 5555262 | 20241119122604_eWQ2D | NZ004U | 2024-11-20T14:05:02.536Z | 2024-11-22T14:20:02.511Z |
5554713 | 5554713 | 20241119101559_sbNOb | NZ004U | 2024-11-20T14:03:06.444Z | 2024-11-22T14:19:49.653Z |
5551799 | 5551799 | 20241118151719_BSebL | NZ004U | 2024-11-19T14:05:32.406Z | 2024-11-22T14:22:12.531Z |
5551779 | 5551779 | 20241118151225_1SGn0 | NZ004U | 2024-11-19T14:05:29.474Z | 2024-11-22T14:22:12.478Z |
5551678 | 5551678 | 20241118144128_85XvK | NZ004U | 2024-11-19T14:05:10.884Z | 2024-11-22T14:22:12.030Z |
5551487 | 5551487 | 20241118135524_hS1De | NZ004U | 2024-11-19T14:04:52.144Z | 2024-11-22T14:22:11.012Z |
5551388 | 5551388 | 20241118132009_JmGGm | NZ004U | 2024-11-19T14:04:42.904Z | 2024-11-22T14:22:10.449Z |
5551066 | 5551066 | 20241118121759_34X1p | NZ004U | 2024-11-19T14:03:51.807Z | 2024-11-22T14:22:08.002Z |
5551060 | 5551060 | 20241118121633_c2UCg | NZ004U | 2024-11-19T14:03:51.000Z | 2024-11-22T14:22:07.971Z |
5550854 | 5550854 | 20241118113642_myxj2 | NZ004U | 2024-11-19T14:03:12.823Z | 2024-11-22T14:22:06.193Z |
5550757 | 5550757 | 20241118112119_A3FHV | NZ004U | 2024-11-19T14:03:02.228Z | 2024-11-22T14:22:05.395Z |
5550727 | 5550727 | 20241118111524_Uc36n | NZ004U | 2024-11-19T14:02:58.700Z | 2024-11-22T14:22:05.079Z |
5550722 | 5550722 | 20241118111449_3MXAX | NZ004U | 2024-11-19T14:02:58.427Z | 2024-11-22T14:22:05.064Z |
5550386 | 5550386 | 20241118101124_sy9bb | NZ004U | 2024-11-19T14:02:16.209Z | 2024-11-22T14:22:02.597Z |
5550070 | 5550070 | 20241118092543_c0TsZ | NZ004U | 2024-11-19T14:01:32.400Z | 2024-11-22T14:21:57.788Z |
5549888 | 5549888 | 20241118083015_UKo6Z | NZ004U | 2024-11-19T14:01:07.897Z | 2024-11-22T14:21:54.709Z |
5501696 | 5501696 | 20241107151550_xCtXS | NZ004U | 2024-11-09T14:10:13.462Z | 2024-11-16T14:27:45.431Z |
5494152 | 5494152 | 20241107160442_dPsDj | NZ004U | 2024-11-08T14:05:26.474Z | 2024-11-16T14:27:48.578Z |
5494135 | 5494135 | 20241107154323_Xr8Ur | NZ004U | 2024-11-08T14:05:25.139Z | 2024-11-16T14:27:48.241Z |
5494098 | 5494098 | 20241107153437_MNWud | NZ004U | 2024-11-08T14:05:22.270Z | 2024-11-16T14:27:46.871Z |
5494070 | 5494070 | 20241107152718_633ZG | NZ004U | 2024-11-08T14:05:19.809Z | 2024-11-16T14:27:46.257Z |
5494034 | 5494034 | 20241107151700_V3oqR | NZ004U | 2024-11-08T14:05:16.767Z | 2024-11-16T14:27:45.449Z |
5493995 | 5493995 | 20241107150642_sbLuk | NZ004U | 2024-11-08T14:05:13.619Z | 2024-11-16T14:27:44.539Z |
5493967 | 5493967 | 20241107145315_lL1MY | NZ004U | 2024-11-08T14:05:06.338Z | 2024-11-16T14:27:43.877Z |
5493953 | 5493953 | 20241107144803_e4lq2 | NZ004U | 2024-11-08T14:05:02.771Z | 2024-11-16T14:27:43.586Z |
5481021 | 5481021 | 20241104123735_k9meT | NZ004U | 2024-11-06T14:08:32.008Z | 2024-11-13T14:27:25.080Z |
5480966 | 5480966 | 20241104114837_3HewB | NZ004U | 2024-11-06T14:08:10.790Z | 2024-11-13T14:27:24.349Z |
5480961 | 5480961 | 20241104111605_IMCAO | NZ004U | 2024-11-06T14:08:03.580Z | 2024-11-13T14:27:23.980Z |
5480662 | 5480662 | 20241105143224_xO2mc | NZ004U | 2024-11-06T14:06:17.093Z | 2024-11-14T14:23:05.450Z |
5480657 | 5480657 | 20241105143057_dSzYQ | NZ004U | 2024-11-06T14:06:14.502Z | 2024-11-14T14:23:05.431Z |
5480624 | 5480624 | 20241105141823_w1lh1 | NZ004U | 2024-11-06T14:06:03.848Z | 2024-11-14T14:23:05.334Z |
5480546 | 5480546 | 20241105134346_oOD3h | NZ004U | 2024-11-06T14:05:53.652Z | 2024-11-14T14:23:04.753Z |
5480523 | 5480523 | 20241105133050_y3z46 | NZ004U | 2024-11-06T14:05:51.301Z | 2024-11-14T14:23:04.600Z |
5480516 | 5480516 | 20241105132901_yy0p6 | NZ004U | 2024-11-06T14:05:50.430Z | 2024-11-14T14:23:04.553Z |
5480463 | 5480463 | 20241105130609_Gp1DK | NZ004U | 2024-11-06T14:05:44.137Z | 2024-11-14T14:23:04.357Z |
5480377 | 5480377 | 20241105123738_EA9vH | NZ004U | 2024-11-06T14:05:22.580Z | 2024-11-14T14:23:03.993Z |
5480227 | 5480227 | 20241105120401_sSOL3 | NZ004U | 2024-11-06T14:04:59.851Z | 2024-11-14T14:23:03.106Z |
5480221 | 5480221 | 20241105120335_C8dWY | NZ004U | 2024-11-06T14:04:59.025Z | 2024-11-14T14:23:03.103Z |
5480180 | 5480180 | 20241105115655_gip3a | NZ004U | 2024-11-06T14:04:45.331Z | 2024-11-14T14:23:02.909Z |
5479091 | 5479091 | 20241105080032_rgzFB | NZ004U | 2024-11-06T14:00:58.578Z | 2024-11-14T14:22:57.487Z |
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);