participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,318 rows where station_code = "NL000P" 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 |
---|---|---|---|---|---|
5489247 | 5489247 | 20241105181449_pUOTt | NL000P | 2024-11-07T14:11:39.845Z | 2024-11-08T14:15:58.217Z |
5484410 | 5484410 | 20241105024734_KDMj2 | NL000P | 2024-11-06T14:16:53.098Z | 2024-11-08T14:18:42.838Z |
5484217 | 5484217 | 20241105022127_MQ5qc | NL000P | 2024-11-06T14:16:32.825Z | 2024-11-08T14:18:41.748Z |
5483968 | 5483968 | 20241105014950_boY1H | NL000P | 2024-11-06T14:15:58.957Z | 2024-11-08T14:18:40.288Z |
5483962 | 5483962 | 20241105014945_mfWXy | NL000P | 2024-11-06T14:15:58.602Z | 2024-11-08T14:18:40.274Z |
5483901 | 5483901 | 20241105014233_Fr65C | NL000P | 2024-11-06T14:15:51.832Z | 2024-11-08T14:18:39.985Z |
5483470 | 5483470 | 20241105004406_J9SAM | NL000P | 2024-11-06T14:15:23.410Z | 2024-11-08T14:18:37.643Z |
5483457 | 5483457 | 20241105004326_izk1d | NL000P | 2024-11-06T14:15:21.787Z | 2024-11-08T14:18:37.588Z |
5483441 | 5483441 | 20241105004208_HfZKo | NL000P | 2024-11-06T14:15:19.088Z | 2024-11-08T14:18:37.474Z |
5483409 | 5483409 | 20241105003738_vW3IU | NL000P | 2024-11-06T14:15:13.480Z | 2024-11-08T14:18:37.273Z |
5483395 | 5483395 | 20241105003528_1h2cy | NL000P | 2024-11-06T14:15:11.727Z | 2024-11-08T14:18:37.236Z |
5483318 | 5483318 | 20241105002652_Gc3Jt | NL000P | 2024-11-06T14:14:59.383Z | 2024-11-08T14:18:36.680Z |
5483307 | 5483307 | 20241105002527_sT4jG | NL000P | 2024-11-06T14:14:57.313Z | 2024-11-08T14:18:36.588Z |
5483114 | 5483114 | 20241104235939_5zefq | NL000P | 2024-11-06T14:14:40.839Z | 2024-11-08T14:18:33.651Z |
5483089 | 5483089 | 20241104235724_CpwI7 | NL000P | 2024-11-06T14:14:39.472Z | 2024-11-08T14:18:33.325Z |
5483043 | 5483043 | 20241104234942_XXE3x | NL000P | 2024-11-06T14:14:36.292Z | 2024-11-08T14:18:32.426Z |
5482981 | 5482981 | 20241104234312_LlhPO | NL000P | 2024-11-06T14:14:32.957Z | 2024-11-08T14:18:31.655Z |
5482976 | 5482976 | 20241104234247_NrQ3K | NL000P | 2024-11-06T14:14:32.715Z | 2024-11-08T14:18:31.638Z |
5482896 | 5482896 | 20241104233111_q8Jel | NL000P | 2024-11-06T14:14:16.771Z | 2024-11-08T14:18:30.317Z |
5482775 | 5482775 | 20241104231227_QKBf9 | NL000P | 2024-11-06T14:13:56.051Z | 2024-11-08T14:18:28.484Z |
5482486 | 5482486 | 20241104222814_byFTP | NL000P | 2024-11-06T14:13:15.515Z | 2024-11-08T14:18:23.588Z |
5478039 | 5478039 | 20241104031350_PTfZa | NL000P | 2024-11-05T14:17:47.446Z | 2024-11-08T14:20:09.096Z |
5477936 | 5477936 | 20241104025607_UaE2T | NL000P | 2024-11-05T14:17:37.752Z | 2024-11-08T14:20:08.134Z |
5477477 | 5477477 | 20241104020146_pnpdp | NL000P | 2024-11-05T14:16:56.447Z | 2024-11-08T14:20:03.851Z |
5477457 | 5477457 | 20241104015807_Q1f2S | NL000P | 2024-11-05T14:16:54.921Z | 2024-11-08T14:20:03.715Z |
5477384 | 5477384 | 20241104014557_XA1ky | NL000P | 2024-11-05T14:16:49.081Z | 2024-11-08T14:20:03.153Z |
5477377 | 5477377 | 20241104014457_oA3hS | NL000P | 2024-11-05T14:16:47.888Z | 2024-11-08T14:20:03.113Z |
5477360 | 5477360 | 20241104014204_5lTbY | NL000P | 2024-11-05T14:16:46.366Z | 2024-11-08T14:20:02.805Z |
5477249 | 5477249 | 20241104012553_CUb5c | NL000P | 2024-11-05T14:16:36.428Z | 2024-11-08T14:20:02.161Z |
5477219 | 5477219 | 20241104012047_ex9XL | NL000P | 2024-11-05T14:16:32.054Z | 2024-11-08T14:20:01.953Z |
5477209 | 5477209 | 20241104012023_pz3Bw | NL000P | 2024-11-05T14:16:31.577Z | 2024-11-08T14:20:01.816Z |
5477199 | 5477199 | 20241104011839_POPft | NL000P | 2024-11-05T14:16:30.848Z | 2024-11-08T14:20:01.686Z |
5477164 | 5477164 | 20241104011016_ogB2j | NL000P | 2024-11-05T14:16:28.287Z | 2024-11-08T14:20:01.177Z |
5477092 | 5477092 | 20241104010013_mGL2V | NL000P | 2024-11-05T14:16:21.832Z | 2024-11-08T14:20:00.400Z |
5477043 | 5477043 | 20241104005442_1jd1g | NL000P | 2024-11-05T14:16:19.167Z | 2024-11-08T14:20:00.009Z |
5476905 | 5476905 | 20241104003955_Me7Mw | NL000P | 2024-11-05T14:16:11.444Z | 2024-11-08T14:19:58.432Z |
5476815 | 5476815 | 20241104002916_aQ6lp | NL000P | 2024-11-05T14:16:06.191Z | 2024-11-08T14:19:57.248Z |
5476771 | 5476771 | 20241104001950_JDGne | NL000P | 2024-11-05T14:16:03.988Z | 2024-11-08T14:19:56.993Z |
5476766 | 5476766 | 20241104001930_Y0b0X | NL000P | 2024-11-05T14:16:03.747Z | 2024-11-08T14:19:56.851Z |
5476739 | 5476739 | 20241104001514_1ILDp | NL000P | 2024-11-05T14:16:02.067Z | 2024-11-08T14:19:56.134Z |
5476567 | 5476567 | 20241103234643_XFnWa | NL000P | 2024-11-05T14:15:40.634Z | 2024-11-08T14:19:54.158Z |
5476476 | 5476476 | 20241103233155_3IEwr | NL000P | 2024-11-05T14:15:28.564Z | 2024-11-08T14:19:52.890Z |
5476361 | 5476361 | 20241103231413_wX8uQ | NL000P | 2024-11-05T14:15:10.198Z | 2024-11-08T14:19:51.840Z |
5476299 | 5476299 | 20241103230253_WGZnr | NL000P | 2024-11-05T14:15:01.412Z | 2024-11-08T14:19:50.913Z |
5476253 | 5476253 | 20241103225320_4EQFk | NL000P | 2024-11-05T14:14:58.653Z | 2024-11-08T14:19:50.448Z |
5476232 | 5476232 | 20241103224942_yQsSW | NL000P | 2024-11-05T14:14:57.146Z | 2024-11-08T14:19:50.381Z |
5476165 | 5476165 | 20241103223646_wmVWz | NL000P | 2024-11-05T14:14:49.240Z | 2024-11-08T14:19:49.403Z |
5476139 | 5476139 | 20241103223221_EjVSh | NL000P | 2024-11-05T14:14:47.751Z | 2024-11-08T14:19:48.962Z |
5475998 | 5475998 | 20241103220614_h3t2a | NL000P | 2024-11-05T14:14:38.178Z | 2024-11-08T14:19:47.635Z |
5475929 | 5475929 | 20241103215454_otizR | NL000P | 2024-11-05T14:14:34.233Z | 2024-11-08T14:19:46.738Z |
5475845 | 5475845 | 20241103213604_FN7Rs | NL000P | 2024-11-05T14:14:22.029Z | 2024-11-08T14:19:45.017Z |
5475804 | 5475804 | 20241103212906_f8RUu | NL000P | 2024-11-05T14:14:14.157Z | 2024-11-08T14:19:44.183Z |
5475791 | 5475791 | 20241103212416_ubIGr | NL000P | 2024-11-05T14:14:12.777Z | 2024-11-08T14:19:43.786Z |
5475751 | 5475751 | 20241103211527_PH7Vq | NL000P | 2024-11-05T14:14:07.951Z | 2024-11-08T14:19:43.402Z |
5475555 | 5475555 | 20241103203539_De3iC | NL000P | 2024-11-05T14:13:49.117Z | 2024-11-08T14:19:41.426Z |
5475263 | 5475263 | 20241103193822_IR5cn | NL000P | 2024-11-05T14:12:55.688Z | 2024-11-08T14:19:38.185Z |
5475254 | 5475254 | 20241103193650_LK5tv | NL000P | 2024-11-05T14:12:54.924Z | 2024-11-08T14:19:38.141Z |
5475242 | 5475242 | 20241103193417_93jgQ | NL000P | 2024-11-05T14:12:51.806Z | 2024-11-08T14:19:37.793Z |
5475144 | 5475144 | 20241103191535_582W9 | NL000P | 2024-11-05T14:12:36.399Z | 2024-11-08T14:19:36.642Z |
5475100 | 5475100 | 20241103190531_gq5Ga | NL000P | 2024-11-05T14:12:31.588Z | 2024-11-08T14:19:36.137Z |
5474481 | 5474481 | 20241103172755_Dq6vN | NL000P | 2024-11-05T14:11:08.598Z | 2024-11-08T14:19:26.422Z |
5474396 | 5474396 | 20241103171007_Ztate | NL000P | 2024-11-05T14:11:02.070Z | 2024-11-08T14:19:25.579Z |
5470101 | 5470101 | 20241103053025_y9gIh | NL000P | 2024-11-04T14:17:48.001Z | 2024-11-08T14:21:14.752Z |
5470000 | 5470000 | 20241103050456_Qj0tb | NL000P | 2024-11-04T14:17:32.487Z | 2024-11-08T14:21:14.011Z |
5469867 | 5469867 | 20241103043152_dfJ6p | NL000P | 2024-11-04T14:17:12.740Z | 2024-11-08T14:21:13.500Z |
5469803 | 5469803 | 20241103042156_YEhya | NL000P | 2024-11-04T14:17:04.520Z | 2024-11-08T14:21:12.892Z |
5469693 | 5469693 | 20241103040325_wwVb7 | NL000P | 2024-11-04T14:16:52.868Z | 2024-11-08T14:21:12.392Z |
5469506 | 5469506 | 20241103033809_mK24F | NL000P | 2024-11-04T14:16:32.775Z | 2024-11-08T14:21:10.445Z |
5469485 | 5469485 | 20241103033501_rLiCa | NL000P | 2024-11-04T14:16:31.411Z | 2024-11-08T14:21:10.336Z |
5469457 | 5469457 | 20241103033109_VN2n9 | NL000P | 2024-11-04T14:16:29.591Z | 2024-11-08T14:21:10.236Z |
5469390 | 5469390 | 20241103032057_J228n | NL000P | 2024-11-04T14:16:23.377Z | 2024-11-08T14:21:09.346Z |
5469360 | 5469360 | 20241103031538_euMuz | NL000P | 2024-11-04T14:16:21.835Z | 2024-11-08T14:21:09.291Z |
5469336 | 5469336 | 20241103031147_13uDU | NL000P | 2024-11-04T14:16:20.565Z | 2024-11-08T14:21:09.015Z |
5469175 | 5469175 | 20241103024351_5hlNx | NL000P | 2024-11-04T14:15:48.746Z | 2024-11-08T14:21:07.692Z |
5469160 | 5469160 | 20241103024240_yptYX | NL000P | 2024-11-04T14:15:46.871Z | 2024-11-08T14:21:07.614Z |
5469145 | 5469145 | 20241103024123_1xqUj | NL000P | 2024-11-04T14:15:44.455Z | 2024-11-08T14:21:07.393Z |
5469068 | 5469068 | 20241103022912_7qxXD | NL000P | 2024-11-04T14:15:33.492Z | 2024-11-08T14:21:06.959Z |
5469057 | 5469057 | 20241103022851_VuwCA | NL000P | 2024-11-04T14:15:31.362Z | 2024-11-08T14:21:06.857Z |
5469032 | 5469032 | 20241103022632_1TLbj | NL000P | 2024-11-04T14:15:26.131Z | 2024-11-08T14:21:06.750Z |
5469025 | 5469025 | 20241103022551_xc3hp | NL000P | 2024-11-04T14:15:24.771Z | 2024-11-08T14:21:06.712Z |
5468897 | 5468897 | 20241103020608_R8Ef6 | NL000P | 2024-11-04T14:15:12.261Z | 2024-11-08T14:21:05.870Z |
5468777 | 5468777 | 20241103014509_WPo2k | NL000P | 2024-11-04T14:15:03.033Z | 2024-11-08T14:21:04.417Z |
5468590 | 5468590 | 20241103010239_Fr2Vo | NL000P | 2024-11-04T14:14:31.248Z | 2024-11-08T14:21:03.026Z |
5468539 | 5468539 | 20241103005307_nKZGr | NL000P | 2024-11-04T14:14:22.959Z | 2024-11-08T14:21:02.755Z |
5468450 | 5468450 | 20241103003912_FKLHg | NL000P | 2024-11-04T14:14:08.450Z | 2024-11-08T14:21:02.214Z |
5468399 | 5468399 | 20241103002807_3yQte | NL000P | 2024-11-04T14:14:03.600Z | 2024-11-08T14:21:01.919Z |
5468319 | 5468319 | 20241103001044_JBG58 | NL000P | 2024-11-04T14:13:56.810Z | 2024-11-08T14:21:01.264Z |
5468290 | 5468290 | 20241103000336_2Y8RP | NL000P | 2024-11-04T14:13:53.876Z | 2024-11-08T14:21:01.108Z |
5468209 | 5468209 | 20241102235028_0aJTp | NL000P | 2024-11-04T14:13:45.147Z | 2024-11-08T14:21:00.330Z |
5468089 | 5468089 | 20241102232643_oHo32 | NL000P | 2024-11-04T14:13:15.600Z | 2024-11-08T14:20:59.098Z |
5468075 | 5468075 | 20241102232539_jUE7A | NL000P | 2024-11-04T14:13:13.152Z | 2024-11-08T14:20:59.085Z |
5468071 | 5468071 | 20241102232535_Eu3LW | NL000P | 2024-11-04T14:13:12.699Z | 2024-11-08T14:20:59.065Z |
5468028 | 5468028 | 20241102231800_sBwG6 | NL000P | 2024-11-04T14:13:08.671Z | 2024-11-08T14:20:58.645Z |
5467890 | 5467890 | 20241102225011_439Yv | NL000P | 2024-11-04T14:12:55.028Z | 2024-11-08T14:20:57.878Z |
5467784 | 5467784 | 20241102223632_aIL5e | NL000P | 2024-11-04T14:12:31.116Z | 2024-11-08T14:20:57.417Z |
5467773 | 5467773 | 20241102223553_YWuQo | NL000P | 2024-11-04T14:12:30.495Z | 2024-11-08T14:20:57.391Z |
5467761 | 5467761 | 20241102223304_2k6ng | NL000P | 2024-11-04T14:12:28.958Z | 2024-11-08T14:20:57.269Z |
5467715 | 5467715 | 20241102222319_JORq5 | NL000P | 2024-11-04T14:12:23.604Z | 2024-11-08T14:20:56.942Z |
5467680 | 5467680 | 20241102221629_EWEOt | NL000P | 2024-11-04T14:12:20.516Z | 2024-11-08T14:20:56.802Z |
5467601 | 5467601 | 20241102220242_fBoW3 | NL000P | 2024-11-04T14:12:13.295Z | 2024-11-08T14:20:56.340Z |
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);