participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,255 rows where station_code = "NL000U" 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 |
---|---|---|---|---|---|
5489433 | 5489433 | 20241105185121_r91gu | NL000U | 2024-11-07T14:12:01.318Z | 2024-11-09T14:19:42.790Z |
5488978 | 5488978 | 20241105173033_yN684 | NL000U | 2024-11-07T14:11:07.473Z | 2024-11-09T14:19:34.818Z |
5488822 | 5488822 | 20241105170207_42Sf3 | NL000U | 2024-11-07T14:10:40.005Z | 2024-11-09T14:19:33.605Z |
5484412 | 5484412 | 20241105024734_KDMj2 | NL000U | 2024-11-06T14:16:53.098Z | 2024-11-09T14:21:13.849Z |
5484326 | 5484326 | 20241105023431_SUhYy | NL000U | 2024-11-06T14:16:48.376Z | 2024-11-09T14:21:13.274Z |
5484251 | 5484251 | 20241105022546_EMvZy | NL000U | 2024-11-06T14:16:37.839Z | 2024-11-09T14:21:12.321Z |
5484219 | 5484219 | 20241105022127_MQ5qc | NL000U | 2024-11-06T14:16:32.825Z | 2024-11-09T14:21:11.958Z |
5484183 | 5484183 | 20241105021807_U2hBL | NL000U | 2024-11-06T14:16:27.320Z | 2024-11-09T14:21:11.694Z |
5484094 | 5484094 | 20241105020911_3s7s7 | NL000U | 2024-11-06T14:16:12.940Z | 2024-11-09T14:21:10.617Z |
5483970 | 5483970 | 20241105014950_boY1H | NL000U | 2024-11-06T14:15:58.957Z | 2024-11-09T14:21:09.723Z |
5483965 | 5483965 | 20241105014945_mfWXy | NL000U | 2024-11-06T14:15:58.602Z | 2024-11-09T14:21:09.713Z |
5483903 | 5483903 | 20241105014233_Fr65C | NL000U | 2024-11-06T14:15:51.832Z | 2024-11-09T14:21:09.289Z |
5483893 | 5483893 | 20241105014126_PHulc | NL000U | 2024-11-06T14:15:50.896Z | 2024-11-09T14:21:09.038Z |
5483888 | 5483888 | 20241105014120_XZNLd | NL000U | 2024-11-06T14:15:50.630Z | 2024-11-09T14:21:09.033Z |
5483775 | 5483775 | 20241105012926_qcRd3 | NL000U | 2024-11-06T14:15:41.850Z | 2024-11-09T14:21:07.539Z |
5483747 | 5483747 | 20241105012617_g6Pyl | NL000U | 2024-11-06T14:15:39.861Z | 2024-11-09T14:21:07.327Z |
5483743 | 5483743 | 20241105012552_KVMId | NL000U | 2024-11-06T14:15:39.385Z | 2024-11-09T14:21:07.249Z |
5483680 | 5483680 | 20241105011832_4RNBl | NL000U | 2024-11-06T14:15:35.496Z | 2024-11-09T14:21:06.754Z |
5483663 | 5483663 | 20241105011634_vblCJ | NL000U | 2024-11-06T14:15:34.048Z | 2024-11-09T14:21:06.530Z |
5483651 | 5483651 | 20241105011447_G7zpN | NL000U | 2024-11-06T14:15:33.587Z | 2024-11-09T14:21:06.504Z |
5483556 | 5483556 | 20241105005614_t2sdW | NL000U | 2024-11-06T14:15:28.421Z | 2024-11-09T14:21:05.883Z |
5483499 | 5483499 | 20241105004521_9aZVy | NL000U | 2024-11-06T14:15:25.457Z | 2024-11-09T14:21:05.660Z |
5483459 | 5483459 | 20241105004326_izk1d | NL000U | 2024-11-06T14:15:21.787Z | 2024-11-09T14:21:05.535Z |
5483442 | 5483442 | 20241105004208_HfZKo | NL000U | 2024-11-06T14:15:19.088Z | 2024-11-09T14:21:05.449Z |
5483397 | 5483397 | 20241105003528_1h2cy | NL000U | 2024-11-06T14:15:11.727Z | 2024-11-09T14:21:05.211Z |
5483381 | 5483381 | 20241105003440_FUA2J | NL000U | 2024-11-06T14:15:06.044Z | 2024-11-09T14:21:05.100Z |
5483306 | 5483306 | 20241105002518_mXNrh | NL000U | 2024-11-06T14:14:57.171Z | 2024-11-09T14:21:04.726Z |
5483295 | 5483295 | 20241105002357_NiQnF | NL000U | 2024-11-06T14:14:54.808Z | 2024-11-09T14:21:04.656Z |
5483242 | 5483242 | 20241105001721_55lW6 | NL000U | 2024-11-06T14:14:49.129Z | 2024-11-09T14:21:04.277Z |
5483190 | 5483190 | 20241105000903_vKSdR | NL000U | 2024-11-06T14:14:45.057Z | 2024-11-09T14:21:03.987Z |
5483162 | 5483162 | 20241105000549_27BZo | NL000U | 2024-11-06T14:14:43.397Z | 2024-11-09T14:21:03.831Z |
5483116 | 5483116 | 20241104235939_5zefq | NL000U | 2024-11-06T14:14:40.839Z | 2024-11-09T14:21:03.558Z |
5483107 | 5483107 | 20241104235830_FlLm0 | NL000U | 2024-11-06T14:14:40.227Z | 2024-11-09T14:21:03.497Z |
5483044 | 5483044 | 20241104234942_XXE3x | NL000U | 2024-11-06T14:14:36.292Z | 2024-11-09T14:21:03.092Z |
5482871 | 5482871 | 20241104232652_E0PkI | NL000U | 2024-11-06T14:14:13.498Z | 2024-11-09T14:21:02.086Z |
5482849 | 5482849 | 20241104232246_Piau9 | NL000U | 2024-11-06T14:14:10.752Z | 2024-11-09T14:21:01.948Z |
5482617 | 5482617 | 20241104224857_vfn9b | NL000U | 2024-11-06T14:13:26.831Z | 2024-11-09T14:21:00.570Z |
5482567 | 5482567 | 20241104223958_bdyu8 | NL000U | 2024-11-06T14:13:21.792Z | 2024-11-09T14:21:00.274Z |
5482474 | 5482474 | 20241104222528_RbQEY | NL000U | 2024-11-06T14:13:14.660Z | 2024-11-09T14:20:59.674Z |
5482344 | 5482344 | 20241104215443_LaERV | NL000U | 2024-11-06T14:13:03.778Z | 2024-11-09T14:20:58.406Z |
5478112 | 5478112 | 20241104032308_2uscJ | NL000U | 2024-11-05T14:17:56.998Z | 2024-11-09T14:22:25.267Z |
5478041 | 5478041 | 20241104031350_PTfZa | NL000U | 2024-11-05T14:17:47.446Z | 2024-11-09T14:22:24.101Z |
5478012 | 5478012 | 20241104030837_jQM3Y | NL000U | 2024-11-05T14:17:44.753Z | 2024-11-09T14:22:23.638Z |
5477918 | 5477918 | 20241104025310_6TeEf | NL000U | 2024-11-05T14:17:36.563Z | 2024-11-09T14:22:22.906Z |
5477881 | 5477881 | 20241104025101_h333y | NL000U | 2024-11-05T14:17:33.700Z | 2024-11-09T14:22:22.663Z |
5477826 | 5477826 | 20241104024222_c5fiA | NL000U | 2024-11-05T14:17:29.065Z | 2024-11-09T14:22:22.375Z |
5477800 | 5477800 | 20241104023712_bMkrc | NL000U | 2024-11-05T14:17:26.138Z | 2024-11-09T14:22:22.090Z |
5477709 | 5477709 | 20241104022336_USPls | NL000U | 2024-11-05T14:17:18.371Z | 2024-11-09T14:22:21.113Z |
5477672 | 5477672 | 20241104021935_iMq0R | NL000U | 2024-11-05T14:17:14.130Z | 2024-11-09T14:22:20.681Z |
5477644 | 5477644 | 20241104021634_2hWCD | NL000U | 2024-11-05T14:17:11.486Z | 2024-11-09T14:22:20.289Z |
5477489 | 5477489 | 20241104020155_YCXXa | NL000U | 2024-11-05T14:16:56.912Z | 2024-11-09T14:22:18.314Z |
5477479 | 5477479 | 20241104020146_pnpdp | NL000U | 2024-11-05T14:16:56.448Z | 2024-11-09T14:22:18.236Z |
5477464 | 5477464 | 20241104015914_tid8T | NL000U | 2024-11-05T14:16:55.510Z | 2024-11-09T14:22:17.969Z |
5477420 | 5477420 | 20241104015014_t5U1q | NL000U | 2024-11-05T14:16:51.958Z | 2024-11-09T14:22:17.544Z |
5477297 | 5477297 | 20241104013402_Aa9Qv | NL000U | 2024-11-05T14:16:40.866Z | 2024-11-09T14:22:16.349Z |
5477201 | 5477201 | 20241104011839_POPft | NL000U | 2024-11-05T14:16:30.848Z | 2024-11-09T14:22:15.551Z |
5477102 | 5477102 | 20241104010056_iyX5o | NL000U | 2024-11-05T14:16:22.332Z | 2024-11-09T14:22:14.326Z |
5477074 | 5477074 | 20241104005804_ZIpM6 | NL000U | 2024-11-05T14:16:20.520Z | 2024-11-09T14:22:14.153Z |
5477045 | 5477045 | 20241104005442_1jd1g | NL000U | 2024-11-05T14:16:19.167Z | 2024-11-09T14:22:13.975Z |
5477029 | 5477029 | 20241104005354_E9zjd | NL000U | 2024-11-05T14:16:18.154Z | 2024-11-09T14:22:13.883Z |
5477007 | 5477007 | 20241104005200_sENBy | NL000U | 2024-11-05T14:16:17.056Z | 2024-11-09T14:22:13.794Z |
5476992 | 5476992 | 20241104004955_oUcl8 | NL000U | 2024-11-05T14:16:16.238Z | 2024-11-09T14:22:13.694Z |
5476983 | 5476983 | 20241104004805_bxPH0 | NL000U | 2024-11-05T14:16:15.674Z | 2024-11-09T14:22:13.645Z |
5476941 | 5476941 | 20241104004347_N2qYT | NL000U | 2024-11-05T14:16:13.087Z | 2024-11-09T14:22:13.442Z |
5476914 | 5476914 | 20241104004119_p4P4w | NL000U | 2024-11-05T14:16:11.829Z | 2024-11-09T14:22:13.301Z |
5476876 | 5476876 | 20241104003728_OhYj2 | NL000U | 2024-11-05T14:16:09.553Z | 2024-11-09T14:22:13.002Z |
5476860 | 5476860 | 20241104003623_PBClO | NL000U | 2024-11-05T14:16:08.334Z | 2024-11-09T14:22:12.860Z |
5476845 | 5476845 | 20241104003248_7lR61 | NL000U | 2024-11-05T14:16:07.458Z | 2024-11-09T14:22:12.714Z |
5476823 | 5476823 | 20241104002939_CjiZH | NL000U | 2024-11-05T14:16:06.345Z | 2024-11-09T14:22:12.579Z |
5476768 | 5476768 | 20241104001930_Y0b0X | NL000U | 2024-11-05T14:16:03.747Z | 2024-11-09T14:22:12.288Z |
5476735 | 5476735 | 20241104001428_KMFEn | NL000U | 2024-11-05T14:16:01.724Z | 2024-11-09T14:22:12.006Z |
5476731 | 5476731 | 20241104001414_lBykI | NL000U | 2024-11-05T14:16:00.976Z | 2024-11-09T14:22:11.986Z |
5476724 | 5476724 | 20241104001222_1kV6I | NL000U | 2024-11-05T14:15:59.811Z | 2024-11-09T14:22:11.918Z |
5476690 | 5476690 | 20241104000825_ziuFK | NL000U | 2024-11-05T14:15:53.860Z | 2024-11-09T14:22:11.779Z |
5476590 | 5476590 | 20241103234903_9FNWf | NL000U | 2024-11-05T14:15:41.948Z | 2024-11-09T14:22:10.998Z |
5476576 | 5476576 | 20241103234737_x17OU | NL000U | 2024-11-05T14:15:41.035Z | 2024-11-09T14:22:10.941Z |
5476530 | 5476530 | 20241103233908_sIwra | NL000U | 2024-11-05T14:15:34.581Z | 2024-11-09T14:22:10.289Z |
5476487 | 5476487 | 20241103233255_n20ls | NL000U | 2024-11-05T14:15:29.595Z | 2024-11-09T14:22:10.019Z |
5476478 | 5476478 | 20241103233155_3IEwr | NL000U | 2024-11-05T14:15:28.564Z | 2024-11-09T14:22:09.857Z |
5476404 | 5476404 | 20241103232104_SrC60 | NL000U | 2024-11-05T14:15:15.907Z | 2024-11-09T14:22:09.159Z |
5476362 | 5476362 | 20241103231413_wX8uQ | NL000U | 2024-11-05T14:15:10.198Z | 2024-11-09T14:22:08.770Z |
5476343 | 5476343 | 20241103231033_YDIGy | NL000U | 2024-11-05T14:15:07.537Z | 2024-11-09T14:22:08.474Z |
5476322 | 5476322 | 20241103230743_o21tV | NL000U | 2024-11-05T14:15:03.821Z | 2024-11-09T14:22:07.813Z |
5476209 | 5476209 | 20241103224447_IuG3W | NL000U | 2024-11-05T14:14:52.120Z | 2024-11-09T14:22:06.946Z |
5476163 | 5476163 | 20241103223644_DrmlV | NL000U | 2024-11-05T14:14:49.125Z | 2024-11-09T14:22:06.303Z |
5476147 | 5476147 | 20241103223412_deRZ2 | NL000U | 2024-11-05T14:14:48.312Z | 2024-11-09T14:22:06.170Z |
5476102 | 5476102 | 20241103222419_uv07o | NL000U | 2024-11-05T14:14:45.289Z | 2024-11-09T14:22:05.798Z |
5476085 | 5476085 | 20241103221732_S435C | NL000U | 2024-11-05T14:14:43.848Z | 2024-11-09T14:22:05.596Z |
5476014 | 5476014 | 20241103220755_1blLV | NL000U | 2024-11-05T14:14:39.191Z | 2024-11-09T14:22:04.779Z |
5475992 | 5475992 | 20241103220429_q31Mk | NL000U | 2024-11-05T14:14:37.548Z | 2024-11-09T14:22:04.470Z |
5475961 | 5475961 | 20241103220026_48NBx | NL000U | 2024-11-05T14:14:35.725Z | 2024-11-09T14:22:04.164Z |
5475917 | 5475917 | 20241103215006_lxrLC | NL000U | 2024-11-05T14:14:33.386Z | 2024-11-09T14:22:03.901Z |
5475863 | 5475863 | 20241103214220_XWEIr | NL000U | 2024-11-05T14:14:23.903Z | 2024-11-09T14:22:02.999Z |
5475814 | 5475814 | 20241103212951_Z5Y9b | NL000U | 2024-11-05T14:14:16.553Z | 2024-11-09T14:22:02.572Z |
5475792 | 5475792 | 20241103212416_ubIGr | NL000U | 2024-11-05T14:14:12.777Z | 2024-11-09T14:22:02.268Z |
5475758 | 5475758 | 20241103211805_iL3Ds | NL000U | 2024-11-05T14:14:08.647Z | 2024-11-09T14:22:01.966Z |
5475707 | 5475707 | 20241103210724_A2XdT | NL000U | 2024-11-05T14:14:02.322Z | 2024-11-09T14:22:01.292Z |
5475565 | 5475565 | 20241103203606_HQaMf | NL000U | 2024-11-05T14:13:49.487Z | 2024-11-09T14:22:00.049Z |
5475544 | 5475544 | 20241103203209_9Srmr | NL000U | 2024-11-05T14:13:47.386Z | 2024-11-09T14:21:59.871Z |
5475529 | 5475529 | 20241103202652_RlDQX | NL000U | 2024-11-05T14:13:46.350Z | 2024-11-09T14:21:59.690Z |
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);