participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
171 rows where station_code = "NL000G" 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 |
---|---|---|---|---|---|
5592436 | 5592436 | 20241123032552_zCvfR | NL000G | 2024-11-24T14:21:01.652Z | 2024-11-26T14:23:46.475Z |
5591716 | 5591716 | 20241123003605_u9NFn | NL000G | 2024-11-24T14:20:12.514Z | 2024-11-26T14:23:28.701Z |
5591535 | 5591535 | 20241122234548_Nqalr | NL000G | 2024-11-24T14:19:59.503Z | 2024-11-26T14:23:25.024Z |
5591513 | 5591513 | 20241122233344_x3MRU | NL000G | 2024-11-24T14:19:57.142Z | 2024-11-26T14:23:24.318Z |
5591183 | 5591183 | 20241122214950_zfgSf | NL000G | 2024-11-24T14:19:33.798Z | 2024-11-26T14:23:17.592Z |
5590921 | 5590921 | 20241122204035_NF9js | NL000G | 2024-11-24T14:19:09.944Z | 2024-11-26T14:23:14.315Z |
5590844 | 5590844 | 20241122202147_t0ZXi | NL000G | 2024-11-24T14:19:03.575Z | 2024-11-26T14:23:13.602Z |
5590821 | 5590821 | 20241122201630_9rwp0 | NL000G | 2024-11-24T14:19:00.302Z | 2024-11-26T14:23:13.335Z |
5584105 | 5584105 | 20241118004045_ROG3Z | NL000G | 2024-11-23T14:25:28.436Z | 2024-11-26T14:28:48.702Z |
5582525 | 5582525 | 20241122034057_6o2E2 | NL000G | 2024-11-23T14:21:08.167Z | 2024-11-26T14:25:28.074Z |
5579763 | 5579763 | 20241121231522_dutNv | NL000G | 2024-11-23T14:18:49.400Z | 2024-11-26T14:25:01.104Z |
5578765 | 5578765 | 20241121205655_ZPEFq | NL000G | 2024-11-23T14:17:32.386Z | 2024-11-26T14:24:52.374Z |
5578531 | 5578531 | 20241121201923_nFSVR | NL000G | 2024-11-23T14:17:21.329Z | 2024-11-26T14:24:48.990Z |
5578065 | 5578065 | 20241121184622_NMOCU | NL000G | 2024-11-23T14:16:26.558Z | 2024-11-26T14:24:43.831Z |
5573963 | 5573963 | 20241122045533_jYfaH | NL000G | 2024-11-23T14:02:01.597Z | 2024-11-26T14:22:13.989Z |
5573947 | 5573947 | 20241122045320_RSK6y | NL000G | 2024-11-23T14:01:57.701Z | 2024-11-26T14:22:13.534Z |
5573519 | 5573519 | 20241122042312_hA3kT | NL000G | 2024-11-23T14:00:44.322Z | 2024-11-26T14:22:05.190Z |
5573492 | 5573492 | 20241122042210_iASgA | NL000G | 2024-11-23T14:00:39.646Z | 2024-11-26T14:22:04.509Z |
5482121 | 5482121 | 20241104211004_ZWS7P | NL000G | 2024-11-06T14:12:25.453Z | 2024-11-13T14:27:33.925Z |
5481969 | 5481969 | 20241104203149_ln53v | NL000G | 2024-11-06T14:12:10.656Z | 2024-11-13T14:27:33.614Z |
5481901 | 5481901 | 20241104201324_drwuc | NL000G | 2024-11-06T14:11:48.829Z | 2024-11-13T14:27:33.421Z |
5478605 | 5478605 | 20241104044208_4FIA3 | NL000G | 2024-11-05T14:18:33.928Z | 2024-11-12T14:28:16.324Z |
5478387 | 5478387 | 20241104040047_pJeIA | NL000G | 2024-11-05T14:18:17.664Z | 2024-11-12T14:28:15.205Z |
5478380 | 5478380 | 20241104040015_Gq0aZ | NL000G | 2024-11-05T14:18:17.097Z | 2024-11-12T14:28:15.058Z |
5478011 | 5478011 | 20241104030837_jQM3Y | NL000G | 2024-11-05T14:17:44.753Z | 2024-11-12T14:28:13.842Z |
5476145 | 5476145 | 20241103223412_deRZ2 | NL000G | 2024-11-05T14:14:48.312Z | 2024-11-12T14:28:03.401Z |
5476107 | 5476107 | 20241103222628_8pt3B | NL000G | 2024-11-05T14:14:45.654Z | 2024-11-12T14:28:02.992Z |
5475915 | 5475915 | 20241103215006_lxrLC | NL000G | 2024-11-05T14:14:33.386Z | 2024-11-12T14:28:01.805Z |
5475869 | 5475869 | 20241103214307_4OD40 | NL000G | 2024-11-05T14:14:27.104Z | 2024-11-12T14:28:01.708Z |
5475741 | 5475741 | 20241103211350_AG8ow | NL000G | 2024-11-05T14:14:05.102Z | 2024-11-12T14:28:00.793Z |
5475737 | 5475737 | 20241103211127_M6Aas | NL000G | 2024-11-05T14:14:04.557Z | 2024-11-12T14:28:00.772Z |
5475590 | 5475590 | 20241103204536_JeFjr | NL000G | 2024-11-05T14:13:51.655Z | 2024-11-12T14:28:00.027Z |
5475398 | 5475398 | 20241103195951_qxa74 | NL000G | 2024-11-05T14:13:27.089Z | 2024-11-12T14:27:58.445Z |
5475076 | 5475076 | 20241103190230_1o7xW | NL000G | 2024-11-05T14:12:29.861Z | 2024-11-12T14:27:56.979Z |
5474698 | 5474698 | 20241103180103_Drday | NL000G | 2024-11-05T14:11:38.359Z | 2024-11-12T14:27:53.910Z |
5467406 | 5467406 | 20241102210223_E4D8B | NL000G | 2024-11-04T14:11:26.733Z | 2024-11-11T14:22:46.799Z |
5467342 | 5467342 | 20241102204822_2G3Pt | NL000G | 2024-11-04T14:11:19.601Z | 2024-11-11T14:22:46.352Z |
5467268 | 5467268 | 20241102203333_9XuD4 | NL000G | 2024-11-04T14:11:12.072Z | 2024-11-11T14:22:45.883Z |
5452296 | 5452296 | 20241101024355_HWnpE | NL000G | 2024-11-02T12:18:35.898Z | 2024-11-09T14:24:30.280Z |
5451905 | 5451905 | 20241101012445_bXrtw | NL000G | 2024-11-02T12:18:05.267Z | 2024-11-09T14:24:26.622Z |
5450802 | 5450802 | 20241031210658_VN9hp | NL000G | 2024-11-02T12:15:56.647Z | 2024-11-09T14:24:18.149Z |
5428674 | 5428674 | 20241028175233_miatp | NL000G | 2024-10-31T12:15:23.198Z | 2024-11-06T14:27:14.229Z |
5423044 | 5423044 | 20241026004042_Ommcy | NL000G | 2024-10-30T12:24:13.143Z | 2024-11-03T14:27:31.190Z |
5421069 | 5421069 | 20241028042708_ys3Us | NL000G | 2024-10-30T12:19:34.732Z | 2024-11-05T14:27:17.205Z |
5421009 | 5421009 | 20241028041419_soiHk | NL000G | 2024-10-30T12:19:32.240Z | 2024-11-05T14:27:17.012Z |
5420806 | 5420806 | 20241028033905_GppJW | NL000G | 2024-10-30T12:19:19.871Z | 2024-11-05T14:27:16.411Z |
5419613 | 5419613 | 20241028002709_Zz7wZ | NL000G | 2024-10-30T12:17:38.700Z | 2024-11-05T14:27:13.556Z |
5419315 | 5419315 | 20241027233536_VddDm | NL000G | 2024-10-30T12:17:20.094Z | 2024-11-05T14:27:12.713Z |
5419116 | 5419116 | 20241027230450_89uoc | NL000G | 2024-10-30T12:17:10.525Z | 2024-11-05T14:27:12.406Z |
5418964 | 5418964 | 20241027223458_q5njm | NL000G | 2024-10-30T12:16:45.686Z | 2024-11-05T14:27:11.838Z |
5418888 | 5418888 | 20241027222019_aRioy | NL000G | 2024-10-30T12:16:28.407Z | 2024-11-05T14:27:11.663Z |
5418845 | 5418845 | 20241027220940_riKgm | NL000G | 2024-10-30T12:16:22.824Z | 2024-11-05T14:27:11.427Z |
5418622 | 5418622 | 20241027212524_sTkYG | NL000G | 2024-10-30T12:15:54.208Z | 2024-11-05T14:27:10.833Z |
5418605 | 5418605 | 20241027211927_Apgbp | NL000G | 2024-10-30T12:15:53.083Z | 2024-11-05T14:27:10.778Z |
5418518 | 5418518 | 20241027210502_wQiwx | NL000G | 2024-10-30T12:15:47.269Z | 2024-11-05T14:27:10.348Z |
5418422 | 5418422 | 20241027204346_TjYFb | NL000G | 2024-10-30T12:15:40.383Z | 2024-11-05T14:27:09.998Z |
5406980 | 5406980 | 20241027021505_6CwdB | NL000G | 2024-10-29T12:15:03.982Z | 2024-11-04T14:28:56.743Z |
5397807 | 5397807 | 20241026015908_NrqCv | NL000G | 2024-10-28T12:18:43.903Z | 2024-11-03T14:27:34.168Z |
5397534 | 5397534 | 20241026013834_rJIJ5 | NL000G | 2024-10-28T12:18:26.574Z | 2024-11-03T14:27:33.355Z |
5396607 | 5396607 | 20241026001645_6L32Y | NL000G | 2024-10-28T12:17:51.080Z | 2024-11-03T14:27:30.448Z |
5396463 | 5396463 | 20241026000600_MOjRm | NL000G | 2024-10-28T12:17:44.968Z | 2024-11-03T14:27:29.945Z |
5396461 | 5396461 | 20241026000550_QoQCJ | NL000G | 2024-10-28T12:17:44.762Z | 2024-11-03T14:27:29.916Z |
5396322 | 5396322 | 20241025235559_HjIgn | NL000G | 2024-10-28T12:17:33.740Z | 2024-11-03T14:27:29.420Z |
5393970 | 5393970 | 20241025192029_J5XnS | NL000G | 2024-10-28T12:13:56.361Z | 2024-11-03T14:27:19.398Z |
5393817 | 5393817 | 20241025185106_v6CeT | NL000G | 2024-10-28T12:13:29.047Z | 2024-11-03T14:27:18.434Z |
5393794 | 5393794 | 20241025184525_39m8m | NL000G | 2024-10-28T12:13:22.694Z | 2024-11-03T14:27:18.231Z |
5393718 | 5393718 | 20241025183410_gZ14T | NL000G | 2024-10-28T12:13:06.601Z | 2024-11-03T14:27:17.569Z |
5388368 | 5388368 | 20241025043901_mIHlZ | NL000G | 2024-10-27T12:22:11.041Z | 2024-11-02T12:28:34.036Z |
5388332 | 5388332 | 20241025043250_v7S7A | NL000G | 2024-10-27T12:22:10.186Z | 2024-11-02T12:28:33.963Z |
5385959 | 5385959 | 20241024234715_3MH7Z | NL000G | 2024-10-27T12:19:40.387Z | 2024-11-02T12:28:30.528Z |
5385907 | 5385907 | 20241024234258_EDwIO | NL000G | 2024-10-27T12:19:36.274Z | 2024-11-02T12:28:30.463Z |
5383204 | 5383204 | 20241024175514_wzCVM | NL000G | 2024-10-27T12:14:54.574Z | 2024-11-02T12:28:24.798Z |
5377600 | 5377600 | 20241024045912_YjTWm | NL000G | 2024-10-26T12:22:41.874Z | 2024-11-01T12:27:02.624Z |
5376892 | 5376892 | 20241024042125_ZdmAY | NL000G | 2024-10-26T12:22:16.074Z | 2024-11-01T12:27:01.907Z |
5376640 | 5376640 | 20241024040623_PP0LE | NL000G | 2024-10-26T12:22:09.110Z | 2024-11-01T12:27:01.703Z |
5375227 | 5375227 | 20241024030313_2Il9q | NL000G | 2024-10-26T12:21:17.018Z | 2024-11-01T12:27:00.447Z |
5375178 | 5375178 | 20241024030109_lJ0Rd | NL000G | 2024-10-26T12:21:15.948Z | 2024-11-01T12:27:00.315Z |
5374272 | 5374272 | 20241024021930_MlrDU | NL000G | 2024-10-26T12:20:42.955Z | 2024-11-01T12:26:58.811Z |
5374134 | 5374134 | 20241024021205_OVKDU | NL000G | 2024-10-26T12:20:37.700Z | 2024-11-01T12:26:58.708Z |
5373930 | 5373930 | 20241024020035_jS86K | NL000G | 2024-10-26T12:20:31.365Z | 2024-11-01T12:26:58.573Z |
5373708 | 5373708 | 20241024015113_ESLrQ | NL000G | 2024-10-26T12:20:22.287Z | 2024-11-01T12:26:58.380Z |
5373260 | 5373260 | 20241024013018_caTua | NL000G | 2024-10-26T12:20:03.321Z | 2024-11-01T12:26:58.200Z |
5373223 | 5373223 | 20241024012821_ajqrL | NL000G | 2024-10-26T12:20:02.308Z | 2024-11-01T12:26:58.181Z |
5373171 | 5373171 | 20241024012706_SxVx2 | NL000G | 2024-10-26T12:20:00.209Z | 2024-11-01T12:26:58.154Z |
5372884 | 5372884 | 20241024011245_aeEnA | NL000G | 2024-10-26T12:19:46.759Z | 2024-11-01T12:26:58.014Z |
5372766 | 5372766 | 20241024010718_OMUNl | NL000G | 2024-10-26T12:19:42.433Z | 2024-11-01T12:26:57.911Z |
5372720 | 5372720 | 20241024010503_I0yNi | NL000G | 2024-10-26T12:19:40.018Z | 2024-11-01T12:26:57.894Z |
5372413 | 5372413 | 20241024004705_jGtYc | NL000G | 2024-10-26T12:19:23.533Z | 2024-11-01T12:26:57.435Z |
5371930 | 5371930 | 20241024002333_sbiDE | NL000G | 2024-10-26T12:18:58.845Z | 2024-11-01T12:26:57.003Z |
5366323 | 5366323 | 20241024001556_25NGG | NL000G | 2024-10-25T12:18:23.272Z | 2024-11-01T12:26:56.865Z |
5364245 | 5364245 | 20241023221627_ju949 | NL000G | 2024-10-25T12:17:13.639Z | 2024-11-01T12:26:54.621Z |
5364022 | 5364022 | 20241023220303_O5lfg | NL000G | 2024-10-25T12:17:06.094Z | 2024-11-01T12:26:54.318Z |
5363416 | 5363416 | 20241023210146_Wv3iB | NL000G | 2024-10-25T12:16:07.109Z | 2024-11-01T12:26:53.277Z |
5361597 | 5361597 | 20241023182759_dgR7g | NL000G | 2024-10-25T12:13:00.165Z | 2024-11-01T12:26:50.372Z |
5361364 | 5361364 | 20241023180937_Jh2hM | NL000G | 2024-10-25T12:12:36.633Z | 2024-11-01T12:26:49.803Z |
5354621 | 5354621 | 20241023023619_WVFrK | NL000G | 2024-10-24T12:20:44.405Z | 2024-10-31T12:30:06.161Z |
5354402 | 5354402 | 20241023022515_HVES8 | NL000G | 2024-10-24T12:20:31.928Z | 2024-10-31T12:30:05.739Z |
5354221 | 5354221 | 20241023021217_Xkr3w | NL000G | 2024-10-24T12:20:23.764Z | 2024-10-31T12:30:05.529Z |
5354200 | 5354200 | 20241023021038_1tLQg | NL000G | 2024-10-24T12:20:22.911Z | 2024-10-31T12:30:05.509Z |
5353774 | 5353774 | 20241023014709_peHoo | NL000G | 2024-10-24T12:19:56.294Z | 2024-10-31T12:30:04.812Z |
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);