participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,942 rows where station_code = "NL0001" 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 |
---|---|---|---|---|---|
5451269 | 5451269 | 20241031231804_8WyIT | NL0001 | 2024-11-02T12:16:47.096Z | 2024-11-03T14:21:34.516Z |
5450858 | 5450858 | 20241031212218_MUbI1 | NL0001 | 2024-11-02T12:16:05.102Z | 2024-11-03T14:21:24.658Z |
5450496 | 5450496 | 20241031193006_r2rbJ | NL0001 | 2024-11-02T12:15:31.447Z | 2024-11-03T14:21:16.556Z |
5450306 | 5450306 | 20241031183718_bSYjT | NL0001 | 2024-11-02T12:14:55.480Z | 2024-11-03T14:21:10.760Z |
5450247 | 5450247 | 20241031182500_KC3Cb | NL0001 | 2024-11-02T12:14:50.945Z | 2024-11-03T14:21:09.345Z |
5421247 | 5421247 | 20241028051606_UHQlv | NL0001 | 2024-10-30T12:19:45.536Z | 2024-11-03T14:26:05.317Z |
5421194 | 5421194 | 20241028050357_2dKZr | NL0001 | 2024-10-30T12:19:41.517Z | 2024-11-03T14:26:04.998Z |
5420841 | 5420841 | 20241028034358_XETY9 | NL0001 | 2024-10-30T12:19:21.555Z | 2024-11-03T14:26:03.391Z |
5420646 | 5420646 | 20241028031149_EAN2F | NL0001 | 2024-10-30T12:19:07.876Z | 2024-11-03T14:26:02.757Z |
5420433 | 5420433 | 20241028024158_cstY5 | NL0001 | 2024-10-30T12:18:51.290Z | 2024-11-03T14:26:01.991Z |
5419631 | 5419631 | 20241028003158_88a5b | NL0001 | 2024-10-30T12:17:40.288Z | 2024-11-03T14:25:59.684Z |
5419432 | 5419432 | 20241028000009_LKkpa | NL0001 | 2024-10-30T12:17:26.736Z | 2024-11-03T14:25:58.705Z |
5419272 | 5419272 | 20241027232651_RKZU5 | NL0001 | 2024-10-30T12:17:18.138Z | 2024-11-03T14:25:57.754Z |
5418871 | 5418871 | 20241027221712_A51G3 | NL0001 | 2024-10-30T12:16:25.225Z | 2024-11-03T14:25:55.206Z |
5418810 | 5418810 | 20241027220002_0Rc5k | NL0001 | 2024-10-30T12:16:14.780Z | 2024-11-03T14:25:54.893Z |
5418010 | 5418010 | 20241027193952_1kjDI | NL0001 | 2024-10-30T12:14:44.590Z | 2024-11-03T14:25:48.443Z |
5417983 | 5417983 | 20241027193632_8dZt1 | NL0001 | 2024-10-30T12:14:42.140Z | 2024-11-03T14:25:48.284Z |
5417669 | 5417669 | 20241027185937_5euCc | NL0001 | 2024-10-30T12:14:09.444Z | 2024-11-03T14:25:45.853Z |
5417641 | 5417641 | 20241027185629_Yrwjd | NL0001 | 2024-10-30T12:14:04.516Z | 2024-11-03T14:25:45.755Z |
5417585 | 5417585 | 20241027184905_3aaZL | NL0001 | 2024-10-30T12:13:54.253Z | 2024-11-03T14:25:45.594Z |
5417445 | 5417445 | 20241027183433_e1XcA | NL0001 | 2024-10-30T12:13:41.191Z | 2024-11-03T14:25:45.154Z |
5399892 | 5399892 | 20241026051049_7iHBL | NL0001 | 2024-10-28T12:20:15.278Z | 2024-11-03T14:27:40.684Z |
5399625 | 5399625 | 20241026044135_3G3FS | NL0001 | 2024-10-28T12:20:04.409Z | 2024-11-03T14:27:40.093Z |
5399485 | 5399485 | 20241026042701_EeRyd | NL0001 | 2024-10-28T12:20:00.534Z | 2024-11-03T14:27:39.843Z |
5395295 | 5395295 | 20241025223033_7yTKw | NL0001 | 2024-10-28T12:16:05.031Z | 2024-11-03T14:27:24.747Z |
5394794 | 5394794 | 20241025212837_uZ9pJ | NL0001 | 2024-10-28T12:15:25.891Z | 2024-11-03T14:27:22.778Z |
5394543 | 5394543 | 20241025204755_If8Vd | NL0001 | 2024-10-28T12:14:52.848Z | 2024-11-03T14:27:21.514Z |
5387137 | 5387137 | 20241025020403_1Uedy | NL0001 | 2024-10-27T12:20:55.531Z | 2024-11-02T12:28:32.153Z |
5383287 | 5383287 | 20241024180414_gzztk | NL0001 | 2024-10-27T12:15:07.897Z | 2024-11-02T12:28:24.884Z |
5383175 | 5383175 | 20241024175055_cawIp | NL0001 | 2024-10-27T12:14:52.983Z | 2024-11-02T12:28:24.762Z |
5383066 | 5383066 | 20241024173945_g6Y2P | NL0001 | 2024-10-27T12:14:43.487Z | 2024-11-02T12:28:24.659Z |
5377567 | 5377567 | 20241024045745_vXcwG | NL0001 | 2024-10-26T12:22:41.043Z | 2024-11-01T12:27:02.608Z |
5377167 | 5377167 | 20241024043638_Gj7fV | NL0001 | 2024-10-26T12:22:29.694Z | 2024-11-01T12:27:02.251Z |
5376925 | 5376925 | 20241024042317_jM382 | NL0001 | 2024-10-26T12:22:17.106Z | 2024-11-01T12:27:01.917Z |
5376703 | 5376703 | 20241024040940_dG8Bx | NL0001 | 2024-10-26T12:22:10.668Z | 2024-11-01T12:27:01.746Z |
5376486 | 5376486 | 20241024035751_W5NbA | NL0001 | 2024-10-26T12:22:03.084Z | 2024-11-01T12:27:01.569Z |
5375315 | 5375315 | 20241024030608_wrjlD | NL0001 | 2024-10-26T12:21:19.960Z | 2024-11-01T12:27:00.501Z |
5375166 | 5375166 | 20241024030029_ugGKT | NL0001 | 2024-10-26T12:21:15.492Z | 2024-11-01T12:27:00.312Z |
5375026 | 5375026 | 20241024025404_Zc9PJ | NL0001 | 2024-10-26T12:21:10.228Z | 2024-11-01T12:27:00.120Z |
5374842 | 5374842 | 20241024024555_6c7bG | NL0001 | 2024-10-26T12:21:03.409Z | 2024-11-01T12:27:00.009Z |
5374521 | 5374521 | 20241024023111_wleQ7 | NL0001 | 2024-10-26T12:20:51.899Z | 2024-11-01T12:26:59.456Z |
5374023 | 5374023 | 20241024020556_HEgyK | NL0001 | 2024-10-26T12:20:34.730Z | 2024-11-01T12:26:58.626Z |
5373085 | 5373085 | 20241024012301_HqJ3z | NL0001 | 2024-10-26T12:19:56.343Z | 2024-11-01T12:26:58.126Z |
5372516 | 5372516 | 20241024005240_bAPrq | NL0001 | 2024-10-26T12:19:28.118Z | 2024-11-01T12:26:57.500Z |
5372382 | 5372382 | 20241024004620_gaTFa | NL0001 | 2024-10-26T12:19:22.998Z | 2024-11-01T12:26:57.424Z |
5372333 | 5372333 | 20241024004441_nJvu7 | NL0001 | 2024-10-26T12:19:20.891Z | 2024-11-01T12:26:57.395Z |
5372070 | 5372070 | 20241024003024_x23jr | NL0001 | 2024-10-26T12:19:05.779Z | 2024-11-01T12:26:57.082Z |
5366564 | 5366564 | 20241023024714_JzZnq | NL0001 | 2024-10-25T12:21:16.904Z | 2024-10-31T12:30:06.351Z |
5366514 | 5366514 | 20241023022731_qOERN | NL0001 | 2024-10-25T12:21:11.759Z | 2024-10-31T12:30:05.869Z |
5366216 | 5366216 | 20241024000926_D2dTl | NL0001 | 2024-10-25T12:18:19.327Z | 2024-11-01T12:26:56.797Z |
5366134 | 5366134 | 20241024000703_XNHdn | NL0001 | 2024-10-25T12:18:17.523Z | 2024-11-01T12:26:56.766Z |
5366045 | 5366045 | 20241024000220_gzqPY | NL0001 | 2024-10-25T12:18:15.024Z | 2024-11-01T12:26:56.552Z |
5365924 | 5365924 | 20241023235721_iNgAG | NL0001 | 2024-10-25T12:18:10.509Z | 2024-11-01T12:26:56.489Z |
5365872 | 5365872 | 20241023235402_vPEGq | NL0001 | 2024-10-25T12:18:09.504Z | 2024-11-01T12:26:56.460Z |
5365550 | 5365550 | 20241023233637_HZ028 | NL0001 | 2024-10-25T12:18:00.431Z | 2024-11-01T12:26:56.199Z |
5365477 | 5365477 | 20241023233351_BIixy | NL0001 | 2024-10-25T12:17:58.787Z | 2024-11-01T12:26:56.159Z |
5365371 | 5365371 | 20241023232827_pyyIV | NL0001 | 2024-10-25T12:17:56.783Z | 2024-11-01T12:26:56.068Z |
5365229 | 5365229 | 20241023232153_WQFgt | NL0001 | 2024-10-25T12:17:51.772Z | 2024-11-01T12:26:55.987Z |
5365214 | 5365214 | 20241023232122_Kc4rp | NL0001 | 2024-10-25T12:17:51.357Z | 2024-11-01T12:26:55.977Z |
5364983 | 5364983 | 20241023230854_3yhCE | NL0001 | 2024-10-25T12:17:42.745Z | 2024-11-01T12:26:55.817Z |
5364697 | 5364697 | 20241023224800_ODygi | NL0001 | 2024-10-25T12:17:30.887Z | 2024-11-01T12:26:55.581Z |
5364326 | 5364326 | 20241023222042_ovpeO | NL0001 | 2024-10-25T12:17:16.943Z | 2024-11-01T12:26:54.676Z |
5364150 | 5364150 | 20241023220955_wzM3f | NL0001 | 2024-10-25T12:17:10.644Z | 2024-11-01T12:26:54.562Z |
5364028 | 5364028 | 20241023220311_HN7KC | NL0001 | 2024-10-25T12:17:06.229Z | 2024-11-01T12:26:54.327Z |
5364001 | 5364001 | 20241023220135_Gma4M | NL0001 | 2024-10-25T12:17:05.320Z | 2024-11-01T12:26:54.292Z |
5363899 | 5363899 | 20241023215659_j7VmR | NL0001 | 2024-10-25T12:17:01.249Z | 2024-11-01T12:26:54.196Z |
5363605 | 5363605 | 20241023212643_gtIZk | NL0001 | 2024-10-25T12:16:27.575Z | 2024-11-01T12:26:53.460Z |
5362935 | 5362935 | 20241023201238_pCl3g | NL0001 | 2024-10-25T12:15:17.844Z | 2024-11-01T12:26:52.526Z |
5362394 | 5362394 | 20241023192938_x8HAQ | NL0001 | 2024-10-25T12:14:23.294Z | 2024-11-01T12:26:51.366Z |
5362382 | 5362382 | 20241023192842_KcYoI | NL0001 | 2024-10-25T12:14:22.283Z | 2024-11-01T12:26:51.358Z |
5361729 | 5361729 | 20241023183935_FMF86 | NL0001 | 2024-10-25T12:13:16.317Z | 2024-11-01T12:26:50.493Z |
5354979 | 5354979 | 20241023030158_vQqv3 | NL0001 | 2024-10-24T12:20:59.083Z | 2024-10-31T12:30:06.828Z |
5354462 | 5354462 | 20241023022703_hcsse | NL0001 | 2024-10-24T12:20:34.553Z | 2024-10-31T12:30:05.862Z |
5354431 | 5354431 | 20241023022603_kXJ1Y | NL0001 | 2024-10-24T12:20:33.594Z | 2024-10-31T12:30:05.849Z |
5354318 | 5354318 | 20241023021941_3RA2R | NL0001 | 2024-10-24T12:20:28.109Z | 2024-10-31T12:30:05.638Z |
5353059 | 5353059 | 20241023010446_vCURe | NL0001 | 2024-10-24T12:19:30.547Z | 2024-10-31T12:30:03.747Z |
5352877 | 5352877 | 20241023005402_1HrWQ | NL0001 | 2024-10-24T12:19:20.517Z | 2024-10-31T12:30:03.452Z |
5352838 | 5352838 | 20241023005305_efv9U | NL0001 | 2024-10-24T12:19:16.628Z | 2024-10-31T12:30:03.403Z |
5352291 | 5352291 | 20241023002456_2C2Fd | NL0001 | 2024-10-24T12:18:35.930Z | 2024-10-31T12:30:02.395Z |
5351869 | 5351869 | 20241022235656_5i8lK | NL0001 | 2024-10-24T12:18:06.220Z | 2024-10-31T12:30:01.138Z |
5351835 | 5351835 | 20241022235512_QXyw3 | NL0001 | 2024-10-24T12:18:03.428Z | 2024-10-31T12:30:01.002Z |
5351832 | 5351832 | 20241022235507_3znFp | NL0001 | 2024-10-24T12:18:02.921Z | 2024-10-31T12:30:00.990Z |
5351828 | 5351828 | 20241022235504_kpTvd | NL0001 | 2024-10-24T12:18:02.828Z | 2024-10-31T12:30:00.985Z |
5351449 | 5351449 | 20241022232909_2yNnm | NL0001 | 2024-10-24T12:17:32.323Z | 2024-10-31T12:30:00.370Z |
5351007 | 5351007 | 20241022224801_zquOE | NL0001 | 2024-10-24T12:17:02.428Z | 2024-10-31T12:29:59.242Z |
5349679 | 5349679 | 20241022202500_n9RF5 | NL0001 | 2024-10-24T12:14:30.165Z | 2024-10-31T12:29:56.007Z |
5348539 | 5348539 | 20241022182706_lCqkb | NL0001 | 2024-10-24T12:11:37.200Z | 2024-10-31T12:29:52.863Z |
5344749 | 5344749 | 20241022044248_gwGHF | NL0001 | 2024-10-23T12:18:49.635Z | 2024-10-30T12:26:51.613Z |
5344638 | 5344638 | 20241022043552_HYspA | NL0001 | 2024-10-23T12:18:44.591Z | 2024-10-30T12:26:51.443Z |
5344626 | 5344626 | 20241022043454_nmdqF | NL0001 | 2024-10-23T12:18:43.623Z | 2024-10-30T12:26:51.424Z |
5344466 | 5344466 | 20241022042500_3vRba | NL0001 | 2024-10-23T12:18:38.417Z | 2024-10-30T12:26:51.274Z |
5344136 | 5344136 | 20241022040743_yRPpK | NL0001 | 2024-10-23T12:18:26.146Z | 2024-10-30T12:26:50.959Z |
5343877 | 5343877 | 20241022035258_MaZDm | NL0001 | 2024-10-23T12:18:11.795Z | 2024-10-30T12:26:50.684Z |
5343665 | 5343665 | 20241022033941_I28Fv | NL0001 | 2024-10-23T12:17:59.144Z | 2024-10-30T12:26:50.391Z |
5343597 | 5343597 | 20241022033716_LeoBI | NL0001 | 2024-10-23T12:17:54.554Z | 2024-10-30T12:26:50.266Z |
5343573 | 5343573 | 20241022033545_G3Lb1 | NL0001 | 2024-10-23T12:17:51.232Z | 2024-10-30T12:26:50.221Z |
5343488 | 5343488 | 20241022033106_q8hSh | NL0001 | 2024-10-23T12:17:47.937Z | 2024-10-30T12:26:50.097Z |
5342881 | 5342881 | 20241022025146_JmMyq | NL0001 | 2024-10-23T12:17:27.689Z | 2024-10-30T12:26:49.027Z |
5342326 | 5342326 | 20241022022107_9f7oo | NL0001 | 2024-10-23T12:16:47.902Z | 2024-10-30T12:26:48.285Z |
5342205 | 5342205 | 20241022021333_IiXJi | NL0001 | 2024-10-23T12:16:40.126Z | 2024-10-30T12:26:48.140Z |
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);