participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,531 rows where station_code = "NL000M" 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 |
---|---|---|---|---|---|
5571590 | 5571590 | 20241121001211_ZdJI2 | NL000M | 2024-11-22T14:17:20.997Z | 2024-11-22T14:19:22.155Z |
5571586 | 5571586 | 20241121001105_yaBs3 | NL000M | 2024-11-22T14:17:20.407Z | 2024-11-22T14:19:22.154Z |
5571422 | 5571422 | 20241120234110_UU2Rj | NL000M | 2024-11-22T14:17:03.909Z | 2024-11-22T14:19:22.120Z |
5564583 | 5564583 | 20241120031110_K2FlQ | NL000M | 2024-11-21T14:17:51.453Z | 2024-11-22T14:21:33.749Z |
5564339 | 5564339 | 20241120024857_Ikkgk | NL000M | 2024-11-21T14:17:27.918Z | 2024-11-22T14:21:30.543Z |
5564194 | 5564194 | 20241120023755_w0pr4 | NL000M | 2024-11-21T14:17:18.019Z | 2024-11-22T14:21:28.743Z |
5563936 | 5563936 | 20241120021818_wc39y | NL000M | 2024-11-21T14:16:59.902Z | 2024-11-22T14:21:25.575Z |
5563800 | 5563800 | 20241120020533_UvS0M | NL000M | 2024-11-21T14:16:44.310Z | 2024-11-22T14:21:23.411Z |
5563729 | 5563729 | 20241120015950_5OPoV | NL000M | 2024-11-21T14:16:36.883Z | 2024-11-22T14:21:21.510Z |
5563067 | 5563067 | 20241120004819_Pyamh | NL000M | 2024-11-21T14:15:34.520Z | 2024-11-22T14:21:09.007Z |
5562971 | 5562971 | 20241120003504_xl1TV | NL000M | 2024-11-21T14:15:30.507Z | 2024-11-22T14:21:07.424Z |
5562858 | 5562858 | 20241120002143_kbM5L | NL000M | 2024-11-21T14:15:25.684Z | 2024-11-22T14:21:05.667Z |
5537095 | 5537095 | 20241112202512_jTwFO | NL000M | 2024-11-14T14:11:01.558Z | 2024-11-21T14:26:08.740Z |
5537084 | 5537084 | 20241112202312_WGZsj | NL000M | 2024-11-14T14:11:00.394Z | 2024-11-21T14:26:08.704Z |
5532557 | 5532557 | 20241112053724_T22XF | NL000M | 2024-11-13T14:16:59.780Z | 2024-11-20T14:26:24.577Z |
5531525 | 5531525 | 20241112034705_xDmWY | NL000M | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5530759 | 5530759 | 20241112024446_pFr11 | NL000M | 2024-11-13T14:14:34.689Z | 2024-11-20T14:26:03.010Z |
5528400 | 5528400 | 20241111203957_vdKGj | NL000M | 2024-11-13T14:10:35.184Z | 2024-11-20T14:25:30.041Z |
5469774 | 5469774 | 20241103041806_BlHhi | NL000M | 2024-11-04T14:17:02.717Z | 2024-11-11T14:23:02.210Z |
5469305 | 5469305 | 20241103030712_5YseK | NL000M | 2024-11-04T14:16:17.975Z | 2024-11-11T14:22:59.794Z |
5469303 | 5469303 | 20241103030652_kWJY0 | NL000M | 2024-11-04T14:16:17.668Z | 2024-11-11T14:22:59.775Z |
5467407 | 5467407 | 20241102210223_E4D8B | NL000M | 2024-11-04T14:11:26.733Z | 2024-11-11T14:22:46.799Z |
5421197 | 5421197 | 20241028050417_jr3AW | NL000M | 2024-10-30T12:19:42.309Z | 2024-11-05T14:27:17.758Z |
5421070 | 5421070 | 20241028042708_ys3Us | NL000M | 2024-10-30T12:19:34.732Z | 2024-11-05T14:27:17.205Z |
5421038 | 5421038 | 20241028042245_27XCY | NL000M | 2024-10-30T12:19:33.692Z | 2024-11-05T14:27:17.115Z |
5421016 | 5421016 | 20241028041556_33lJX | NL000M | 2024-10-30T12:19:32.624Z | 2024-11-05T14:27:17.016Z |
5421010 | 5421010 | 20241028041419_soiHk | NL000M | 2024-10-30T12:19:32.240Z | 2024-11-05T14:27:17.012Z |
5420807 | 5420807 | 20241028033905_GppJW | NL000M | 2024-10-30T12:19:19.871Z | 2024-11-05T14:27:16.411Z |
5420764 | 5420764 | 20241028033247_AVKKK | NL000M | 2024-10-30T12:19:15.358Z | 2024-11-05T14:27:16.250Z |
5420587 | 5420587 | 20241028030237_OHwf3 | NL000M | 2024-10-30T12:19:02.780Z | 2024-11-05T14:27:15.796Z |
5420414 | 5420414 | 20241028023924_sEw3c | NL000M | 2024-10-30T12:18:50.016Z | 2024-11-05T14:27:15.380Z |
5420293 | 5420293 | 20241028022537_315Ua | NL000M | 2024-10-30T12:18:41.542Z | 2024-11-05T14:27:15.127Z |
5419479 | 5419479 | 20241028000632_H70Iv | NL000M | 2024-10-30T12:17:29.354Z | 2024-11-05T14:27:13.223Z |
5419401 | 5419401 | 20241027235422_pr3eM | NL000M | 2024-10-30T12:17:25.264Z | 2024-11-05T14:27:13.006Z |
5419316 | 5419316 | 20241027233536_VddDm | NL000M | 2024-10-30T12:17:20.094Z | 2024-11-05T14:27:12.713Z |
5419280 | 5419280 | 20241027232939_qskVL | NL000M | 2024-10-30T12:17:18.604Z | 2024-11-05T14:27:12.691Z |
5419257 | 5419257 | 20241027232508_7Q3PL | NL000M | 2024-10-30T12:17:17.038Z | 2024-11-05T14:27:12.631Z |
5419213 | 5419213 | 20241027231641_fNXiz | NL000M | 2024-10-30T12:17:15.122Z | 2024-11-05T14:27:12.546Z |
5419180 | 5419180 | 20241027231115_jkPWN | NL000M | 2024-10-30T12:17:13.350Z | 2024-11-05T14:27:12.488Z |
5419117 | 5419117 | 20241027230450_89uoc | NL000M | 2024-10-30T12:17:10.525Z | 2024-11-05T14:27:12.406Z |
5418519 | 5418519 | 20241027210502_wQiwx | NL000M | 2024-10-30T12:15:47.269Z | 2024-11-05T14:27:10.348Z |
5418423 | 5418423 | 20241027204346_TjYFb | NL000M | 2024-10-30T12:15:40.384Z | 2024-11-05T14:27:09.998Z |
5417975 | 5417975 | 20241027193605_wYeFQ | NL000M | 2024-10-30T12:14:41.716Z | 2024-11-05T14:27:08.776Z |
5417360 | 5417360 | 20241027182019_u6gyf | NL000M | 2024-10-30T12:13:34.053Z | 2024-11-05T14:27:07.059Z |
5417294 | 5417294 | 20241027181142_uqa90 | NL000M | 2024-10-30T12:13:28.862Z | 2024-11-05T14:27:06.930Z |
5399499 | 5399499 | 20241026042902_PL2t4 | NL000M | 2024-10-28T12:20:01.173Z | 2024-11-03T14:27:39.878Z |
5398495 | 5398495 | 20241026030319_Mlyo6 | NL000M | 2024-10-28T12:19:20.051Z | 2024-11-03T14:27:36.615Z |
5394823 | 5394823 | 20241025213138_DgfBr | NL000M | 2024-10-28T12:15:30.219Z | 2024-11-03T14:27:22.845Z |
5394718 | 5394718 | 20241025211416_p2BB2 | NL000M | 2024-10-28T12:15:17.245Z | 2024-11-03T14:27:22.400Z |
5394702 | 5394702 | 20241025211224_LtL2E | NL000M | 2024-10-28T12:15:15.582Z | 2024-11-03T14:27:22.350Z |
5394529 | 5394529 | 20241025204616_8h1O2 | NL000M | 2024-10-28T12:14:51.474Z | 2024-11-03T14:27:21.464Z |
5394216 | 5394216 | 20241025195820_5c6CH | NL000M | 2024-10-28T12:14:11.807Z | 2024-11-03T14:27:20.384Z |
5393719 | 5393719 | 20241025183410_gZ14T | NL000M | 2024-10-28T12:13:06.601Z | 2024-11-03T14:27:17.569Z |
5388431 | 5388431 | 20241025045157_L2dKh | NL000M | 2024-10-27T12:22:13.736Z | 2024-11-02T12:28:34.162Z |
5388369 | 5388369 | 20241025043901_mIHlZ | NL000M | 2024-10-27T12:22:11.041Z | 2024-11-02T12:28:34.036Z |
5388333 | 5388333 | 20241025043250_v7S7A | NL000M | 2024-10-27T12:22:10.186Z | 2024-11-02T12:28:33.963Z |
5387995 | 5387995 | 20241025035032_uvbyw | NL000M | 2024-10-27T12:21:51.909Z | 2024-11-02T12:28:33.564Z |
5384891 | 5384891 | 20241024211316_agnBZ | NL000M | 2024-10-27T12:17:56.655Z | 2024-11-02T12:28:28.579Z |
5384858 | 5384858 | 20241024210630_tTrbq | NL000M | 2024-10-27T12:17:52.012Z | 2024-11-02T12:28:28.518Z |
5384840 | 5384840 | 20241024210229_WlMim | NL000M | 2024-10-27T12:17:48.853Z | 2024-11-02T12:28:28.453Z |
5384611 | 5384611 | 20241024202808_gvT4f | NL000M | 2024-10-27T12:17:18.187Z | 2024-11-02T12:28:27.411Z |
5383250 | 5383250 | 20241024180128_053LC | NL000M | 2024-10-27T12:15:01.628Z | 2024-11-02T12:28:24.849Z |
5383098 | 5383098 | 20241024174150_CKADD | NL000M | 2024-10-27T12:14:45.524Z | 2024-11-02T12:28:24.692Z |
5377980 | 5377980 | 20241024052142_IQBWk | NL000M | 2024-10-26T12:22:51.580Z | 2024-11-01T12:27:03.212Z |
5377834 | 5377834 | 20241024051320_OmCAo | NL000M | 2024-10-26T12:22:47.857Z | 2024-11-01T12:27:03.084Z |
5377601 | 5377601 | 20241024045912_YjTWm | NL000M | 2024-10-26T12:22:41.874Z | 2024-11-01T12:27:02.624Z |
5377517 | 5377517 | 20241024045446_0eVsx | NL000M | 2024-10-26T12:22:39.312Z | 2024-11-01T12:27:02.561Z |
5377088 | 5377088 | 20241024043316_RTcC9 | NL000M | 2024-10-26T12:22:25.999Z | 2024-11-01T12:27:02.175Z |
5377011 | 5377011 | 20241024042926_PPt11 | NL000M | 2024-10-26T12:22:23.033Z | 2024-11-01T12:27:02.125Z |
5376834 | 5376834 | 20241024041846_CE4YS | NL000M | 2024-10-26T12:22:14.768Z | 2024-11-01T12:27:01.893Z |
5376833 | 5376833 | 20241024041841_FtZx6 | NL000M | 2024-10-26T12:22:14.684Z | 2024-11-01T12:27:01.892Z |
5376799 | 5376799 | 20241024041718_AfZdE | NL000M | 2024-10-26T12:22:13.449Z | 2024-11-01T12:27:01.857Z |
5376708 | 5376708 | 20241024040959_bqUzU | NL000M | 2024-10-26T12:22:11.000Z | 2024-11-01T12:27:01.748Z |
5376693 | 5376693 | 20241024040930_urofi | NL000M | 2024-10-26T12:22:10.624Z | 2024-11-01T12:27:01.745Z |
5376641 | 5376641 | 20241024040623_PP0LE | NL000M | 2024-10-26T12:22:09.110Z | 2024-11-01T12:27:01.703Z |
5376599 | 5376599 | 20241024040413_7iJTp | NL000M | 2024-10-26T12:22:06.038Z | 2024-11-01T12:27:01.615Z |
5376474 | 5376474 | 20241024035710_r837A | NL000M | 2024-10-26T12:22:02.893Z | 2024-11-01T12:27:01.567Z |
5376156 | 5376156 | 20241024034347_L2gV2 | NL000M | 2024-10-26T12:21:52.513Z | 2024-11-01T12:27:01.415Z |
5376136 | 5376136 | 20241024034255_UJtWU | NL000M | 2024-10-26T12:21:52.168Z | 2024-11-01T12:27:01.411Z |
5375962 | 5375962 | 20241024033645_tOvfo | NL000M | 2024-10-26T12:21:45.165Z | 2024-11-01T12:27:01.297Z |
5375749 | 5375749 | 20241024032737_u26O9 | NL000M | 2024-10-26T12:21:38.666Z | 2024-11-01T12:27:01.178Z |
5375516 | 5375516 | 20241024031722_3P3Su | NL000M | 2024-10-26T12:21:30.399Z | 2024-11-01T12:27:00.746Z |
5375459 | 5375459 | 20241024031412_anaUO | NL000M | 2024-10-26T12:21:26.385Z | 2024-11-01T12:27:00.699Z |
5375432 | 5375432 | 20241024031328_gi3x9 | NL000M | 2024-10-26T12:21:25.775Z | 2024-11-01T12:27:00.688Z |
5375363 | 5375363 | 20241024030853_GJrtt | NL000M | 2024-10-26T12:21:21.633Z | 2024-11-01T12:27:00.634Z |
5375261 | 5375261 | 20241024030438_b3tk6 | NL000M | 2024-10-26T12:21:17.493Z | 2024-11-01T12:27:00.463Z |
5375228 | 5375228 | 20241024030313_2Il9q | NL000M | 2024-10-26T12:21:17.018Z | 2024-11-01T12:27:00.447Z |
5375109 | 5375109 | 20241024025802_BV4G9 | NL000M | 2024-10-26T12:21:13.283Z | 2024-11-01T12:27:00.290Z |
5374360 | 5374360 | 20241024022341_TSQiE | NL000M | 2024-10-26T12:20:46.318Z | 2024-11-01T12:26:58.860Z |
5374317 | 5374317 | 20241024022150_7qfNb | NL000M | 2024-10-26T12:20:44.740Z | 2024-11-01T12:26:58.839Z |
5374273 | 5374273 | 20241024021930_MlrDU | NL000M | 2024-10-26T12:20:42.955Z | 2024-11-01T12:26:58.811Z |
5374135 | 5374135 | 20241024021205_OVKDU | NL000M | 2024-10-26T12:20:37.700Z | 2024-11-01T12:26:58.708Z |
5373700 | 5373700 | 20241024015108_evVDU | NL000M | 2024-10-26T12:20:21.968Z | 2024-11-01T12:26:58.378Z |
5373438 | 5373438 | 20241024013817_MbmZi | NL000M | 2024-10-26T12:20:11.140Z | 2024-11-01T12:26:58.256Z |
5373324 | 5373324 | 20241024013257_SgpxG | NL000M | 2024-10-26T12:20:06.600Z | 2024-11-01T12:26:58.220Z |
5373261 | 5373261 | 20241024013018_caTua | NL000M | 2024-10-26T12:20:03.321Z | 2024-11-01T12:26:58.200Z |
5372885 | 5372885 | 20241024011245_aeEnA | NL000M | 2024-10-26T12:19:46.759Z | 2024-11-01T12:26:58.014Z |
5372767 | 5372767 | 20241024010718_OMUNl | NL000M | 2024-10-26T12:19:42.433Z | 2024-11-01T12:26:57.911Z |
5372721 | 5372721 | 20241024010503_I0yNi | NL000M | 2024-10-26T12:19:40.018Z | 2024-11-01T12:26:57.894Z |
5372414 | 5372414 | 20241024004705_jGtYc | NL000M | 2024-10-26T12:19:23.533Z | 2024-11-01T12:26:57.435Z |
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);