participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,817 rows where station_code = "NL000N" 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 |
---|---|---|---|---|---|
5604039 | 5604039 | 20241124200350_g0Rud | NL000N | 2024-11-26T14:16:16.017Z | 2024-11-26T14:18:44.847Z |
5592601 | 5592601 | 20241121215357_Y18jH | NL000N | 2024-11-24T14:22:23.749Z | 2024-11-26T14:24:55.319Z |
5591533 | 5591533 | 20241122234306_T12M5 | NL000N | 2024-11-24T14:19:58.994Z | 2024-11-26T14:23:25.005Z |
5591453 | 5591453 | 20241122231449_riWXK | NL000N | 2024-11-24T14:19:53.647Z | 2024-11-26T14:23:23.037Z |
5591322 | 5591322 | 20241122223239_F7OG0 | NL000N | 2024-11-24T14:19:44.408Z | 2024-11-26T14:23:20.569Z |
5590952 | 5590952 | 20241122204725_bnmtU | NL000N | 2024-11-24T14:19:12.906Z | 2024-11-26T14:23:14.643Z |
5590677 | 5590677 | 20241122194939_pywBg | NL000N | 2024-11-24T14:18:50.917Z | 2024-11-26T14:23:11.327Z |
5590668 | 5590668 | 20241122194844_sUWZH | NL000N | 2024-11-24T14:18:49.602Z | 2024-11-26T14:23:11.191Z |
5590657 | 5590657 | 20241122194656_a3X3E | NL000N | 2024-11-24T14:18:48.978Z | 2024-11-26T14:23:11.108Z |
5590435 | 5590435 | 20241122191918_KnflI | NL000N | 2024-11-24T14:18:31.788Z | 2024-11-26T14:23:06.641Z |
5590362 | 5590362 | 20241122191106_VXGA0 | NL000N | 2024-11-24T14:18:24.300Z | 2024-11-26T14:23:04.915Z |
5582187 | 5582187 | 20241122031053_W5cp8 | NL000N | 2024-11-23T14:20:58.959Z | 2024-11-26T14:25:24.889Z |
5579181 | 5579181 | 20241121215816_i2p7g | NL000N | 2024-11-23T14:17:57.078Z | 2024-11-26T14:24:55.524Z |
5579153 | 5579153 | 20241121215357_8jzqw | NL000N | 2024-11-23T14:17:55.647Z | 2024-11-26T14:24:55.315Z |
5579053 | 5579053 | 20241121214152_DEoqW | NL000N | 2024-11-23T14:17:47.184Z | 2024-11-26T14:24:54.630Z |
5573651 | 5573651 | 20241122043231_z19fd | NL000N | 2024-11-23T14:01:11.824Z | 2024-11-26T14:22:07.676Z |
5573339 | 5573339 | 20241122041016_lrGbY | NL000N | 2024-11-23T14:00:19.558Z | 2024-11-26T14:22:01.264Z |
5561792 | 5561792 | 20241119221002_rO2OV | NL000N | 2024-11-21T14:14:06.644Z | 2024-11-26T14:27:33.003Z |
5530967 | 5530967 | 20241112030306_98lLw | NL000N | 2024-11-13T14:14:56.294Z | 2024-11-20T14:26:05.721Z |
5529679 | 5529679 | 20241112005403_UskQ3 | NL000N | 2024-11-13T14:13:05.843Z | 2024-11-20T14:25:47.359Z |
5485401 | 5485401 | 20241105052102_BrLSz | NL000N | 2024-11-06T14:18:12.283Z | 2024-11-13T14:27:42.112Z |
5485372 | 5485372 | 20241105050906_c2ANS | NL000N | 2024-11-06T14:18:10.522Z | 2024-11-13T14:27:42.073Z |
5485301 | 5485301 | 20241105044347_invhs | NL000N | 2024-11-06T14:18:04.448Z | 2024-11-13T14:27:41.580Z |
5484992 | 5484992 | 20241105035148_3IKnX | NL000N | 2024-11-06T14:17:36.972Z | 2024-11-13T14:27:40.437Z |
5484779 | 5484779 | 20241105032906_AEgO9 | NL000N | 2024-11-06T14:17:16.163Z | 2024-11-13T14:27:39.842Z |
5484532 | 5484532 | 20241105030229_ngi8s | NL000N | 2024-11-06T14:16:59.868Z | 2024-11-13T14:27:38.570Z |
5484527 | 5484527 | 20241105030210_1ep73 | NL000N | 2024-11-06T14:16:59.768Z | 2024-11-13T14:27:38.553Z |
5484450 | 5484450 | 20241105025213_GjyE1 | NL000N | 2024-11-06T14:16:55.617Z | 2024-11-13T14:27:38.094Z |
5483859 | 5483859 | 20241105013859_thk6H | NL000N | 2024-11-06T14:15:47.014Z | 2024-11-13T14:27:36.918Z |
5483767 | 5483767 | 20241105012857_B8EKS | NL000N | 2024-11-06T14:15:41.580Z | 2024-11-13T14:27:36.782Z |
5483764 | 5483764 | 20241105012821_Aw3w3 | NL000N | 2024-11-06T14:15:41.459Z | 2024-11-13T14:27:36.781Z |
5483498 | 5483498 | 20241105004521_9aZVy | NL000N | 2024-11-06T14:15:25.457Z | 2024-11-13T14:27:36.336Z |
5483346 | 5483346 | 20241105002812_UP12B | NL000N | 2024-11-06T14:15:01.196Z | 2024-11-13T14:27:36.055Z |
5483215 | 5483215 | 20241105001434_UJoaw | NL000N | 2024-11-06T14:14:47.950Z | 2024-11-13T14:27:35.859Z |
5482802 | 5482802 | 20241104231551_6mG97 | NL000N | 2024-11-06T14:14:02.783Z | 2024-11-13T14:27:35.165Z |
5482790 | 5482790 | 20241104231459_VlPW0 | NL000N | 2024-11-06T14:14:00.391Z | 2024-11-13T14:27:35.140Z |
5482639 | 5482639 | 20241104225248_2ezr9 | NL000N | 2024-11-06T14:13:29.151Z | 2024-11-13T14:27:34.948Z |
5482399 | 5482399 | 20241104220659_CvDq7 | NL000N | 2024-11-06T14:13:07.672Z | 2024-11-13T14:27:34.474Z |
5482271 | 5482271 | 20241104214124_J393V | NL000N | 2024-11-06T14:12:45.674Z | 2024-11-13T14:27:34.245Z |
5482162 | 5482162 | 20241104211910_2YxGv | NL000N | 2024-11-06T14:12:29.854Z | 2024-11-13T14:27:34.057Z |
5481782 | 5481782 | 20241104193945_yj9n9 | NL000N | 2024-11-06T14:11:34.211Z | 2024-11-13T14:27:32.688Z |
5481740 | 5481740 | 20241104192622_Lt6Ds | NL000N | 2024-11-06T14:11:29.367Z | 2024-11-13T14:27:32.561Z |
5478609 | 5478609 | 20241104044307_2KOYd | NL000N | 2024-11-05T14:18:33.994Z | 2024-11-12T14:28:16.390Z |
5478590 | 5478590 | 20241104043626_q3C2o | NL000N | 2024-11-05T14:18:32.928Z | 2024-11-12T14:28:16.289Z |
5478238 | 5478238 | 20241104034005_G6DSq | NL000N | 2024-11-05T14:18:05.740Z | 2024-11-12T14:28:14.638Z |
5477995 | 5477995 | 20241104030544_rTG11 | NL000N | 2024-11-05T14:17:43.384Z | 2024-11-12T14:28:13.745Z |
5477904 | 5477904 | 20241104025220_Y5Nnr | NL000N | 2024-11-05T14:17:35.668Z | 2024-11-12T14:28:13.205Z |
5477772 | 5477772 | 20241104023325_7H8Nz | NL000N | 2024-11-05T14:17:23.854Z | 2024-11-12T14:28:12.870Z |
5477702 | 5477702 | 20241104022241_q4Jl5 | NL000N | 2024-11-05T14:17:16.244Z | 2024-11-12T14:28:12.469Z |
5477676 | 5477676 | 20241104021939_yRenh | NL000N | 2024-11-05T14:17:14.221Z | 2024-11-12T14:28:12.395Z |
5477430 | 5477430 | 20241104015058_4AqMg | NL000N | 2024-11-05T14:16:52.827Z | 2024-11-12T14:28:11.564Z |
5476742 | 5476742 | 20241104001605_vNn3P | NL000N | 2024-11-05T14:16:02.334Z | 2024-11-12T14:28:07.115Z |
5476129 | 5476129 | 20241103223111_Aae9a | NL000N | 2024-11-05T14:14:47.038Z | 2024-11-12T14:28:03.109Z |
5475968 | 5475968 | 20241103220210_vEBVn | NL000N | 2024-11-05T14:14:36.284Z | 2024-11-12T14:28:01.927Z |
5475497 | 5475497 | 20241103201806_repYB | NL000N | 2024-11-05T14:13:44.118Z | 2024-11-12T14:27:58.871Z |
5475235 | 5475235 | 20241103193348_RZPf8 | NL000N | 2024-11-05T14:12:49.870Z | 2024-11-12T14:27:57.663Z |
5469782 | 5469782 | 20241103041815_4PPQw | NL000N | 2024-11-04T14:17:02.822Z | 2024-11-11T14:23:02.240Z |
5469673 | 5469673 | 20241103035959_vVSL6 | NL000N | 2024-11-04T14:16:46.862Z | 2024-11-11T14:23:01.929Z |
5469662 | 5469662 | 20241103035705_Uw2z0 | NL000N | 2024-11-04T14:16:44.362Z | 2024-11-11T14:23:01.869Z |
5469592 | 5469592 | 20241103035023_1BMTM | NL000N | 2024-11-04T14:16:39.317Z | 2024-11-11T14:23:01.293Z |
5469578 | 5469578 | 20241103034713_VzNWL | NL000N | 2024-11-04T14:16:37.345Z | 2024-11-11T14:23:01.205Z |
5469402 | 5469402 | 20241103032155_i4rTo | NL000N | 2024-11-04T14:16:24.915Z | 2024-11-11T14:23:00.109Z |
5468842 | 5468842 | 20241103015745_iOpoS | NL000N | 2024-11-04T14:15:07.769Z | 2024-11-11T14:22:56.442Z |
5468395 | 5468395 | 20241103002715_DB3Jd | NL000N | 2024-11-04T14:14:03.137Z | 2024-11-11T14:22:53.100Z |
5468150 | 5468150 | 20241102234205_hcbC3 | NL000N | 2024-11-04T14:13:25.778Z | 2024-11-11T14:22:51.668Z |
5468032 | 5468032 | 20241102231810_1AIOZ | NL000N | 2024-11-04T14:13:08.915Z | 2024-11-11T14:22:50.990Z |
5467998 | 5467998 | 20241102231234_Fm36v | NL000N | 2024-11-04T14:13:05.903Z | 2024-11-11T14:22:50.760Z |
5467749 | 5467749 | 20241102223034_rTbAJ | NL000N | 2024-11-04T14:12:27.325Z | 2024-11-11T14:22:49.271Z |
5467657 | 5467657 | 20241102221032_9tufv | NL000N | 2024-11-04T14:12:18.135Z | 2024-11-11T14:22:48.787Z |
5467642 | 5467642 | 20241102220936_nwL35 | NL000N | 2024-11-04T14:12:16.792Z | 2024-11-11T14:22:48.674Z |
5467638 | 5467638 | 20241102220853_rQsAI | NL000N | 2024-11-04T14:12:16.422Z | 2024-11-11T14:22:48.628Z |
5467596 | 5467596 | 20241102220223_PzZy1 | NL000N | 2024-11-04T14:12:10.822Z | 2024-11-11T14:22:47.726Z |
5467462 | 5467462 | 20241102212357_m52QM | NL000N | 2024-11-04T14:11:35.183Z | 2024-11-11T14:22:47.237Z |
5467217 | 5467217 | 20241102202448_munRR | NL000N | 2024-11-04T14:11:06.771Z | 2024-11-11T14:22:45.673Z |
5466840 | 5466840 | 20241102190901_RFwlU | NL000N | 2024-11-04T14:09:58.759Z | 2024-11-11T14:22:43.799Z |
5466627 | 5466627 | 20241102182052_pWK0M | NL000N | 2024-11-04T14:09:26.913Z | 2024-11-11T14:22:42.067Z |
5451378 | 5451378 | 20241031234721_bC3gr | NL000N | 2024-11-02T12:17:00.039Z | 2024-11-09T14:24:23.301Z |
5451374 | 5451374 | 20241031234649_HaR1r | NL000N | 2024-11-02T12:16:59.562Z | 2024-11-09T14:24:23.285Z |
5451208 | 5451208 | 20241031230458_h6wWp | NL000N | 2024-11-02T12:16:42.961Z | 2024-11-09T14:24:22.193Z |
5451115 | 5451115 | 20241031223949_zrngT | NL000N | 2024-11-02T12:16:37.058Z | 2024-11-09T14:24:21.610Z |
5450900 | 5450900 | 20241031213609_PT6Z7 | NL000N | 2024-11-02T12:16:13.796Z | 2024-11-09T14:24:19.811Z |
5450614 | 5450614 | 20241031200255_RHPBQ | NL000N | 2024-11-02T12:15:39.609Z | 2024-11-09T14:24:17.134Z |
5420954 | 5420954 | 20241028040333_oeCfu | NL000N | 2024-10-30T12:19:29.313Z | 2024-11-05T14:27:16.770Z |
5420744 | 5420744 | 20241028032947_ELplP | NL000N | 2024-10-30T12:19:14.597Z | 2024-11-05T14:27:16.231Z |
5420406 | 5420406 | 20241028023809_HDZWw | NL000N | 2024-10-30T12:18:49.703Z | 2024-11-05T14:27:15.343Z |
5419491 | 5419491 | 20241028000941_6mv30 | NL000N | 2024-10-30T12:17:29.917Z | 2024-11-05T14:27:13.243Z |
5418634 | 5418634 | 20241027212621_t6n1C | NL000N | 2024-10-30T12:15:54.937Z | 2024-11-05T14:27:10.868Z |
5417671 | 5417671 | 20241027185937_5euCc | NL000N | 2024-10-30T12:14:09.444Z | 2024-11-05T14:27:08.066Z |
5417654 | 5417654 | 20241027185814_FIHRZ | NL000N | 2024-10-30T12:14:07.216Z | 2024-11-05T14:27:08.034Z |
5402291 | 5402291 | 20241026191018_SztYo | NL000N | 2024-10-29T12:06:53.997Z | 2024-11-04T14:28:43.607Z |
5402146 | 5402146 | 20241026184923_cCS9h | NL000N | 2024-10-29T12:06:30.670Z | 2024-11-04T14:28:42.482Z |
5402131 | 5402131 | 20241026184721_8Coz0 | NL000N | 2024-10-29T12:06:29.579Z | 2024-11-04T14:28:42.440Z |
5402019 | 5402019 | 20241026182454_D4l3E | NL000N | 2024-10-29T12:06:04.658Z | 2024-11-04T14:28:41.580Z |
5401831 | 5401831 | 20241026174054_fKisP | NL000N | 2024-10-29T12:05:26.849Z | 2024-11-04T14:28:39.720Z |
5396893 | 5396893 | 20241026004355_Uu2Z0 | NL000N | 2024-10-28T12:17:58.709Z | 2024-11-03T14:27:31.287Z |
5396744 | 5396744 | 20241026002859_YwGRj | NL000N | 2024-10-28T12:17:54.742Z | 2024-11-03T14:27:30.838Z |
5396726 | 5396726 | 20241026002636_UdK8H | NL000N | 2024-10-28T12:17:54.260Z | 2024-11-03T14:27:30.815Z |
5396705 | 5396705 | 20241026002532_KAF32 | NL000N | 2024-10-28T12:17:53.706Z | 2024-11-03T14:27:30.734Z |
5396424 | 5396424 | 20241026000314_GqOjp | NL000N | 2024-10-28T12:17:40.420Z | 2024-11-03T14:27:29.790Z |
5394344 | 5394344 | 20241025201708_1yuz5 | NL000N | 2024-10-28T12:14:25.635Z | 2024-11-03T14:27:20.969Z |
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);