participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,974 rows where station_code = "NL000S" 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 |
---|---|---|---|---|---|
5420955 | 5420955 | 20241028040333_oeCfu | NL000S | 2024-10-30T12:19:29.313Z | 2024-11-03T14:26:03.820Z |
5420849 | 5420849 | 20241028034526_iMiH2 | NL000S | 2024-10-30T12:19:21.928Z | 2024-11-03T14:26:03.469Z |
5420652 | 5420652 | 20241028031302_pLEFY | NL000S | 2024-10-30T12:19:08.264Z | 2024-11-03T14:26:02.779Z |
5420407 | 5420407 | 20241028023809_HDZWw | NL000S | 2024-10-30T12:18:49.703Z | 2024-11-03T14:26:01.875Z |
5419840 | 5419840 | 20241028011805_PIeHA | NL000S | 2024-10-30T12:17:57.655Z | 2024-11-03T14:26:00.186Z |
5419606 | 5419606 | 20241028002627_OVPKG | NL000S | 2024-10-30T12:17:38.321Z | 2024-11-03T14:25:59.612Z |
5419488 | 5419488 | 20241028000851_52b11 | NL000S | 2024-10-30T12:17:29.769Z | 2024-11-03T14:25:58.895Z |
5419364 | 5419364 | 20241027234228_oCLfV | NL000S | 2024-10-30T12:17:22.663Z | 2024-11-03T14:25:58.273Z |
5419324 | 5419324 | 20241027233652_0FT3O | NL000S | 2024-10-30T12:17:20.410Z | 2024-11-03T14:25:58.036Z |
5419113 | 5419113 | 20241027230434_npl2m | NL000S | 2024-10-30T12:17:10.260Z | 2024-11-03T14:25:56.662Z |
5419018 | 5419018 | 20241027224539_Yp2ge | NL000S | 2024-10-30T12:16:52.809Z | 2024-11-03T14:25:56.164Z |
5418911 | 5418911 | 20241027222258_YF3ed | NL000S | 2024-10-30T12:16:33.008Z | 2024-11-03T14:25:55.549Z |
5418549 | 5418549 | 20241027211006_KVV4G | NL000S | 2024-10-30T12:15:49.323Z | 2024-11-03T14:25:53.219Z |
5418504 | 5418504 | 20241027205823_8hJZv | NL000S | 2024-10-30T12:15:45.930Z | 2024-11-03T14:25:52.093Z |
5418500 | 5418500 | 20241027205806_oFG9a | NL000S | 2024-10-30T12:15:45.711Z | 2024-11-03T14:25:52.031Z |
5418451 | 5418451 | 20241027205011_xIQXh | NL000S | 2024-10-30T12:15:42.503Z | 2024-11-03T14:25:51.638Z |
5418395 | 5418395 | 20241027203653_dXHj1 | NL000S | 2024-10-30T12:15:38.101Z | 2024-11-03T14:25:51.319Z |
5403365 | 5403365 | 20241026214624_3apTj | NL000S | 2024-10-29T12:09:25.121Z | 2024-11-03T14:26:32.455Z |
5403260 | 5403260 | 20241026213309_46PnE | NL000S | 2024-10-29T12:09:16.838Z | 2024-11-03T14:26:31.855Z |
5403252 | 5403252 | 20241026213216_R3T6O | NL000S | 2024-10-29T12:09:15.848Z | 2024-11-03T14:26:31.779Z |
5403231 | 5403231 | 20241026213105_YYIMC | NL000S | 2024-10-29T12:09:14.523Z | 2024-11-03T14:26:31.733Z |
5403107 | 5403107 | 20241026211914_Ec14t | NL000S | 2024-10-29T12:08:57.274Z | 2024-11-03T14:26:30.866Z |
5403087 | 5403087 | 20241026211706_OKHji | NL000S | 2024-10-29T12:08:53.201Z | 2024-11-03T14:26:30.695Z |
5403081 | 5403081 | 20241026211657_ChOPf | NL000S | 2024-10-29T12:08:52.833Z | 2024-11-03T14:26:30.667Z |
5402995 | 5402995 | 20241026205946_By2h8 | NL000S | 2024-10-29T12:08:42.887Z | 2024-11-03T14:26:30.122Z |
5402777 | 5402777 | 20241026202414_ZIg9Q | NL000S | 2024-10-29T12:08:07.606Z | 2024-11-03T14:26:28.196Z |
5402292 | 5402292 | 20241026191018_SztYo | NL000S | 2024-10-29T12:06:53.997Z | 2024-11-03T14:26:24.167Z |
5402147 | 5402147 | 20241026184923_cCS9h | NL000S | 2024-10-29T12:06:30.670Z | 2024-11-03T14:26:22.143Z |
5402026 | 5402026 | 20241026182629_ppp6t | NL000S | 2024-10-29T12:06:05.830Z | 2024-11-03T14:26:20.980Z |
5402020 | 5402020 | 20241026182454_D4l3E | NL000S | 2024-10-29T12:06:04.658Z | 2024-11-03T14:26:20.919Z |
5401928 | 5401928 | 20241026180927_QPQ0j | NL000S | 2024-10-29T12:05:51.683Z | 2024-11-03T14:26:20.255Z |
5401913 | 5401913 | 20241026180535_MaiSu | NL000S | 2024-10-29T12:05:48.790Z | 2024-11-03T14:26:20.066Z |
5401868 | 5401868 | 20241026175359_2KWKB | NL000S | 2024-10-29T12:05:37.596Z | 2024-11-03T14:26:19.674Z |
5398539 | 5398539 | 20241026030554_3vn0A | NL000S | 2024-10-28T12:19:21.006Z | 2024-11-03T14:27:36.764Z |
5398270 | 5398270 | 20241026024005_SCl6r | NL000S | 2024-10-28T12:19:08.670Z | 2024-11-03T14:27:35.764Z |
5398133 | 5398133 | 20241026022912_Q3xFz | NL000S | 2024-10-28T12:19:02.039Z | 2024-11-03T14:27:35.547Z |
5398023 | 5398023 | 20241026021822_POGQr | NL000S | 2024-10-28T12:18:57.290Z | 2024-11-03T14:27:34.913Z |
5397053 | 5397053 | 20241026005911_JY7I7 | NL000S | 2024-10-28T12:18:04.419Z | 2024-11-03T14:27:31.952Z |
5396894 | 5396894 | 20241026004355_Uu2Z0 | NL000S | 2024-10-28T12:17:58.709Z | 2024-11-03T14:27:31.287Z |
5396706 | 5396706 | 20241026002532_KAF32 | NL000S | 2024-10-28T12:17:53.706Z | 2024-11-03T14:27:30.734Z |
5396701 | 5396701 | 20241026002501_9R62K | NL000S | 2024-10-28T12:17:53.586Z | 2024-11-03T14:27:30.727Z |
5396619 | 5396619 | 20241026001647_ZAZx4 | NL000S | 2024-10-28T12:17:51.285Z | 2024-11-03T14:27:30.463Z |
5396549 | 5396549 | 20241026001057_GBzQF | NL000S | 2024-10-28T12:17:49.299Z | 2024-11-03T14:27:30.184Z |
5396286 | 5396286 | 20241025235247_3WTCM | NL000S | 2024-10-28T12:17:30.293Z | 2024-11-03T14:27:29.164Z |
5396218 | 5396218 | 20241025234831_FaTLv | NL000S | 2024-10-28T12:17:27.536Z | 2024-11-03T14:27:28.915Z |
5396185 | 5396185 | 20241025234608_nd6YO | NL000S | 2024-10-28T12:17:24.596Z | 2024-11-03T14:27:28.839Z |
5396099 | 5396099 | 20241025234026_zLC0v | NL000S | 2024-10-28T12:17:18.344Z | 2024-11-03T14:27:28.522Z |
5396088 | 5396088 | 20241025233843_pIk46 | NL000S | 2024-10-28T12:17:17.960Z | 2024-11-03T14:27:28.382Z |
5395977 | 5395977 | 20241025232659_dKtar | NL000S | 2024-10-28T12:17:09.066Z | 2024-11-03T14:27:27.851Z |
5395967 | 5395967 | 20241025232647_w06uq | NL000S | 2024-10-28T12:17:08.420Z | 2024-11-03T14:27:27.831Z |
5395940 | 5395940 | 20241025232358_0j3G5 | NL000S | 2024-10-28T12:17:06.142Z | 2024-11-03T14:27:27.676Z |
5395894 | 5395894 | 20241025232001_lQ2xC | NL000S | 2024-10-28T12:17:03.912Z | 2024-11-03T14:27:27.566Z |
5395712 | 5395712 | 20241025230614_30NXO | NL000S | 2024-10-28T12:16:42.359Z | 2024-11-03T14:27:26.525Z |
5395700 | 5395700 | 20241025230510_yxaJf | NL000S | 2024-10-28T12:16:40.926Z | 2024-11-03T14:27:26.432Z |
5395625 | 5395625 | 20241025225958_0pCMZ | NL000S | 2024-10-28T12:16:34.086Z | 2024-11-03T14:27:26.260Z |
5395483 | 5395483 | 20241025224546_mX1BL | NL000S | 2024-10-28T12:16:19.499Z | 2024-11-03T14:27:25.622Z |
5395335 | 5395335 | 20241025223319_QN9kN | NL000S | 2024-10-28T12:16:09.628Z | 2024-11-03T14:27:25.125Z |
5395166 | 5395166 | 20241025221621_ezBFw | NL000S | 2024-10-28T12:15:59.666Z | 2024-11-03T14:27:24.150Z |
5395125 | 5395125 | 20241025221227_Xj4W1 | NL000S | 2024-10-28T12:15:57.936Z | 2024-11-03T14:27:24.063Z |
5395011 | 5395011 | 20241025220000_y45VI | NL000S | 2024-10-28T12:15:52.690Z | 2024-11-03T14:27:23.641Z |
5394926 | 5394926 | 20241025214556_1zqSt | NL000S | 2024-10-28T12:15:43.931Z | 2024-11-03T14:27:23.484Z |
5394721 | 5394721 | 20241025211446_SQNww | NL000S | 2024-10-28T12:15:17.690Z | 2024-11-03T14:27:22.407Z |
5394688 | 5394688 | 20241025210814_ggop4 | NL000S | 2024-10-28T12:15:13.931Z | 2024-11-03T14:27:22.274Z |
5394614 | 5394614 | 20241025205837_TN0sz | NL000S | 2024-10-28T12:15:05.193Z | 2024-11-03T14:27:21.878Z |
5393984 | 5393984 | 20241025192236_PTXNe | NL000S | 2024-10-28T12:13:56.917Z | 2024-11-03T14:27:19.433Z |
5393978 | 5393978 | 20241025192211_9yDhb | NL000S | 2024-10-28T12:13:56.765Z | 2024-11-03T14:27:19.422Z |
5393964 | 5393964 | 20241025191942_95unk | NL000S | 2024-10-28T12:13:55.836Z | 2024-11-03T14:27:19.366Z |
5393699 | 5393699 | 20241025183028_o1Ynr | NL000S | 2024-10-28T12:13:02.125Z | 2024-11-03T14:27:17.441Z |
5393690 | 5393690 | 20241025183006_ysc1o | NL000S | 2024-10-28T12:13:01.214Z | 2024-11-03T14:27:17.418Z |
5393540 | 5393540 | 20241025180555_7qwxz | NL000S | 2024-10-28T12:12:44.618Z | 2024-11-03T14:27:16.014Z |
5387809 | 5387809 | 20241025032458_Crx6p | NL000S | 2024-10-27T12:21:41.386Z | 2024-11-02T12:28:33.279Z |
5387781 | 5387781 | 20241025032117_ohOkI | NL000S | 2024-10-27T12:21:39.903Z | 2024-11-02T12:28:33.246Z |
5384361 | 5384361 | 20241024195910_uGKx7 | NL000S | 2024-10-27T12:16:58.428Z | 2024-11-02T12:28:26.996Z |
5384234 | 5384234 | 20241024194855_k0MRA | NL000S | 2024-10-27T12:16:53.541Z | 2024-11-02T12:28:26.882Z |
5384100 | 5384100 | 20241024193601_YkdUD | NL000S | 2024-10-27T12:16:47.255Z | 2024-11-02T12:28:26.756Z |
5383771 | 5383771 | 20241024185738_WUzjq | NL000S | 2024-10-27T12:16:08.505Z | 2024-11-02T12:28:26.324Z |
5362367 | 5362367 | 20241023192757_hxdul | NL000S | 2024-10-25T12:14:20.792Z | 2024-11-01T12:26:51.330Z |
5362081 | 5362081 | 20241023190559_0e36h | NL000S | 2024-10-25T12:13:49.923Z | 2024-11-01T12:26:50.968Z |
5361764 | 5361764 | 20241023184155_TYgJK | NL000S | 2024-10-25T12:13:25.377Z | 2024-11-01T12:26:50.520Z |
5361741 | 5361741 | 20241023184002_ytMmm | NL000S | 2024-10-25T12:13:21.098Z | 2024-11-01T12:26:50.505Z |
5361639 | 5361639 | 20241023183222_tis66 | NL000S | 2024-10-25T12:13:03.507Z | 2024-11-01T12:26:50.399Z |
5361152 | 5361152 | 20241023175425_ZmGDD | NL000S | 2024-10-25T12:12:24.202Z | 2024-11-01T12:26:49.372Z |
5361020 | 5361020 | 20241023174142_5ugL5 | NL000S | 2024-10-25T12:12:08.580Z | 2024-11-01T12:26:48.671Z |
5354783 | 5354783 | 20241023024515_FYoYN | NL000S | 2024-10-24T12:20:50.371Z | 2024-10-31T12:30:06.320Z |
5354750 | 5354750 | 20241023024339_wFy7o | NL000S | 2024-10-24T12:20:48.440Z | 2024-10-31T12:30:06.294Z |
5354739 | 5354739 | 20241023024317_Gh0D2 | NL000S | 2024-10-24T12:20:48.190Z | 2024-10-31T12:30:06.289Z |
5354137 | 5354137 | 20241023020655_aFOgp | NL000S | 2024-10-24T12:20:17.950Z | 2024-10-31T12:30:05.415Z |
5354018 | 5354018 | 20241023020004_oU8J0 | NL000S | 2024-10-24T12:20:09.185Z | 2024-10-31T12:30:05.270Z |
5353596 | 5353596 | 20241023013359_5MCaG | NL000S | 2024-10-24T12:19:47.512Z | 2024-10-31T12:30:04.397Z |
5353554 | 5353554 | 20241023013100_mqVGr | NL000S | 2024-10-24T12:19:46.505Z | 2024-10-31T12:30:04.361Z |
5353533 | 5353533 | 20241023012956_JhLjK | NL000S | 2024-10-24T12:19:45.611Z | 2024-10-31T12:30:04.337Z |
5353487 | 5353487 | 20241023012742_vmROl | NL000S | 2024-10-24T12:19:44.095Z | 2024-10-31T12:30:04.292Z |
5353300 | 5353300 | 20241023011911_UG0eR | NL000S | 2024-10-24T12:19:38.558Z | 2024-10-31T12:30:04.113Z |
5353241 | 5353241 | 20241023011700_Be7Ef | NL000S | 2024-10-24T12:19:36.707Z | 2024-10-31T12:30:04.048Z |
5353155 | 5353155 | 20241023011107_zwZ55 | NL000S | 2024-10-24T12:19:34.082Z | 2024-10-31T12:30:03.889Z |
5352919 | 5352919 | 20241023005630_Grk2x | NL000S | 2024-10-24T12:19:25.774Z | 2024-10-31T12:30:03.538Z |
5352671 | 5352671 | 20241023004301_CEC9v | NL000S | 2024-10-24T12:19:04.493Z | 2024-10-31T12:30:03.133Z |
5352627 | 5352627 | 20241023004158_pKbUM | NL000S | 2024-10-24T12:19:01.202Z | 2024-10-31T12:30:03.002Z |
5352591 | 5352591 | 20241023004120_ICabo | NL000S | 2024-10-24T12:18:59.306Z | 2024-10-31T12:30:02.926Z |
5351987 | 5351987 | 20241023000349_Em4d7 | NL000S | 2024-10-24T12:18:12.522Z | 2024-10-31T12:30:01.470Z |
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);