participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,270 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 |
---|---|---|---|---|---|
5572830 | 5572830 | 20241121031407_TGXnr | NL000U | 2024-11-22T14:18:52.092Z | 2024-11-22T14:19:22.398Z |
5563368 | 5563368 | 20241120012151_R4fnC | NL000U | 2024-11-21T14:15:59.631Z | 2024-11-22T14:21:14.156Z |
5563254 | 5563254 | 20241120011229_NHiOy | NL000U | 2024-11-21T14:15:46.536Z | 2024-11-22T14:21:11.682Z |
5561800 | 5561800 | 20241119221159_ubG3Q | NL000U | 2024-11-21T14:14:07.065Z | 2024-11-22T14:20:46.904Z |
5561761 | 5561761 | 20241119220318_cMoz3 | NL000U | 2024-11-21T14:14:01.955Z | 2024-11-22T14:20:45.692Z |
5561709 | 5561709 | 20241119214703_RphfJ | NL000U | 2024-11-21T14:13:49.318Z | 2024-11-22T14:20:43.719Z |
5561702 | 5561702 | 20241119214350_23Nbl | NL000U | 2024-11-21T14:13:48.530Z | 2024-11-22T14:20:43.613Z |
5561417 | 5561417 | 20241119202837_Yn24m | NL000U | 2024-11-21T14:13:15.164Z | 2024-11-22T14:20:35.790Z |
5558305 | 5558305 | 20241120055259_AnwyX | NL000U | 2024-11-21T14:02:58.468Z | 2024-11-22T14:19:21.207Z |
5552895 | 5552895 | 20241117230939_LCUfL | NL000U | 2024-11-19T14:09:38.355Z | 2024-11-22T14:22:48.861Z |
5548263 | 5548263 | 20241116215537_XeMp2 | NL000U | 2024-11-18T14:08:35.368Z | 2024-11-22T14:23:11.556Z |
5530985 | 5530985 | 20241112030425_2ChfG | NL000U | 2024-11-13T14:14:58.292Z | 2024-11-20T14:26:05.785Z |
5530704 | 5530704 | 20241112023838_ILDNe | NL000U | 2024-11-13T14:14:28.638Z | 2024-11-20T14:26:02.657Z |
5530284 | 5530284 | 20241112020510_2QMYB | NL000U | 2024-11-13T14:14:06.934Z | 2024-11-20T14:25:56.567Z |
5530218 | 5530218 | 20241112015705_7geWY | NL000U | 2024-11-13T14:14:02.072Z | 2024-11-20T14:25:55.484Z |
5489433 | 5489433 | 20241105185121_r91gu | NL000U | 2024-11-07T14:12:01.318Z | 2024-11-14T14:23:13.081Z |
5488978 | 5488978 | 20241105173033_yN684 | NL000U | 2024-11-07T14:11:07.473Z | 2024-11-14T14:23:09.167Z |
5488822 | 5488822 | 20241105170207_42Sf3 | NL000U | 2024-11-07T14:10:40.005Z | 2024-11-14T14:23:08.016Z |
5484412 | 5484412 | 20241105024734_KDMj2 | NL000U | 2024-11-06T14:16:53.098Z | 2024-11-13T14:27:37.943Z |
5484326 | 5484326 | 20241105023431_SUhYy | NL000U | 2024-11-06T14:16:48.376Z | 2024-11-13T14:27:37.730Z |
5484251 | 5484251 | 20241105022546_EMvZy | NL000U | 2024-11-06T14:16:37.839Z | 2024-11-13T14:27:37.576Z |
5484219 | 5484219 | 20241105022127_MQ5qc | NL000U | 2024-11-06T14:16:32.825Z | 2024-11-13T14:27:37.545Z |
5484183 | 5484183 | 20241105021807_U2hBL | NL000U | 2024-11-06T14:16:27.320Z | 2024-11-13T14:27:37.474Z |
5484094 | 5484094 | 20241105020911_3s7s7 | NL000U | 2024-11-06T14:16:12.940Z | 2024-11-13T14:27:37.271Z |
5483970 | 5483970 | 20241105014950_boY1H | NL000U | 2024-11-06T14:15:58.957Z | 2024-11-13T14:27:37.073Z |
5483965 | 5483965 | 20241105014945_mfWXy | NL000U | 2024-11-06T14:15:58.602Z | 2024-11-13T14:27:37.066Z |
5483903 | 5483903 | 20241105014233_Fr65C | NL000U | 2024-11-06T14:15:51.832Z | 2024-11-13T14:27:37.003Z |
5483893 | 5483893 | 20241105014126_PHulc | NL000U | 2024-11-06T14:15:50.896Z | 2024-11-13T14:27:36.981Z |
5483888 | 5483888 | 20241105014120_XZNLd | NL000U | 2024-11-06T14:15:50.630Z | 2024-11-13T14:27:36.975Z |
5483775 | 5483775 | 20241105012926_qcRd3 | NL000U | 2024-11-06T14:15:41.850Z | 2024-11-13T14:27:36.785Z |
5483747 | 5483747 | 20241105012617_g6Pyl | NL000U | 2024-11-06T14:15:39.861Z | 2024-11-13T14:27:36.756Z |
5483743 | 5483743 | 20241105012552_KVMId | NL000U | 2024-11-06T14:15:39.385Z | 2024-11-13T14:27:36.725Z |
5483680 | 5483680 | 20241105011832_4RNBl | NL000U | 2024-11-06T14:15:35.496Z | 2024-11-13T14:27:36.604Z |
5483663 | 5483663 | 20241105011634_vblCJ | NL000U | 2024-11-06T14:15:34.048Z | 2024-11-13T14:27:36.572Z |
5483651 | 5483651 | 20241105011447_G7zpN | NL000U | 2024-11-06T14:15:33.587Z | 2024-11-13T14:27:36.546Z |
5483556 | 5483556 | 20241105005614_t2sdW | NL000U | 2024-11-06T14:15:28.421Z | 2024-11-13T14:27:36.391Z |
5483499 | 5483499 | 20241105004521_9aZVy | NL000U | 2024-11-06T14:15:25.457Z | 2024-11-13T14:27:36.336Z |
5483459 | 5483459 | 20241105004326_izk1d | NL000U | 2024-11-06T14:15:21.787Z | 2024-11-13T14:27:36.300Z |
5483442 | 5483442 | 20241105004208_HfZKo | NL000U | 2024-11-06T14:15:19.088Z | 2024-11-13T14:27:36.275Z |
5483397 | 5483397 | 20241105003528_1h2cy | NL000U | 2024-11-06T14:15:11.727Z | 2024-11-13T14:27:36.180Z |
5483381 | 5483381 | 20241105003440_FUA2J | NL000U | 2024-11-06T14:15:06.044Z | 2024-11-13T14:27:36.146Z |
5483306 | 5483306 | 20241105002518_mXNrh | NL000U | 2024-11-06T14:14:57.171Z | 2024-11-13T14:27:36.020Z |
5483295 | 5483295 | 20241105002357_NiQnF | NL000U | 2024-11-06T14:14:54.808Z | 2024-11-13T14:27:36.001Z |
5483242 | 5483242 | 20241105001721_55lW6 | NL000U | 2024-11-06T14:14:49.129Z | 2024-11-13T14:27:35.884Z |
5483190 | 5483190 | 20241105000903_vKSdR | NL000U | 2024-11-06T14:14:45.057Z | 2024-11-13T14:27:35.827Z |
5483162 | 5483162 | 20241105000549_27BZo | NL000U | 2024-11-06T14:14:43.397Z | 2024-11-13T14:27:35.800Z |
5483116 | 5483116 | 20241104235939_5zefq | NL000U | 2024-11-06T14:14:40.839Z | 2024-11-13T14:27:35.741Z |
5483107 | 5483107 | 20241104235830_FlLm0 | NL000U | 2024-11-06T14:14:40.227Z | 2024-11-13T14:27:35.717Z |
5483044 | 5483044 | 20241104234942_XXE3x | NL000U | 2024-11-06T14:14:36.292Z | 2024-11-13T14:27:35.610Z |
5482871 | 5482871 | 20241104232652_E0PkI | NL000U | 2024-11-06T14:14:13.498Z | 2024-11-13T14:27:35.290Z |
5482849 | 5482849 | 20241104232246_Piau9 | NL000U | 2024-11-06T14:14:10.752Z | 2024-11-13T14:27:35.263Z |
5482617 | 5482617 | 20241104224857_vfn9b | NL000U | 2024-11-06T14:13:26.831Z | 2024-11-13T14:27:34.902Z |
5482567 | 5482567 | 20241104223958_bdyu8 | NL000U | 2024-11-06T14:13:21.792Z | 2024-11-13T14:27:34.827Z |
5482474 | 5482474 | 20241104222528_RbQEY | NL000U | 2024-11-06T14:13:14.660Z | 2024-11-13T14:27:34.665Z |
5482344 | 5482344 | 20241104215443_LaERV | NL000U | 2024-11-06T14:13:03.778Z | 2024-11-13T14:27:34.384Z |
5478112 | 5478112 | 20241104032308_2uscJ | NL000U | 2024-11-05T14:17:56.998Z | 2024-11-12T14:28:14.228Z |
5478041 | 5478041 | 20241104031350_PTfZa | NL000U | 2024-11-05T14:17:47.446Z | 2024-11-12T14:28:13.912Z |
5478012 | 5478012 | 20241104030837_jQM3Y | NL000U | 2024-11-05T14:17:44.753Z | 2024-11-12T14:28:13.842Z |
5477918 | 5477918 | 20241104025310_6TeEf | NL000U | 2024-11-05T14:17:36.563Z | 2024-11-12T14:28:13.288Z |
5477881 | 5477881 | 20241104025101_h333y | NL000U | 2024-11-05T14:17:33.700Z | 2024-11-12T14:28:13.141Z |
5477826 | 5477826 | 20241104024222_c5fiA | NL000U | 2024-11-05T14:17:29.065Z | 2024-11-12T14:28:13.039Z |
5477800 | 5477800 | 20241104023712_bMkrc | NL000U | 2024-11-05T14:17:26.138Z | 2024-11-12T14:28:12.965Z |
5477709 | 5477709 | 20241104022336_USPls | NL000U | 2024-11-05T14:17:18.371Z | 2024-11-12T14:28:12.479Z |
5477672 | 5477672 | 20241104021935_iMq0R | NL000U | 2024-11-05T14:17:14.130Z | 2024-11-12T14:28:12.394Z |
5477644 | 5477644 | 20241104021634_2hWCD | NL000U | 2024-11-05T14:17:11.486Z | 2024-11-12T14:28:12.207Z |
5477489 | 5477489 | 20241104020155_YCXXa | NL000U | 2024-11-05T14:16:56.912Z | 2024-11-12T14:28:11.847Z |
5477479 | 5477479 | 20241104020146_pnpdp | NL000U | 2024-11-05T14:16:56.448Z | 2024-11-12T14:28:11.844Z |
5477464 | 5477464 | 20241104015914_tid8T | NL000U | 2024-11-05T14:16:55.510Z | 2024-11-12T14:28:11.814Z |
5477420 | 5477420 | 20241104015014_t5U1q | NL000U | 2024-11-05T14:16:51.958Z | 2024-11-12T14:28:11.531Z |
5477297 | 5477297 | 20241104013402_Aa9Qv | NL000U | 2024-11-05T14:16:40.866Z | 2024-11-12T14:28:10.537Z |
5477201 | 5477201 | 20241104011839_POPft | NL000U | 2024-11-05T14:16:30.848Z | 2024-11-12T14:28:10.002Z |
5477102 | 5477102 | 20241104010056_iyX5o | NL000U | 2024-11-05T14:16:22.332Z | 2024-11-12T14:28:09.692Z |
5477074 | 5477074 | 20241104005804_ZIpM6 | NL000U | 2024-11-05T14:16:20.520Z | 2024-11-12T14:28:08.513Z |
5477045 | 5477045 | 20241104005442_1jd1g | NL000U | 2024-11-05T14:16:19.167Z | 2024-11-12T14:28:08.381Z |
5477029 | 5477029 | 20241104005354_E9zjd | NL000U | 2024-11-05T14:16:18.154Z | 2024-11-12T14:28:08.314Z |
5477007 | 5477007 | 20241104005200_sENBy | NL000U | 2024-11-05T14:16:17.056Z | 2024-11-12T14:28:08.067Z |
5476992 | 5476992 | 20241104004955_oUcl8 | NL000U | 2024-11-05T14:16:16.238Z | 2024-11-12T14:28:07.996Z |
5476983 | 5476983 | 20241104004805_bxPH0 | NL000U | 2024-11-05T14:16:15.674Z | 2024-11-12T14:28:07.971Z |
5476941 | 5476941 | 20241104004347_N2qYT | NL000U | 2024-11-05T14:16:13.087Z | 2024-11-12T14:28:07.923Z |
5476914 | 5476914 | 20241104004119_p4P4w | NL000U | 2024-11-05T14:16:11.829Z | 2024-11-12T14:28:07.889Z |
5476876 | 5476876 | 20241104003728_OhYj2 | NL000U | 2024-11-05T14:16:09.553Z | 2024-11-12T14:28:07.803Z |
5476860 | 5476860 | 20241104003623_PBClO | NL000U | 2024-11-05T14:16:08.334Z | 2024-11-12T14:28:07.752Z |
5476845 | 5476845 | 20241104003248_7lR61 | NL000U | 2024-11-05T14:16:07.458Z | 2024-11-12T14:28:07.724Z |
5476823 | 5476823 | 20241104002939_CjiZH | NL000U | 2024-11-05T14:16:06.345Z | 2024-11-12T14:28:07.583Z |
5476768 | 5476768 | 20241104001930_Y0b0X | NL000U | 2024-11-05T14:16:03.747Z | 2024-11-12T14:28:07.212Z |
5476735 | 5476735 | 20241104001428_KMFEn | NL000U | 2024-11-05T14:16:01.724Z | 2024-11-12T14:28:07.054Z |
5476731 | 5476731 | 20241104001414_lBykI | NL000U | 2024-11-05T14:16:00.976Z | 2024-11-12T14:28:07.020Z |
5476724 | 5476724 | 20241104001222_1kV6I | NL000U | 2024-11-05T14:15:59.811Z | 2024-11-12T14:28:06.990Z |
5476690 | 5476690 | 20241104000825_ziuFK | NL000U | 2024-11-05T14:15:53.860Z | 2024-11-12T14:28:06.876Z |
5476590 | 5476590 | 20241103234903_9FNWf | NL000U | 2024-11-05T14:15:41.948Z | 2024-11-12T14:28:06.549Z |
5476576 | 5476576 | 20241103234737_x17OU | NL000U | 2024-11-05T14:15:41.035Z | 2024-11-12T14:28:06.544Z |
5476530 | 5476530 | 20241103233908_sIwra | NL000U | 2024-11-05T14:15:34.581Z | 2024-11-12T14:28:06.402Z |
5476487 | 5476487 | 20241103233255_n20ls | NL000U | 2024-11-05T14:15:29.595Z | 2024-11-12T14:28:06.255Z |
5476478 | 5476478 | 20241103233155_3IEwr | NL000U | 2024-11-05T14:15:28.564Z | 2024-11-12T14:28:06.158Z |
5476404 | 5476404 | 20241103232104_SrC60 | NL000U | 2024-11-05T14:15:15.907Z | 2024-11-12T14:28:05.955Z |
5476362 | 5476362 | 20241103231413_wX8uQ | NL000U | 2024-11-05T14:15:10.198Z | 2024-11-12T14:28:05.866Z |
5476343 | 5476343 | 20241103231033_YDIGy | NL000U | 2024-11-05T14:15:07.537Z | 2024-11-12T14:28:05.789Z |
5476322 | 5476322 | 20241103230743_o21tV | NL000U | 2024-11-05T14:15:03.821Z | 2024-11-12T14:28:05.388Z |
5476209 | 5476209 | 20241103224447_IuG3W | NL000U | 2024-11-05T14:14:52.120Z | 2024-11-12T14:28:03.852Z |
5476163 | 5476163 | 20241103223644_DrmlV | NL000U | 2024-11-05T14:14:49.125Z | 2024-11-12T14:28:03.578Z |
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);