participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,178 rows where station_code = "NL000D" 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 |
---|---|---|---|---|---|
5566096 | 5566096 | 20241121053200_zlA6g | NL000D | 2024-11-22T14:01:49.241Z | 2024-11-22T14:01:49.241Z |
5561684 | 5561684 | 20241119213736_31BrL | NL000D | 2024-11-21T14:13:44.245Z | 2024-11-22T14:20:42.908Z |
5489714 | 5489714 | 20241105194923_oPLB3 | NL000D | 2024-11-07T14:12:40.803Z | 2024-11-14T14:23:15.384Z |
5489321 | 5489321 | 20241105183517_8w2rS | NL000D | 2024-11-07T14:11:53.042Z | 2024-11-14T14:23:12.427Z |
5483749 | 5483749 | 20241105012644_UcjZG | NL000D | 2024-11-06T14:15:40.149Z | 2024-11-13T14:27:36.757Z |
5478640 | 5478640 | 20241104044939_PhRXu | NL000D | 2024-11-05T14:18:36.949Z | 2024-11-12T14:28:16.456Z |
5478290 | 5478290 | 20241104034813_apbtz | NL000D | 2024-11-05T14:18:09.905Z | 2024-11-12T14:28:14.859Z |
5477954 | 5477954 | 20241104030017_yPzeg | NL000D | 2024-11-05T14:17:40.151Z | 2024-11-12T14:28:13.646Z |
5477819 | 5477819 | 20241104024045_1X3Ov | NL000D | 2024-11-05T14:17:28.469Z | 2024-11-12T14:28:13.036Z |
5477571 | 5477571 | 20241104021000_gH4ou | NL000D | 2024-11-05T14:17:04.376Z | 2024-11-12T14:28:12.065Z |
5477062 | 5477062 | 20241104005557_tV3wB | NL000D | 2024-11-05T14:16:19.750Z | 2024-11-12T14:28:08.405Z |
5476835 | 5476835 | 20241104003041_XGh46 | NL000D | 2024-11-05T14:16:06.966Z | 2024-11-12T14:28:07.710Z |
5476651 | 5476651 | 20241104000250_j8Zza | NL000D | 2024-11-05T14:15:48.881Z | 2024-11-12T14:28:06.686Z |
5476457 | 5476457 | 20241103232843_55wGM | NL000D | 2024-11-05T14:15:26.068Z | 2024-11-12T14:28:06.135Z |
5476182 | 5476182 | 20241103223906_zEfE6 | NL000D | 2024-11-05T14:14:50.214Z | 2024-11-12T14:28:03.677Z |
5475626 | 5475626 | 20241103205159_C4g11 | NL000D | 2024-11-05T14:13:54.473Z | 2024-11-12T14:28:00.102Z |
5469923 | 5469923 | 20241103044702_peFxP | NL000D | 2024-11-04T14:17:20.773Z | 2024-11-11T14:23:03.024Z |
5469916 | 5469916 | 20241103044624_WqVCn | NL000D | 2024-11-04T14:17:18.952Z | 2024-11-11T14:23:03.014Z |
5469875 | 5469875 | 20241103043204_jeO19 | NL000D | 2024-11-04T14:17:12.988Z | 2024-11-11T14:23:02.592Z |
5469862 | 5469862 | 20241103043046_v42w1 | NL000D | 2024-11-04T14:17:12.521Z | 2024-11-11T14:23:02.548Z |
5469234 | 5469234 | 20241103025429_yvBRB | NL000D | 2024-11-04T14:15:59.763Z | 2024-11-11T14:22:59.354Z |
5468908 | 5468908 | 20241103020830_oW6Q3 | NL000D | 2024-11-04T14:15:12.954Z | 2024-11-11T14:22:56.915Z |
5468754 | 5468754 | 20241103014049_4eMzR | NL000D | 2024-11-04T14:15:00.864Z | 2024-11-11T14:22:55.390Z |
5468557 | 5468557 | 20241103005549_ZEhFC | NL000D | 2024-11-04T14:14:25.313Z | 2024-11-11T14:22:54.055Z |
5468269 | 5468269 | 20241103000123_pldbR | NL000D | 2024-11-04T14:13:51.792Z | 2024-11-11T14:22:52.403Z |
5468265 | 5468265 | 20241103000014_JW8y9 | NL000D | 2024-11-04T14:13:51.156Z | 2024-11-11T14:22:52.370Z |
5467707 | 5467707 | 20241102222209_nf3cM | NL000D | 2024-11-04T14:12:23.018Z | 2024-11-11T14:22:49.017Z |
5467593 | 5467593 | 20241102220220_mhNX0 | NL000D | 2024-11-04T14:12:08.672Z | 2024-11-11T14:22:47.696Z |
5467424 | 5467424 | 20241102211040_Ll5fL | NL000D | 2024-11-04T14:11:28.411Z | 2024-11-11T14:22:46.970Z |
5467140 | 5467140 | 20241102201458_WQZCA | NL000D | 2024-11-04T14:10:48.024Z | 2024-11-11T14:22:45.418Z |
5466989 | 5466989 | 20241102194132_3Kn8z | NL000D | 2024-11-04T14:10:26.210Z | 2024-11-11T14:22:44.787Z |
5422945 | 5422945 | 20241026212238_mUIjI | NL000D | 2024-10-30T12:22:04.530Z | 2024-11-04T14:28:47.799Z |
5419191 | 5419191 | 20241027231255_2MvXv | NL000D | 2024-10-30T12:17:14.211Z | 2024-11-05T14:27:12.513Z |
5418631 | 5418631 | 20241027212617_m3hmE | NL000D | 2024-10-30T12:15:54.729Z | 2024-11-05T14:27:10.846Z |
5418543 | 5418543 | 20241027210917_JmCjW | NL000D | 2024-10-30T12:15:49.166Z | 2024-11-05T14:27:10.528Z |
5418430 | 5418430 | 20241027204436_S3YOG | NL000D | 2024-10-30T12:15:40.709Z | 2024-11-05T14:27:10.011Z |
5418342 | 5418342 | 20241027202702_elq6L | NL000D | 2024-10-30T12:15:31.956Z | 2024-11-05T14:27:09.712Z |
5418253 | 5418253 | 20241027201244_IsMNZ | NL000D | 2024-10-30T12:15:13.377Z | 2024-11-05T14:27:09.494Z |
5403584 | 5403584 | 20241026221353_PdSqj | NL000D | 2024-10-29T12:09:59.804Z | 2024-11-04T14:28:49.279Z |
5403443 | 5403443 | 20241026215618_5fkYI | NL000D | 2024-10-29T12:09:30.877Z | 2024-11-04T14:28:48.871Z |
5403354 | 5403354 | 20241026214511_3nAco | NL000D | 2024-10-29T12:09:24.082Z | 2024-11-04T14:28:48.518Z |
5403256 | 5403256 | 20241026213251_gOutl | NL000D | 2024-10-29T12:09:16.392Z | 2024-11-04T14:28:48.101Z |
5402182 | 5402182 | 20241026185504_LlnrU | NL000D | 2024-10-29T12:06:35.254Z | 2024-11-04T14:28:42.786Z |
5401891 | 5401891 | 20241026180105_FerCx | NL000D | 2024-10-29T12:05:45.170Z | 2024-11-04T14:28:40.820Z |
5399578 | 5399578 | 20241026043510_4F1uJ | NL000D | 2024-10-28T12:20:02.771Z | 2024-11-03T14:27:40.001Z |
5399180 | 5399180 | 20241026035914_WVlrq | NL000D | 2024-10-28T12:19:50.734Z | 2024-11-03T14:27:39.190Z |
5398917 | 5398917 | 20241026033759_JTZzh | NL000D | 2024-10-28T12:19:40.155Z | 2024-11-03T14:27:38.600Z |
5395065 | 5395065 | 20241025220403_TEjYi | NL000D | 2024-10-28T12:15:55.042Z | 2024-11-03T14:27:23.869Z |
5394891 | 5394891 | 20241025214024_wJsr2 | NL000D | 2024-10-28T12:15:39.384Z | 2024-11-03T14:27:23.296Z |
5394814 | 5394814 | 20241025212945_S4vna | NL000D | 2024-10-28T12:15:28.606Z | 2024-11-03T14:27:22.819Z |
5393391 | 5393391 | 20241025172649_zubrn | NL000D | 2024-10-28T12:12:24.445Z | 2024-11-03T14:27:15.189Z |
5349359 | 5349359 | 20241022194734_U2f2Y | NL000D | 2024-10-24T12:13:31.762Z | 2024-10-31T12:29:55.135Z |
5349309 | 5349309 | 20241022194202_MWuAu | NL000D | 2024-10-24T12:13:26.785Z | 2024-10-31T12:29:55.031Z |
5348894 | 5348894 | 20241022190801_OYSjP | NL000D | 2024-10-24T12:12:30.555Z | 2024-10-31T12:29:53.900Z |
5348615 | 5348615 | 20241022183631_z73of | NL000D | 2024-10-24T12:11:48.881Z | 2024-10-31T12:29:53.158Z |
5348487 | 5348487 | 20241022182231_B1u27 | NL000D | 2024-10-24T12:11:30.589Z | 2024-10-31T12:29:52.804Z |
5344879 | 5344879 | 20241022045323_39oL5 | NL000D | 2024-10-23T12:18:54.907Z | 2024-10-30T12:26:51.928Z |
5344821 | 5344821 | 20241022044845_U582i | NL000D | 2024-10-23T12:18:52.197Z | 2024-10-30T12:26:51.787Z |
5321803 | 5321803 | 20241013020552_25aZD | NL000D | 2024-10-19T12:23:53.969Z | 2024-10-21T12:24:14.224Z |
5321792 | 5321792 | 20241013043958_YwWZS | NL000D | 2024-10-19T12:18:12.049Z | 2024-10-22T12:24:04.501Z |
5321754 | 5321754 | 20241016040649_fHXNZ | NL000D | 2024-10-19T12:14:46.286Z | 2024-10-24T12:28:00.066Z |
5321745 | 5321745 | 20241016034628_qRmum | NL000D | 2024-10-19T12:14:41.712Z | 2024-10-24T12:27:59.798Z |
5318125 | 5318125 | 20241016214011_m1Ej8 | NL000D | 2024-10-18T12:02:57.392Z | 2024-10-25T12:24:33.356Z |
5317484 | 5317484 | 20241014222344_E3FWY | NL000D | 2024-10-17T12:10:24.632Z | 2024-10-23T12:24:40.541Z |
5317337 | 5317337 | 20241016035809_M2S2X | NL000D | 2024-10-17T12:08:25.185Z | 2024-10-24T12:27:59.972Z |
5317325 | 5317325 | 20241016035445_L9729 | NL000D | 2024-10-17T12:08:23.052Z | 2024-10-24T12:27:59.923Z |
5312577 | 5312577 | 20241015040115_HoGcb | NL000D | 2024-10-16T12:10:49.217Z | 2024-10-23T12:24:52.051Z |
5312321 | 5312321 | 20241015031727_XSuK8 | NL000D | 2024-10-16T12:10:25.021Z | 2024-10-23T12:24:50.198Z |
5312216 | 5312216 | 20241015030149_wnnth | NL000D | 2024-10-16T12:10:12.054Z | 2024-10-23T12:24:49.517Z |
5312213 | 5312213 | 20241015030140_BQaZE | NL000D | 2024-10-16T12:10:11.550Z | 2024-10-23T12:24:49.494Z |
5312099 | 5312099 | 20241015024518_MVOPw | NL000D | 2024-10-16T12:10:00.418Z | 2024-10-23T12:24:47.708Z |
5311922 | 5311922 | 20241015021953_lDm9P | NL000D | 2024-10-16T12:09:47.412Z | 2024-10-23T12:24:46.870Z |
5311890 | 5311890 | 20241015021627_X8V8B | NL000D | 2024-10-16T12:09:45.543Z | 2024-10-23T12:24:46.206Z |
5311881 | 5311881 | 20241015021548_9TliV | NL000D | 2024-10-16T12:09:45.226Z | 2024-10-23T12:24:46.200Z |
5311826 | 5311826 | 20241015020743_PKhRc | NL000D | 2024-10-16T12:09:41.134Z | 2024-10-23T12:24:45.780Z |
5311754 | 5311754 | 20241015015458_auV2d | NL000D | 2024-10-16T12:09:34.012Z | 2024-10-23T12:24:45.496Z |
5311674 | 5311674 | 20241015013850_lOcaK | NL000D | 2024-10-16T12:09:20.561Z | 2024-10-23T12:24:44.644Z |
5311425 | 5311425 | 20241015004120_Bl6nJ | NL000D | 2024-10-16T12:08:54.005Z | 2024-10-23T12:24:43.382Z |
5311314 | 5311314 | 20241015000713_qdfWp | NL000D | 2024-10-16T12:08:47.012Z | 2024-10-23T12:24:42.860Z |
5311264 | 5311264 | 20241014235209_QMrWm | NL000D | 2024-10-16T12:08:43.297Z | 2024-10-23T12:24:42.508Z |
5311233 | 5311233 | 20241014234602_4oH1g | NL000D | 2024-10-16T12:08:40.891Z | 2024-10-23T12:24:42.350Z |
5311121 | 5311121 | 20241014231334_r4SmN | NL000D | 2024-10-16T12:08:27.432Z | 2024-10-23T12:24:41.351Z |
5311051 | 5311051 | 20241014224225_5DRQG | NL000D | 2024-10-16T12:08:12.596Z | 2024-10-23T12:24:40.858Z |
5311006 | 5311006 | 20241014222541_0071m | NL000D | 2024-10-16T12:08:07.799Z | 2024-10-23T12:24:40.568Z |
5310910 | 5310910 | 20241014213958_MWfHj | NL000D | 2024-10-16T12:08:00.232Z | 2024-10-23T12:24:39.966Z |
5310889 | 5310889 | 20241014212041_Nohzu | NL000D | 2024-10-16T12:07:57.989Z | 2024-10-23T12:24:39.584Z |
5310866 | 5310866 | 20241014210718_eDKjv | NL000D | 2024-10-16T12:07:55.537Z | 2024-10-23T12:24:39.450Z |
5310827 | 5310827 | 20241014204607_TVC3k | NL000D | 2024-10-16T12:07:52.406Z | 2024-10-23T12:24:39.104Z |
5310758 | 5310758 | 20241014201200_vTb0t | NL000D | 2024-10-16T12:07:42.265Z | 2024-10-23T12:24:37.806Z |
5310721 | 5310721 | 20241014200214_tLXuJ | NL000D | 2024-10-16T12:07:29.888Z | 2024-10-23T12:24:37.189Z |
5310565 | 5310565 | 20241014185314_5XTc7 | NL000D | 2024-10-16T12:07:15.136Z | 2024-10-23T12:24:35.615Z |
5310476 | 5310476 | 20241014181609_3Yvxo | NL000D | 2024-10-16T12:07:06.117Z | 2024-10-23T12:24:33.805Z |
5310464 | 5310464 | 20241014175718_O0YK3 | NL000D | 2024-10-16T12:07:04.917Z | 2024-10-23T12:24:33.702Z |
5303845 | 5303845 | 20241013034054_w4ZJO | NL000D | 2024-10-14T12:17:35.436Z | 2024-10-21T12:24:20.726Z |
5302902 | 5302902 | 20241013015622_iPNry | NL000D | 2024-10-14T12:16:53.960Z | 2024-10-21T12:24:13.867Z |
5294728 | 5294728 | 20241013044211_A4WDQ | NL000D | 2024-10-14T12:00:14.617Z | 2024-10-22T12:24:04.736Z |
5293657 | 5293657 | 20241012020352_2eeMb | NL000D | 2024-10-13T12:17:44.003Z | 2024-10-20T12:25:02.734Z |
5293621 | 5293621 | 20241012015913_r6tbH | NL000D | 2024-10-13T12:17:42.036Z | 2024-10-20T12:25:02.555Z |
5293116 | 5293116 | 20241012005328_k2K9Y | NL000D | 2024-10-13T12:17:04.357Z | 2024-10-20T12:24:55.691Z |
5292902 | 5292902 | 20241012003254_5UrHL | NL000D | 2024-10-13T12:16:43.100Z | 2024-10-20T12:24:53.216Z |
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);