participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,333 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 |
---|---|---|---|---|---|
5572828 | 5572828 | 20241121031407_TGXnr | NL000P | 2024-11-22T14:18:52.092Z | 2024-11-22T14:19:22.398Z |
5565535 | 5565535 | 20241121042003_18QJI | NL000P | 2024-11-22T14:00:13.829Z | 2024-11-22T14:00:13.829Z |
5561730 | 5561730 | 20241119215403_Am5dy | NL000P | 2024-11-21T14:13:53.248Z | 2024-11-22T14:20:44.958Z |
5561713 | 5561713 | 20241119214928_fAItR | NL000P | 2024-11-21T14:13:49.732Z | 2024-11-22T14:20:43.786Z |
5561411 | 5561411 | 20241119202709_1XDNQ | NL000P | 2024-11-21T14:13:14.428Z | 2024-11-22T14:20:35.305Z |
5561327 | 5561327 | 20241119195744_iJzaF | NL000P | 2024-11-21T14:13:06.162Z | 2024-11-22T14:20:32.269Z |
5561171 | 5561171 | 20241119185212_Xx6wd | NL000P | 2024-11-21T14:12:32.912Z | 2024-11-22T14:20:24.329Z |
5558196 | 5558196 | 20241120054445_q8DOk | NL000P | 2024-11-21T14:02:42.257Z | 2024-11-22T14:19:21.191Z |
5553324 | 5553324 | 20241118020356_QGMI6 | NL000P | 2024-11-19T14:10:18.754Z | 2024-11-22T14:22:52.303Z |
5553221 | 5553221 | 20241118014120_3CZrh | NL000P | 2024-11-19T14:10:10.467Z | 2024-11-22T14:22:51.175Z |
5552893 | 5552893 | 20241117230939_LCUfL | NL000P | 2024-11-19T14:09:38.355Z | 2024-11-22T14:22:48.861Z |
5552872 | 5552872 | 20241117225404_wGI8O | NL000P | 2024-11-19T14:09:33.249Z | 2024-11-22T14:22:47.859Z |
5549521 | 5549521 | 20241118050959_ZV7HT | NL000P | 2024-11-19T14:00:12.655Z | 2024-11-22T14:21:49.685Z |
5548261 | 5548261 | 20241116215537_XeMp2 | NL000P | 2024-11-18T14:08:35.368Z | 2024-11-22T14:23:11.548Z |
5548259 | 5548259 | 20241116215503_dEiR0 | NL000P | 2024-11-18T14:08:35.001Z | 2024-11-22T14:23:11.530Z |
5489247 | 5489247 | 20241105181449_pUOTt | NL000P | 2024-11-07T14:11:39.845Z | 2024-11-14T14:23:11.201Z |
5484410 | 5484410 | 20241105024734_KDMj2 | NL000P | 2024-11-06T14:16:53.098Z | 2024-11-13T14:27:37.943Z |
5484217 | 5484217 | 20241105022127_MQ5qc | NL000P | 2024-11-06T14:16:32.825Z | 2024-11-13T14:27:37.545Z |
5483968 | 5483968 | 20241105014950_boY1H | NL000P | 2024-11-06T14:15:58.957Z | 2024-11-13T14:27:37.073Z |
5483962 | 5483962 | 20241105014945_mfWXy | NL000P | 2024-11-06T14:15:58.602Z | 2024-11-13T14:27:37.066Z |
5483901 | 5483901 | 20241105014233_Fr65C | NL000P | 2024-11-06T14:15:51.832Z | 2024-11-13T14:27:37.003Z |
5483470 | 5483470 | 20241105004406_J9SAM | NL000P | 2024-11-06T14:15:23.410Z | 2024-11-13T14:27:36.312Z |
5483457 | 5483457 | 20241105004326_izk1d | NL000P | 2024-11-06T14:15:21.787Z | 2024-11-13T14:27:36.300Z |
5483441 | 5483441 | 20241105004208_HfZKo | NL000P | 2024-11-06T14:15:19.088Z | 2024-11-13T14:27:36.275Z |
5483409 | 5483409 | 20241105003738_vW3IU | NL000P | 2024-11-06T14:15:13.480Z | 2024-11-13T14:27:36.212Z |
5483395 | 5483395 | 20241105003528_1h2cy | NL000P | 2024-11-06T14:15:11.727Z | 2024-11-13T14:27:36.179Z |
5483318 | 5483318 | 20241105002652_Gc3Jt | NL000P | 2024-11-06T14:14:59.383Z | 2024-11-13T14:27:36.028Z |
5483307 | 5483307 | 20241105002527_sT4jG | NL000P | 2024-11-06T14:14:57.313Z | 2024-11-13T14:27:36.022Z |
5483114 | 5483114 | 20241104235939_5zefq | NL000P | 2024-11-06T14:14:40.839Z | 2024-11-13T14:27:35.741Z |
5483089 | 5483089 | 20241104235724_CpwI7 | NL000P | 2024-11-06T14:14:39.472Z | 2024-11-13T14:27:35.702Z |
5483043 | 5483043 | 20241104234942_XXE3x | NL000P | 2024-11-06T14:14:36.292Z | 2024-11-13T14:27:35.610Z |
5482981 | 5482981 | 20241104234312_LlhPO | NL000P | 2024-11-06T14:14:32.957Z | 2024-11-13T14:27:35.531Z |
5482976 | 5482976 | 20241104234247_NrQ3K | NL000P | 2024-11-06T14:14:32.715Z | 2024-11-13T14:27:35.516Z |
5482896 | 5482896 | 20241104233111_q8Jel | NL000P | 2024-11-06T14:14:16.771Z | 2024-11-13T14:27:35.331Z |
5482775 | 5482775 | 20241104231227_QKBf9 | NL000P | 2024-11-06T14:13:56.051Z | 2024-11-13T14:27:35.112Z |
5482486 | 5482486 | 20241104222814_byFTP | NL000P | 2024-11-06T14:13:15.515Z | 2024-11-13T14:27:34.705Z |
5478039 | 5478039 | 20241104031350_PTfZa | NL000P | 2024-11-05T14:17:47.446Z | 2024-11-12T14:28:13.912Z |
5477936 | 5477936 | 20241104025607_UaE2T | NL000P | 2024-11-05T14:17:37.752Z | 2024-11-12T14:28:13.382Z |
5477477 | 5477477 | 20241104020146_pnpdp | NL000P | 2024-11-05T14:16:56.447Z | 2024-11-12T14:28:11.843Z |
5477457 | 5477457 | 20241104015807_Q1f2S | NL000P | 2024-11-05T14:16:54.921Z | 2024-11-12T14:28:11.808Z |
5477384 | 5477384 | 20241104014557_XA1ky | NL000P | 2024-11-05T14:16:49.081Z | 2024-11-12T14:28:11.163Z |
5477377 | 5477377 | 20241104014457_oA3hS | NL000P | 2024-11-05T14:16:47.888Z | 2024-11-12T14:28:11.156Z |
5477360 | 5477360 | 20241104014204_5lTbY | NL000P | 2024-11-05T14:16:46.366Z | 2024-11-12T14:28:10.940Z |
5477249 | 5477249 | 20241104012553_CUb5c | NL000P | 2024-11-05T14:16:36.428Z | 2024-11-12T14:28:10.450Z |
5477219 | 5477219 | 20241104012047_ex9XL | NL000P | 2024-11-05T14:16:32.054Z | 2024-11-12T14:28:10.146Z |
5477209 | 5477209 | 20241104012023_pz3Bw | NL000P | 2024-11-05T14:16:31.577Z | 2024-11-12T14:28:10.132Z |
5477199 | 5477199 | 20241104011839_POPft | NL000P | 2024-11-05T14:16:30.848Z | 2024-11-12T14:28:10.002Z |
5477164 | 5477164 | 20241104011016_ogB2j | NL000P | 2024-11-05T14:16:28.287Z | 2024-11-12T14:28:09.919Z |
5477092 | 5477092 | 20241104010013_mGL2V | NL000P | 2024-11-05T14:16:21.832Z | 2024-11-12T14:28:09.645Z |
5477043 | 5477043 | 20241104005442_1jd1g | NL000P | 2024-11-05T14:16:19.167Z | 2024-11-12T14:28:08.381Z |
5476905 | 5476905 | 20241104003955_Me7Mw | NL000P | 2024-11-05T14:16:11.444Z | 2024-11-12T14:28:07.874Z |
5476815 | 5476815 | 20241104002916_aQ6lp | NL000P | 2024-11-05T14:16:06.191Z | 2024-11-12T14:28:07.577Z |
5476771 | 5476771 | 20241104001950_JDGne | NL000P | 2024-11-05T14:16:03.988Z | 2024-11-12T14:28:07.399Z |
5476766 | 5476766 | 20241104001930_Y0b0X | NL000P | 2024-11-05T14:16:03.747Z | 2024-11-12T14:28:07.212Z |
5476739 | 5476739 | 20241104001514_1ILDp | NL000P | 2024-11-05T14:16:02.067Z | 2024-11-12T14:28:07.079Z |
5476567 | 5476567 | 20241103234643_XFnWa | NL000P | 2024-11-05T14:15:40.634Z | 2024-11-12T14:28:06.541Z |
5476476 | 5476476 | 20241103233155_3IEwr | NL000P | 2024-11-05T14:15:28.564Z | 2024-11-12T14:28:06.158Z |
5476361 | 5476361 | 20241103231413_wX8uQ | NL000P | 2024-11-05T14:15:10.198Z | 2024-11-12T14:28:05.866Z |
5476299 | 5476299 | 20241103230253_WGZnr | NL000P | 2024-11-05T14:15:01.412Z | 2024-11-12T14:28:05.210Z |
5476253 | 5476253 | 20241103225320_4EQFk | NL000P | 2024-11-05T14:14:58.653Z | 2024-11-12T14:28:04.574Z |
5476232 | 5476232 | 20241103224942_yQsSW | NL000P | 2024-11-05T14:14:57.146Z | 2024-11-12T14:28:03.982Z |
5476165 | 5476165 | 20241103223646_wmVWz | NL000P | 2024-11-05T14:14:49.240Z | 2024-11-12T14:28:03.598Z |
5476139 | 5476139 | 20241103223221_EjVSh | NL000P | 2024-11-05T14:14:47.751Z | 2024-11-12T14:28:03.363Z |
5475998 | 5475998 | 20241103220614_h3t2a | NL000P | 2024-11-05T14:14:38.178Z | 2024-11-12T14:28:02.107Z |
5475929 | 5475929 | 20241103215454_otizR | NL000P | 2024-11-05T14:14:34.233Z | 2024-11-12T14:28:01.838Z |
5475845 | 5475845 | 20241103213604_FN7Rs | NL000P | 2024-11-05T14:14:22.029Z | 2024-11-12T14:28:01.328Z |
5475804 | 5475804 | 20241103212906_f8RUu | NL000P | 2024-11-05T14:14:14.157Z | 2024-11-12T14:28:01.093Z |
5475791 | 5475791 | 20241103212416_ubIGr | NL000P | 2024-11-05T14:14:12.777Z | 2024-11-12T14:28:01.010Z |
5475751 | 5475751 | 20241103211527_PH7Vq | NL000P | 2024-11-05T14:14:07.951Z | 2024-11-12T14:28:00.802Z |
5475555 | 5475555 | 20241103203539_De3iC | NL000P | 2024-11-05T14:13:49.117Z | 2024-11-12T14:27:59.789Z |
5475263 | 5475263 | 20241103193822_IR5cn | NL000P | 2024-11-05T14:12:55.688Z | 2024-11-12T14:27:57.870Z |
5475254 | 5475254 | 20241103193650_LK5tv | NL000P | 2024-11-05T14:12:54.924Z | 2024-11-12T14:27:57.853Z |
5475242 | 5475242 | 20241103193417_93jgQ | NL000P | 2024-11-05T14:12:51.806Z | 2024-11-12T14:27:57.830Z |
5475144 | 5475144 | 20241103191535_582W9 | NL000P | 2024-11-05T14:12:36.399Z | 2024-11-12T14:27:57.317Z |
5475100 | 5475100 | 20241103190531_gq5Ga | NL000P | 2024-11-05T14:12:31.588Z | 2024-11-12T14:27:57.128Z |
5474481 | 5474481 | 20241103172755_Dq6vN | NL000P | 2024-11-05T14:11:08.598Z | 2024-11-12T14:27:52.026Z |
5474396 | 5474396 | 20241103171007_Ztate | NL000P | 2024-11-05T14:11:02.070Z | 2024-11-12T14:27:51.221Z |
5470101 | 5470101 | 20241103053025_y9gIh | NL000P | 2024-11-04T14:17:48.001Z | 2024-11-11T14:23:04.289Z |
5470000 | 5470000 | 20241103050456_Qj0tb | NL000P | 2024-11-04T14:17:32.487Z | 2024-11-11T14:23:03.450Z |
5469867 | 5469867 | 20241103043152_dfJ6p | NL000P | 2024-11-04T14:17:12.740Z | 2024-11-11T14:23:02.580Z |
5469803 | 5469803 | 20241103042156_YEhya | NL000P | 2024-11-04T14:17:04.520Z | 2024-11-11T14:23:02.268Z |
5469693 | 5469693 | 20241103040325_wwVb7 | NL000P | 2024-11-04T14:16:52.868Z | 2024-11-11T14:23:02.003Z |
5469506 | 5469506 | 20241103033809_mK24F | NL000P | 2024-11-04T14:16:32.775Z | 2024-11-11T14:23:00.733Z |
5469485 | 5469485 | 20241103033501_rLiCa | NL000P | 2024-11-04T14:16:31.411Z | 2024-11-11T14:23:00.676Z |
5469457 | 5469457 | 20241103033109_VN2n9 | NL000P | 2024-11-04T14:16:29.591Z | 2024-11-11T14:23:00.421Z |
5469390 | 5469390 | 20241103032057_J228n | NL000P | 2024-11-04T14:16:23.377Z | 2024-11-11T14:22:59.992Z |
5469360 | 5469360 | 20241103031538_euMuz | NL000P | 2024-11-04T14:16:21.835Z | 2024-11-11T14:22:59.935Z |
5469336 | 5469336 | 20241103031147_13uDU | NL000P | 2024-11-04T14:16:20.565Z | 2024-11-11T14:22:59.896Z |
5469175 | 5469175 | 20241103024351_5hlNx | NL000P | 2024-11-04T14:15:48.746Z | 2024-11-11T14:22:58.884Z |
5469160 | 5469160 | 20241103024240_yptYX | NL000P | 2024-11-04T14:15:46.871Z | 2024-11-11T14:22:58.706Z |
5469145 | 5469145 | 20241103024123_1xqUj | NL000P | 2024-11-04T14:15:44.455Z | 2024-11-11T14:22:58.630Z |
5469068 | 5469068 | 20241103022912_7qxXD | NL000P | 2024-11-04T14:15:33.492Z | 2024-11-11T14:22:57.662Z |
5469057 | 5469057 | 20241103022851_VuwCA | NL000P | 2024-11-04T14:15:31.362Z | 2024-11-11T14:22:57.644Z |
5469032 | 5469032 | 20241103022632_1TLbj | NL000P | 2024-11-04T14:15:26.131Z | 2024-11-11T14:22:57.477Z |
5469025 | 5469025 | 20241103022551_xc3hp | NL000P | 2024-11-04T14:15:24.771Z | 2024-11-11T14:22:57.422Z |
5468897 | 5468897 | 20241103020608_R8Ef6 | NL000P | 2024-11-04T14:15:12.261Z | 2024-11-11T14:22:56.883Z |
5468777 | 5468777 | 20241103014509_WPo2k | NL000P | 2024-11-04T14:15:03.033Z | 2024-11-11T14:22:55.564Z |
5468590 | 5468590 | 20241103010239_Fr2Vo | NL000P | 2024-11-04T14:14:31.248Z | 2024-11-11T14:22:54.108Z |
5468539 | 5468539 | 20241103005307_nKZGr | NL000P | 2024-11-04T14:14:22.959Z | 2024-11-11T14:22:54.018Z |
5468450 | 5468450 | 20241103003912_FKLHg | NL000P | 2024-11-04T14:14:08.450Z | 2024-11-11T14:22:53.743Z |
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);