participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,513 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 |
---|---|---|---|---|---|
5469774 | 5469774 | 20241103041806_BlHhi | NL000M | 2024-11-04T14:17:02.717Z | 2024-11-09T14:23:03.787Z |
5469305 | 5469305 | 20241103030712_5YseK | NL000M | 2024-11-04T14:16:17.975Z | 2024-11-09T14:23:02.063Z |
5469303 | 5469303 | 20241103030652_kWJY0 | NL000M | 2024-11-04T14:16:17.668Z | 2024-11-09T14:23:02.021Z |
5467407 | 5467407 | 20241102210223_E4D8B | NL000M | 2024-11-04T14:11:26.733Z | 2024-11-09T14:22:54.310Z |
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 |
5372343 | 5372343 | 20241024004451_9lo3m | NL000M | 2024-10-26T12:19:21.347Z | 2024-11-01T12:26:57.409Z |
5371931 | 5371931 | 20241024002333_sbiDE | NL000M | 2024-10-26T12:18:58.845Z | 2024-11-01T12:26:57.003Z |
5366324 | 5366324 | 20241024001556_25NGG | NL000M | 2024-10-25T12:18:23.272Z | 2024-11-01T12:26:56.865Z |
5366292 | 5366292 | 20241024001420_00yyD | NL000M | 2024-10-25T12:18:20.557Z | 2024-11-01T12:26:56.837Z |
5365756 | 5365756 | 20241023234741_SnRVM | NL000M | 2024-10-25T12:18:07.221Z | 2024-11-01T12:26:56.398Z |
5365468 | 5365468 | 20241023233331_tUAE5 | NL000M | 2024-10-25T12:17:58.649Z | 2024-11-01T12:26:56.158Z |
5365407 | 5365407 | 20241023233051_RNfBS | NL000M | 2024-10-25T12:17:57.476Z | 2024-11-01T12:26:56.084Z |
5365316 | 5365316 | 20241023232537_mJ2nF | NL000M | 2024-10-25T12:17:55.689Z | 2024-11-01T12:26:56.052Z |
5365309 | 5365309 | 20241023232537_QJSwT | NL000M | 2024-10-25T12:17:55.312Z | 2024-11-01T12:26:56.050Z |
5365042 | 5365042 | 20241023231145_UwF0H | NL000M | 2024-10-25T12:17:44.193Z | 2024-11-01T12:26:55.835Z |
5364509 | 5364509 | 20241023223519_sEjUB | NL000M | 2024-10-25T12:17:23.346Z | 2024-11-01T12:26:55.165Z |
5364363 | 5364363 | 20241023222339_Sua7D | NL000M | 2024-10-25T12:17:18.533Z | 2024-11-01T12:26:55.020Z |
5364246 | 5364246 | 20241023221627_ju949 | NL000M | 2024-10-25T12:17:13.640Z | 2024-11-01T12:26:54.621Z |
5364023 | 5364023 | 20241023220303_O5lfg | NL000M | 2024-10-25T12:17:06.094Z | 2024-11-01T12:26:54.318Z |
5363965 | 5363965 | 20241023220032_rKjmY | NL000M | 2024-10-25T12:17:04.021Z | 2024-11-01T12:26:54.228Z |
5363837 | 5363837 | 20241023214958_E7UXZ | NL000M | 2024-10-25T12:16:52.694Z | 2024-11-01T12:26:53.889Z |
5363764 | 5363764 | 20241023214206_K222S | NL000M | 2024-10-25T12:16:42.831Z | 2024-11-01T12:26:53.614Z |
5362547 | 5362547 | 20241023194027_HhLIs | NL000M | 2024-10-25T12:14:42.483Z | 2024-11-01T12:26:51.984Z |
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);