participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,779 rows where station_code = "NL000A" 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 |
---|---|---|---|---|---|
5562014 | 5562014 | 20241119224534_SW0pH | NL000A | 2024-11-21T14:14:19.695Z | 2024-11-22T14:20:51.392Z |
5490208 | 5490208 | 20241105214150_kA2Ek | NL000A | 2024-11-07T14:13:34.378Z | 2024-11-14T14:23:18.258Z |
5485324 | 5485324 | 20241105045107_59pyO | NL000A | 2024-11-06T14:18:07.545Z | 2024-11-13T14:27:41.655Z |
5485289 | 5485289 | 20241105043950_VvaRQ | NL000A | 2024-11-06T14:18:03.608Z | 2024-11-13T14:27:41.564Z |
5483891 | 5483891 | 20241105014126_PHulc | NL000A | 2024-11-06T14:15:50.896Z | 2024-11-13T14:27:36.981Z |
5483508 | 5483508 | 20241105004753_JsHt8 | NL000A | 2024-11-06T14:15:25.702Z | 2024-11-13T14:27:36.341Z |
5483300 | 5483300 | 20241105002451_FEQRt | NL000A | 2024-11-06T14:14:56.387Z | 2024-11-13T14:27:36.005Z |
5483105 | 5483105 | 20241104235830_FlLm0 | NL000A | 2024-11-06T14:14:40.226Z | 2024-11-13T14:27:35.717Z |
5482895 | 5482895 | 20241104233111_q8Jel | NL000A | 2024-11-06T14:14:16.771Z | 2024-11-13T14:27:35.331Z |
5482846 | 5482846 | 20241104232246_Piau9 | NL000A | 2024-11-06T14:14:10.752Z | 2024-11-13T14:27:35.263Z |
5482459 | 5482459 | 20241104221958_PNSOS | NL000A | 2024-11-06T14:13:13.354Z | 2024-11-13T14:27:34.626Z |
5482403 | 5482403 | 20241104220715_dmS2v | NL000A | 2024-11-06T14:13:07.881Z | 2024-11-13T14:27:34.487Z |
5482173 | 5482173 | 20241104212017_RPQjF | NL000A | 2024-11-06T14:12:31.220Z | 2024-11-13T14:27:34.071Z |
5478242 | 5478242 | 20241104034039_3cRHB | NL000A | 2024-11-05T14:18:05.938Z | 2024-11-12T14:28:14.653Z |
5478173 | 5478173 | 20241104033159_jSY8f | NL000A | 2024-11-05T14:18:01.773Z | 2024-11-12T14:28:14.479Z |
5478014 | 5478014 | 20241104030848_S5Jhu | NL000A | 2024-11-05T14:17:44.837Z | 2024-11-12T14:28:13.849Z |
5477708 | 5477708 | 20241104022336_USPls | NL000A | 2024-11-05T14:17:18.371Z | 2024-11-12T14:28:12.479Z |
5477487 | 5477487 | 20241104020155_YCXXa | NL000A | 2024-11-05T14:16:56.912Z | 2024-11-12T14:28:11.847Z |
5477350 | 5477350 | 20241104014115_fHfzl | NL000A | 2024-11-05T14:16:45.759Z | 2024-11-12T14:28:10.936Z |
5477296 | 5477296 | 20241104013402_Aa9Qv | NL000A | 2024-11-05T14:16:40.866Z | 2024-11-12T14:28:10.537Z |
5477028 | 5477028 | 20241104005354_E9zjd | NL000A | 2024-11-05T14:16:18.154Z | 2024-11-12T14:28:08.314Z |
5476913 | 5476913 | 20241104004119_p4P4w | NL000A | 2024-11-05T14:16:11.829Z | 2024-11-12T14:28:07.889Z |
5476812 | 5476812 | 20241104002753_E0e9h | NL000A | 2024-11-05T14:16:06.137Z | 2024-11-12T14:28:07.569Z |
5476560 | 5476560 | 20241103234536_3wGdp | NL000A | 2024-11-05T14:15:39.798Z | 2024-11-12T14:28:06.521Z |
5476486 | 5476486 | 20241103233255_n20ls | NL000A | 2024-11-05T14:15:29.595Z | 2024-11-12T14:28:06.255Z |
5476369 | 5476369 | 20241103231604_Rmae3 | NL000A | 2024-11-05T14:15:11.315Z | 2024-11-12T14:28:05.885Z |
5476332 | 5476332 | 20241103230932_9fq14 | NL000A | 2024-11-05T14:15:05.317Z | 2024-11-12T14:28:05.520Z |
5475735 | 5475735 | 20241103211114_KdlEK | NL000A | 2024-11-05T14:14:04.349Z | 2024-11-12T14:28:00.768Z |
5475704 | 5475704 | 20241103210724_A2XdT | NL000A | 2024-11-05T14:14:02.322Z | 2024-11-12T14:28:00.590Z |
5475655 | 5475655 | 20241103205546_LjEQ8 | NL000A | 2024-11-05T14:13:56.524Z | 2024-11-12T14:28:00.178Z |
5475563 | 5475563 | 20241103203606_HQaMf | NL000A | 2024-11-05T14:13:49.487Z | 2024-11-12T14:27:59.842Z |
5475342 | 5475342 | 20241103195129_gonKO | NL000A | 2024-11-05T14:13:13.960Z | 2024-11-12T14:27:57.979Z |
5470008 | 5470008 | 20241103050738_88hKE | NL000A | 2024-11-04T14:17:33.553Z | 2024-11-11T14:23:03.481Z |
5469895 | 5469895 | 20241103043755_YQLs8 | NL000A | 2024-11-04T14:17:15.518Z | 2024-11-11T14:23:02.985Z |
5469626 | 5469626 | 20241103035422_P2ZG1 | NL000A | 2024-11-04T14:16:41.417Z | 2024-11-11T14:23:01.753Z |
5469579 | 5469579 | 20241103034726_9DbQQ | NL000A | 2024-11-04T14:16:37.521Z | 2024-11-11T14:23:01.206Z |
5469131 | 5469131 | 20241103024011_OeoEo | NL000A | 2024-11-04T14:15:42.613Z | 2024-11-11T14:22:58.539Z |
5468963 | 5468963 | 20241103021440_5KcZ5 | NL000A | 2024-11-04T14:15:18.700Z | 2024-11-11T14:22:57.145Z |
5468948 | 5468948 | 20241103021410_3Zli9 | NL000A | 2024-11-04T14:15:18.116Z | 2024-11-11T14:22:57.107Z |
5468074 | 5468074 | 20241102232536_FHynQ | NL000A | 2024-11-04T14:13:12.925Z | 2024-11-11T14:22:51.215Z |
5467968 | 5467968 | 20241102230304_kyLSj | NL000A | 2024-11-04T14:13:02.743Z | 2024-11-11T14:22:50.625Z |
5467622 | 5467622 | 20241102220400_Hfdrv | NL000A | 2024-11-04T14:12:14.543Z | 2024-11-11T14:22:48.535Z |
5467608 | 5467608 | 20241102220252_KQZaq | NL000A | 2024-11-04T14:12:13.741Z | 2024-11-11T14:22:47.856Z |
5467579 | 5467579 | 20241102215914_b1tlN | NL000A | 2024-11-04T14:12:06.281Z | 2024-11-11T14:22:47.607Z |
5467557 | 5467557 | 20241102214652_PlWIr | NL000A | 2024-11-04T14:12:01.451Z | 2024-11-11T14:22:47.561Z |
5467507 | 5467507 | 20241102213310_pA1t3 | NL000A | 2024-11-04T14:11:47.595Z | 2024-11-11T14:22:47.403Z |
5467495 | 5467495 | 20241102212929_sZifi | NL000A | 2024-11-04T14:11:44.307Z | 2024-11-11T14:22:47.368Z |
5466645 | 5466645 | 20241102182352_2pk7i | NL000A | 2024-11-04T14:09:29.348Z | 2024-11-11T14:22:42.189Z |
5451630 | 5451630 | 20241101003611_nLGFF | NL000A | 2024-11-02T12:17:42.095Z | 2024-11-09T14:24:24.505Z |
5451442 | 5451442 | 20241031235618_ozF9U | NL000A | 2024-11-02T12:17:10.103Z | 2024-11-09T14:24:23.664Z |
5421025 | 5421025 | 20241028042017_ZTTuD | NL000A | 2024-10-30T12:19:33.183Z | 2024-11-05T14:27:17.055Z |
5420754 | 5420754 | 20241028033120_KY0Ju | NL000A | 2024-10-30T12:19:15.027Z | 2024-11-05T14:27:16.247Z |
5419719 | 5419719 | 20241028005352_ffcME | NL000A | 2024-10-30T12:17:48.372Z | 2024-11-05T14:27:13.808Z |
5418490 | 5418490 | 20241027205609_8g43T | NL000A | 2024-10-30T12:15:44.691Z | 2024-11-05T14:27:10.206Z |
5417143 | 5417143 | 20241027175100_rw4dE | NL000A | 2024-10-30T12:13:02.992Z | 2024-11-05T14:27:06.578Z |
5405009 | 5405009 | 20241027000845_9ba6O | NL000A | 2024-10-29T12:12:16.061Z | 2024-11-04T14:28:52.538Z |
5404556 | 5404556 | 20241026233633_ngl4K | NL000A | 2024-10-29T12:11:42.325Z | 2024-11-04T14:28:51.319Z |
5403862 | 5403862 | 20241026223958_Zw8jQ | NL000A | 2024-10-29T12:10:22.061Z | 2024-11-04T14:28:49.883Z |
5402492 | 5402492 | 20241026194445_gK2Vx | NL000A | 2024-10-29T12:07:23.886Z | 2024-11-04T14:28:44.776Z |
5398908 | 5398908 | 20241026033702_22uxt | NL000A | 2024-10-28T12:19:39.842Z | 2024-11-03T14:27:38.583Z |
5398428 | 5398428 | 20241026025552_oESYB | NL000A | 2024-10-28T12:19:16.808Z | 2024-11-03T14:27:36.367Z |
5398268 | 5398268 | 20241026024005_SCl6r | NL000A | 2024-10-28T12:19:08.670Z | 2024-11-03T14:27:35.764Z |
5398164 | 5398164 | 20241026023052_oa0zp | NL000A | 2024-10-28T12:19:03.485Z | 2024-11-03T14:27:35.610Z |
5397266 | 5397266 | 20241026011400_r1Tg3 | NL000A | 2024-10-28T12:18:13.880Z | 2024-11-03T14:27:32.473Z |
5396875 | 5396875 | 20241026004323_6m1n8 | NL000A | 2024-10-28T12:17:58.591Z | 2024-11-03T14:27:31.277Z |
5396367 | 5396367 | 20241025235951_TIZfq | NL000A | 2024-10-28T12:17:36.305Z | 2024-11-03T14:27:29.636Z |
5396184 | 5396184 | 20241025234608_nd6YO | NL000A | 2024-10-28T12:17:24.596Z | 2024-11-03T14:27:28.839Z |
5396157 | 5396157 | 20241025234400_zWLeC | NL000A | 2024-10-28T12:17:21.854Z | 2024-11-03T14:27:28.745Z |
5396153 | 5396153 | 20241025234400_Qh15O | NL000A | 2024-10-28T12:17:21.524Z | 2024-11-03T14:27:28.696Z |
5395931 | 5395931 | 20241025232331_9703f | NL000A | 2024-10-28T12:17:05.501Z | 2024-11-03T14:27:27.642Z |
5395892 | 5395892 | 20241025232001_lQ2xC | NL000A | 2024-10-28T12:17:03.912Z | 2024-11-03T14:27:27.566Z |
5395586 | 5395586 | 20241025225707_AyRz1 | NL000A | 2024-10-28T12:16:28.691Z | 2024-11-03T14:27:26.081Z |
5395342 | 5395342 | 20241025223410_6uVaE | NL000A | 2024-10-28T12:16:10.187Z | 2024-11-03T14:27:25.160Z |
5395268 | 5395268 | 20241025222850_PsRmy | NL000A | 2024-10-28T12:16:03.952Z | 2024-11-03T14:27:24.547Z |
5393780 | 5393780 | 20241025184227_QBDQC | NL000A | 2024-10-28T12:13:19.870Z | 2024-11-03T14:27:18.176Z |
5393422 | 5393422 | 20241025173456_z93DS | NL000A | 2024-10-28T12:12:33.099Z | 2024-11-03T14:27:15.373Z |
5386142 | 5386142 | 20241025000636_ZJe2t | NL000A | 2024-10-27T12:19:52.173Z | 2024-11-02T12:28:30.726Z |
5377638 | 5377638 | 20241024050144_KzTfu | NL000A | 2024-10-26T12:22:43.016Z | 2024-11-01T12:27:02.689Z |
5376458 | 5376458 | 20241024035616_J6b6t | NL000A | 2024-10-26T12:22:02.639Z | 2024-11-01T12:27:01.562Z |
5374031 | 5374031 | 20241024020623_67Y19 | NL000A | 2024-10-26T12:20:34.927Z | 2024-11-01T12:26:58.629Z |
5373411 | 5373411 | 20241024013715_h2OtL | NL000A | 2024-10-26T12:20:10.306Z | 2024-11-01T12:26:58.248Z |
5372959 | 5372959 | 20241024011616_njPEw | NL000A | 2024-10-26T12:19:49.924Z | 2024-11-01T12:26:58.045Z |
5365983 | 5365983 | 20241024000010_K5M9O | NL000A | 2024-10-25T12:18:13.263Z | 2024-11-01T12:26:56.516Z |
5365078 | 5365078 | 20241023231221_EBXja | NL000A | 2024-10-25T12:17:45.133Z | 2024-11-01T12:26:55.849Z |
5364847 | 5364847 | 20241023225714_ovUPa | NL000A | 2024-10-25T12:17:36.968Z | 2024-11-01T12:26:55.684Z |
5364811 | 5364811 | 20241023225418_M87BS | NL000A | 2024-10-25T12:17:35.951Z | 2024-11-01T12:26:55.637Z |
5363137 | 5363137 | 20241023202854_jfevG | NL000A | 2024-10-25T12:15:31.890Z | 2024-11-01T12:26:52.875Z |
5362993 | 5362993 | 20241023201632_2QPWK | NL000A | 2024-10-25T12:15:22.586Z | 2024-11-01T12:26:52.768Z |
5361019 | 5361019 | 20241023174142_5ugL5 | NL000A | 2024-10-25T12:12:08.580Z | 2024-11-01T12:26:48.671Z |
5352625 | 5352625 | 20241023004158_pKbUM | NL000A | 2024-10-24T12:19:01.202Z | 2024-10-31T12:30:03.002Z |
5351986 | 5351986 | 20241023000349_Em4d7 | NL000A | 2024-10-24T12:18:12.522Z | 2024-10-31T12:30:01.470Z |
5350427 | 5350427 | 20241022214725_PuIdA | NL000A | 2024-10-24T12:15:44.765Z | 2024-10-31T12:29:58.151Z |
5350325 | 5350325 | 20241022213548_Mi7kZ | NL000A | 2024-10-24T12:15:36.408Z | 2024-10-31T12:29:57.939Z |
5350275 | 5350275 | 20241022213113_flwDv | NL000A | 2024-10-24T12:15:32.612Z | 2024-10-31T12:29:57.657Z |
5348135 | 5348135 | 20241022173049_5SZxQ | NL000A | 2024-10-24T12:10:22.760Z | 2024-10-31T12:29:51.600Z |
5326588 | 5326588 | 20241019190511_LQv3M | NL000A | 2024-10-21T12:09:59.922Z | 2024-10-28T12:26:42.068Z |
5321485 | 5321485 | 20241018045738_viPCl | NL000A | 2024-10-19T12:07:38.560Z | 2024-10-26T12:27:56.886Z |
5318117 | 5318117 | 20241016211335_YZkvD | NL000A | 2024-10-18T12:02:56.237Z | 2024-10-25T12:24:33.349Z |
5317512 | 5317512 | 20241015022606_rS780 | NL000A | 2024-10-17T12:11:08.499Z | 2024-10-23T12:24:47.070Z |
5317506 | 5317506 | 20241015021238_GuNFW | NL000A | 2024-10-17T12:11:04.804Z | 2024-10-23T12:24:45.990Z |
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);