participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,797 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 |
---|---|---|---|---|---|
5485401 | 5485401 | 20241105052102_BrLSz | NL000N | 2024-11-06T14:18:12.283Z | 2024-11-09T14:21:21.367Z |
5485372 | 5485372 | 20241105050906_c2ANS | NL000N | 2024-11-06T14:18:10.522Z | 2024-11-09T14:21:21.136Z |
5485301 | 5485301 | 20241105044347_invhs | NL000N | 2024-11-06T14:18:04.448Z | 2024-11-09T14:21:20.691Z |
5484992 | 5484992 | 20241105035148_3IKnX | NL000N | 2024-11-06T14:17:36.972Z | 2024-11-09T14:21:18.563Z |
5484779 | 5484779 | 20241105032906_AEgO9 | NL000N | 2024-11-06T14:17:16.163Z | 2024-11-09T14:21:16.494Z |
5484532 | 5484532 | 20241105030229_ngi8s | NL000N | 2024-11-06T14:16:59.868Z | 2024-11-09T14:21:14.909Z |
5484527 | 5484527 | 20241105030210_1ep73 | NL000N | 2024-11-06T14:16:59.768Z | 2024-11-09T14:21:14.869Z |
5484450 | 5484450 | 20241105025213_GjyE1 | NL000N | 2024-11-06T14:16:55.617Z | 2024-11-09T14:21:14.195Z |
5483859 | 5483859 | 20241105013859_thk6H | NL000N | 2024-11-06T14:15:47.014Z | 2024-11-09T14:21:08.800Z |
5483767 | 5483767 | 20241105012857_B8EKS | NL000N | 2024-11-06T14:15:41.580Z | 2024-11-09T14:21:07.507Z |
5483764 | 5483764 | 20241105012821_Aw3w3 | NL000N | 2024-11-06T14:15:41.459Z | 2024-11-09T14:21:07.505Z |
5483498 | 5483498 | 20241105004521_9aZVy | NL000N | 2024-11-06T14:15:25.457Z | 2024-11-09T14:21:05.660Z |
5483346 | 5483346 | 20241105002812_UP12B | NL000N | 2024-11-06T14:15:01.196Z | 2024-11-09T14:21:04.930Z |
5483215 | 5483215 | 20241105001434_UJoaw | NL000N | 2024-11-06T14:14:47.950Z | 2024-11-09T14:21:04.114Z |
5482802 | 5482802 | 20241104231551_6mG97 | NL000N | 2024-11-06T14:14:02.783Z | 2024-11-09T14:21:01.653Z |
5482790 | 5482790 | 20241104231459_VlPW0 | NL000N | 2024-11-06T14:14:00.391Z | 2024-11-09T14:21:01.545Z |
5482639 | 5482639 | 20241104225248_2ezr9 | NL000N | 2024-11-06T14:13:29.151Z | 2024-11-09T14:21:00.714Z |
5482399 | 5482399 | 20241104220659_CvDq7 | NL000N | 2024-11-06T14:13:07.672Z | 2024-11-09T14:20:58.888Z |
5482271 | 5482271 | 20241104214124_J393V | NL000N | 2024-11-06T14:12:45.674Z | 2024-11-09T14:20:57.546Z |
5482162 | 5482162 | 20241104211910_2YxGv | NL000N | 2024-11-06T14:12:29.854Z | 2024-11-09T14:20:55.927Z |
5481782 | 5481782 | 20241104193945_yj9n9 | NL000N | 2024-11-06T14:11:34.211Z | 2024-11-09T14:20:50.750Z |
5481740 | 5481740 | 20241104192622_Lt6Ds | NL000N | 2024-11-06T14:11:29.367Z | 2024-11-09T14:20:50.200Z |
5478609 | 5478609 | 20241104044307_2KOYd | NL000N | 2024-11-05T14:18:33.994Z | 2024-11-09T14:22:30.228Z |
5478590 | 5478590 | 20241104043626_q3C2o | NL000N | 2024-11-05T14:18:32.928Z | 2024-11-09T14:22:30.012Z |
5478238 | 5478238 | 20241104034005_G6DSq | NL000N | 2024-11-05T14:18:05.740Z | 2024-11-09T14:22:26.264Z |
5477995 | 5477995 | 20241104030544_rTG11 | NL000N | 2024-11-05T14:17:43.384Z | 2024-11-09T14:22:23.368Z |
5477904 | 5477904 | 20241104025220_Y5Nnr | NL000N | 2024-11-05T14:17:35.668Z | 2024-11-09T14:22:22.815Z |
5477772 | 5477772 | 20241104023325_7H8Nz | NL000N | 2024-11-05T14:17:23.854Z | 2024-11-09T14:22:21.756Z |
5477702 | 5477702 | 20241104022241_q4Jl5 | NL000N | 2024-11-05T14:17:16.244Z | 2024-11-09T14:22:21.044Z |
5477676 | 5477676 | 20241104021939_yRenh | NL000N | 2024-11-05T14:17:14.221Z | 2024-11-09T14:22:20.685Z |
5477430 | 5477430 | 20241104015058_4AqMg | NL000N | 2024-11-05T14:16:52.827Z | 2024-11-09T14:22:17.614Z |
5476742 | 5476742 | 20241104001605_vNn3P | NL000N | 2024-11-05T14:16:02.334Z | 2024-11-09T14:22:12.081Z |
5476129 | 5476129 | 20241103223111_Aae9a | NL000N | 2024-11-05T14:14:47.038Z | 2024-11-09T14:22:06.029Z |
5475968 | 5475968 | 20241103220210_vEBVn | NL000N | 2024-11-05T14:14:36.284Z | 2024-11-09T14:22:04.323Z |
5475497 | 5475497 | 20241103201806_repYB | NL000N | 2024-11-05T14:13:44.118Z | 2024-11-09T14:21:59.305Z |
5475235 | 5475235 | 20241103193348_RZPf8 | NL000N | 2024-11-05T14:12:49.870Z | 2024-11-09T14:21:56.710Z |
5469782 | 5469782 | 20241103041815_4PPQw | NL000N | 2024-11-04T14:17:02.822Z | 2024-11-09T14:23:03.796Z |
5469673 | 5469673 | 20241103035959_vVSL6 | NL000N | 2024-11-04T14:16:46.862Z | 2024-11-09T14:23:03.494Z |
5469662 | 5469662 | 20241103035705_Uw2z0 | NL000N | 2024-11-04T14:16:44.362Z | 2024-11-09T14:23:03.412Z |
5469592 | 5469592 | 20241103035023_1BMTM | NL000N | 2024-11-04T14:16:39.317Z | 2024-11-09T14:23:03.164Z |
5469578 | 5469578 | 20241103034713_VzNWL | NL000N | 2024-11-04T14:16:37.345Z | 2024-11-09T14:23:03.120Z |
5469402 | 5469402 | 20241103032155_i4rTo | NL000N | 2024-11-04T14:16:24.915Z | 2024-11-09T14:23:02.452Z |
5468842 | 5468842 | 20241103015745_iOpoS | NL000N | 2024-11-04T14:15:07.769Z | 2024-11-09T14:22:59.964Z |
5468395 | 5468395 | 20241103002715_DB3Jd | NL000N | 2024-11-04T14:14:03.137Z | 2024-11-09T14:22:58.174Z |
5468150 | 5468150 | 20241102234205_hcbC3 | NL000N | 2024-11-04T14:13:25.778Z | 2024-11-09T14:22:57.307Z |
5468032 | 5468032 | 20241102231810_1AIOZ | NL000N | 2024-11-04T14:13:08.915Z | 2024-11-09T14:22:56.544Z |
5467998 | 5467998 | 20241102231234_Fm36v | NL000N | 2024-11-04T14:13:05.903Z | 2024-11-09T14:22:56.313Z |
5467749 | 5467749 | 20241102223034_rTbAJ | NL000N | 2024-11-04T14:12:27.325Z | 2024-11-09T14:22:55.554Z |
5467657 | 5467657 | 20241102221032_9tufv | NL000N | 2024-11-04T14:12:18.135Z | 2024-11-09T14:22:55.325Z |
5467642 | 5467642 | 20241102220936_nwL35 | NL000N | 2024-11-04T14:12:16.792Z | 2024-11-09T14:22:55.225Z |
5467638 | 5467638 | 20241102220853_rQsAI | NL000N | 2024-11-04T14:12:16.422Z | 2024-11-09T14:22:55.216Z |
5467596 | 5467596 | 20241102220223_PzZy1 | NL000N | 2024-11-04T14:12:10.822Z | 2024-11-09T14:22:55.131Z |
5467462 | 5467462 | 20241102212357_m52QM | NL000N | 2024-11-04T14:11:35.183Z | 2024-11-09T14:22:54.680Z |
5467217 | 5467217 | 20241102202448_munRR | NL000N | 2024-11-04T14:11:06.771Z | 2024-11-09T14:22:53.664Z |
5466840 | 5466840 | 20241102190901_RFwlU | NL000N | 2024-11-04T14:09:58.759Z | 2024-11-09T14:22:52.515Z |
5466627 | 5466627 | 20241102182052_pWK0M | NL000N | 2024-11-04T14:09:26.913Z | 2024-11-09T14:22:51.673Z |
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 |
5393689 | 5393689 | 20241025183006_ysc1o | NL000N | 2024-10-28T12:13:01.214Z | 2024-11-03T14:27:17.418Z |
5393508 | 5393508 | 20241025175624_zToVB | NL000N | 2024-10-28T12:12:41.881Z | 2024-11-03T14:27:15.821Z |
5385548 | 5385548 | 20241024225958_GpCYp | NL000N | 2024-10-27T12:19:05.356Z | 2024-11-02T12:28:29.916Z |
5384974 | 5384974 | 20241024212701_JbzxD | NL000N | 2024-10-27T12:18:05.937Z | 2024-11-02T12:28:28.822Z |
5384360 | 5384360 | 20241024195910_uGKx7 | NL000N | 2024-10-27T12:16:58.428Z | 2024-11-02T12:28:26.996Z |
5383770 | 5383770 | 20241024185738_WUzjq | NL000N | 2024-10-27T12:16:08.505Z | 2024-11-02T12:28:26.324Z |
5383253 | 5383253 | 20241024180155_o7UZb | NL000N | 2024-10-27T12:15:02.311Z | 2024-11-02T12:28:24.851Z |
5366518 | 5366518 | 20241023022913_lpD3B | NL000N | 2024-10-25T12:21:12.827Z | 2024-10-31T12:30:05.882Z |
5365558 | 5365558 | 20241023233730_dyH4Z | NL000N | 2024-10-25T12:18:00.643Z | 2024-11-01T12:26:56.204Z |
5363614 | 5363614 | 20241023212807_AVv7A | NL000N | 2024-10-25T12:16:28.108Z | 2024-11-01T12:26:53.468Z |
5362463 | 5362463 | 20241023193456_CULkv | NL000N | 2024-10-25T12:14:31.341Z | 2024-11-01T12:26:51.742Z |
5362417 | 5362417 | 20241023193259_bBE70 | NL000N | 2024-10-25T12:14:26.007Z | 2024-11-01T12:26:51.488Z |
5361576 | 5361576 | 20241023182717_bdDxu | NL000N | 2024-10-25T12:12:57.668Z | 2024-11-01T12:26:50.357Z |
5355642 | 5355642 | 20241023035753_DScQA | NL000N | 2024-10-24T12:21:29.450Z | 2024-10-31T12:30:08.259Z |
5354136 | 5354136 | 20241023020655_aFOgp | NL000N | 2024-10-24T12:20:17.950Z | 2024-10-31T12:30:05.415Z |
5353240 | 5353240 | 20241023011700_Be7Ef | NL000N | 2024-10-24T12:19:36.707Z | 2024-10-31T12:30:04.048Z |
5351567 | 5351567 | 20241022233842_1BMiZ | NL000N | 2024-10-24T12:17:39.991Z | 2024-10-31T12:30:00.550Z |
5351218 | 5351218 | 20241022230824_YSeEG | NL000N | 2024-10-24T12:17:20.846Z | 2024-10-31T12:29:59.618Z |
5351063 | 5351063 | 20241022225204_VhLx5 | NL000N | 2024-10-24T12:17:07.534Z | 2024-10-31T12:29:59.320Z |
5350478 | 5350478 | 20241022215457_5WQze | NL000N | 2024-10-24T12:15:48.253Z | 2024-10-31T12:29:58.254Z |
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);