participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0008" 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 |
---|---|---|---|---|---|
5505578 | 5505578 | 20241108061421_09b5j | US0008 | 2024-11-09T14:16:23.880Z | 2024-11-09T14:16:28.819Z |
5505463 | 5505463 | 20241108052655_XJ54m | US0008 | 2024-11-09T14:16:19.245Z | 2024-11-09T14:16:28.791Z |
5505434 | 5505434 | 20241108051649_D38zR | US0008 | 2024-11-09T14:16:17.324Z | 2024-11-09T14:16:28.783Z |
5505427 | 5505427 | 20241108051545_GlHvV | US0008 | 2024-11-09T14:16:16.988Z | 2024-11-09T14:16:28.781Z |
5505371 | 5505371 | 20241108045443_ihmzu | US0008 | 2024-11-09T14:16:14.077Z | 2024-11-09T14:16:28.767Z |
5505317 | 5505317 | 20241108043457_TfRrb | US0008 | 2024-11-09T14:16:08.859Z | 2024-11-09T14:16:28.753Z |
5499590 | 5499590 | 20241108124028_BSBSq | US0008 | 2024-11-09T14:04:24.514Z | 2024-11-09T14:04:24.514Z |
5499392 | 5499392 | 20241108121042_4MjCv | US0008 | 2024-11-09T14:03:59.171Z | 2024-11-09T14:03:59.171Z |
5499310 | 5499310 | 20241108115413_3SVqd | US0008 | 2024-11-09T14:03:43.921Z | 2024-11-09T14:03:43.921Z |
5498343 | 5498343 | 20241108081256_gQAZh | US0008 | 2024-11-09T14:01:11.481Z | 2024-11-09T14:01:11.481Z |
5498273 | 5498273 | 20241108074753_MGRwR | US0008 | 2024-11-09T14:01:00.812Z | 2024-11-09T14:01:00.812Z |
5498271 | 5498271 | 20241108074732_ET2wR | US0008 | 2024-11-09T14:01:00.480Z | 2024-11-09T14:01:00.480Z |
5498252 | 5498252 | 20241108074311_bU3j1 | US0008 | 2024-11-09T14:00:57.625Z | 2024-11-09T14:00:57.625Z |
5498177 | 5498177 | 20241108072224_NP6Dq | US0008 | 2024-11-09T14:00:43.462Z | 2024-11-09T14:00:43.462Z |
5498135 | 5498135 | 20241108071027_nfW4Z | US0008 | 2024-11-09T14:00:36.784Z | 2024-11-09T14:00:36.784Z |
5498063 | 5498063 | 20241108063830_cPelm | US0008 | 2024-11-09T14:00:22.021Z | 2024-11-09T14:00:22.021Z |
5498041 | 5498041 | 20241108063152_DkKyL | US0008 | 2024-11-09T14:00:17.766Z | 2024-11-09T14:00:17.766Z |
5491225 | 5491225 | 20241106023007_I26L4 | US0008 | 2024-11-07T14:15:34.475Z | 2024-11-09T14:20:05.743Z |
5485519 | 5485519 | 20241105061551_4b5l4 | US0008 | 2024-11-06T14:18:24.224Z | 2024-11-09T14:21:22.518Z |
5485450 | 5485450 | 20241105054439_YuzMR | US0008 | 2024-11-06T14:18:18.804Z | 2024-11-09T14:21:21.679Z |
5479320 | 5479320 | 20241105090505_PGWvm | US0008 | 2024-11-06T14:01:59.794Z | 2024-11-09T14:19:04.189Z |
5479308 | 5479308 | 20241105090411_NBVWz | US0008 | 2024-11-06T14:01:56.227Z | 2024-11-09T14:19:03.977Z |
5479293 | 5479293 | 20241105090059_H2xUB | US0008 | 2024-11-06T14:01:47.371Z | 2024-11-09T14:19:03.569Z |
5479212 | 5479212 | 20241105083219_ivrIh | US0008 | 2024-11-06T14:01:30.720Z | 2024-11-09T14:19:01.687Z |
5479196 | 5479196 | 20241105082828_3mFCU | US0008 | 2024-11-06T14:01:27.109Z | 2024-11-09T14:19:01.257Z |
5479149 | 5479149 | 20241105081726_O2VKM | US0008 | 2024-11-06T14:01:14.746Z | 2024-11-09T14:19:00.281Z |
5479144 | 5479144 | 20241105081635_z3jTq | US0008 | 2024-11-06T14:01:13.776Z | 2024-11-09T14:19:00.147Z |
5479126 | 5479126 | 20241105081234_fenIM | US0008 | 2024-11-06T14:01:07.515Z | 2024-11-09T14:18:59.877Z |
5479095 | 5479095 | 20241105080423_vg5uB | US0008 | 2024-11-06T14:00:59.474Z | 2024-11-09T14:18:59.453Z |
5479063 | 5479063 | 20241105074626_QK2js | US0008 | 2024-11-06T14:00:52.673Z | 2024-11-09T14:18:59.145Z |
5478917 | 5478917 | 20241105065423_2rEfW | US0008 | 2024-11-06T14:00:21.046Z | 2024-11-09T14:18:56.831Z |
5478889 | 5478889 | 20241105064631_0HgbS | US0008 | 2024-11-06T14:00:14.865Z | 2024-11-09T14:18:56.396Z |
5464030 | 5464030 | 20241102063831_47KIo | US0008 | 2024-11-03T14:19:30.243Z | 2024-11-09T14:23:45.354Z |
5463912 | 5463912 | 20241102060906_SWjwb | US0008 | 2024-11-03T14:19:24.805Z | 2024-11-09T14:23:44.552Z |
5463727 | 5463727 | 20241102044650_AOVH0 | US0008 | 2024-11-03T14:19:12.077Z | 2024-11-09T14:23:43.605Z |
5459782 | 5459782 | 20241101114938_MJ0oM | US0008 | 2024-11-03T14:12:35.495Z | 2024-11-09T14:23:20.841Z |
5459760 | 5459760 | 20241101114836_DK35I | US0008 | 2024-11-03T14:12:34.333Z | 2024-11-09T14:23:20.609Z |
5459507 | 5459507 | 20241101111018_7eKi5 | US0008 | 2024-11-03T14:12:04.006Z | 2024-11-09T14:23:18.609Z |
5459163 | 5459163 | 20241101101904_6KQK7 | US0008 | 2024-11-03T14:11:26.271Z | 2024-11-09T14:23:16.848Z |
5458793 | 5458793 | 20241101091857_V9yNs | US0008 | 2024-11-03T14:10:37.648Z | 2024-11-09T14:23:14.523Z |
5458428 | 5458428 | 20241101082502_1n2fU | US0008 | 2024-11-03T14:09:44.922Z | 2024-11-09T14:23:11.997Z |
5458296 | 5458296 | 20241101080042_bz3xx | US0008 | 2024-11-03T14:09:31.766Z | 2024-11-09T14:23:11.406Z |
5456890 | 5456890 | 20241102124415_aeP0J | US0008 | 2024-11-03T14:05:53.655Z | 2024-11-09T14:22:45.939Z |
5456369 | 5456369 | 20241102110515_6Ffvj | US0008 | 2024-11-03T14:04:19.087Z | 2024-11-09T14:22:43.298Z |
5456191 | 5456191 | 20241102103919_ppmFV | US0008 | 2024-11-03T14:03:45.472Z | 2024-11-09T14:22:42.371Z |
5456170 | 5456170 | 20241102103410_PihDi | US0008 | 2024-11-03T14:03:39.119Z | 2024-11-09T14:22:42.278Z |
5455959 | 5455959 | 20241102095247_VcBm5 | US0008 | 2024-11-03T14:02:59.070Z | 2024-11-09T14:22:41.093Z |
5455844 | 5455844 | 20241102093016_OoDe5 | US0008 | 2024-11-03T14:02:28.576Z | 2024-11-09T14:22:40.092Z |
5455460 | 5455460 | 20241102075707_KEBdo | US0008 | 2024-11-03T14:01:00.263Z | 2024-11-09T14:22:35.851Z |
5455387 | 5455387 | 20241102073603_Ss1L2 | US0008 | 2024-11-03T14:00:48.408Z | 2024-11-09T14:22:35.178Z |
5455330 | 5455330 | 20241102072204_6P5r8 | US0008 | 2024-11-03T14:00:34.336Z | 2024-11-09T14:22:34.663Z |
5455302 | 5455302 | 20241102071422_2Z533 | US0008 | 2024-11-03T14:00:28.955Z | 2024-11-09T14:22:34.391Z |
5455296 | 5455296 | 20241102071403_xWffi | US0008 | 2024-11-03T14:00:28.317Z | 2024-11-09T14:22:34.354Z |
5455259 | 5455259 | 20241102070221_ThDjv | US0008 | 2024-11-03T14:00:21.869Z | 2024-11-09T14:22:33.974Z |
5455062 | 5455062 | 20241031062000_1oxS5 | US0008 | 2024-11-02T12:23:30.272Z | 2024-11-08T14:23:27.163Z |
5454883 | 5454883 | 20241031053915_SMRb2 | US0008 | 2024-11-02T12:23:25.741Z | 2024-11-08T14:23:26.122Z |
5454649 | 5454649 | 20241031045131_95MSN | US0008 | 2024-11-02T12:23:15.659Z | 2024-11-08T14:23:24.613Z |
5453497 | 5453497 | 20241031021537_D4F1Z | US0008 | 2024-11-02T12:22:34.584Z | 2024-11-08T14:23:17.610Z |
5452932 | 5452932 | 20241101053257_wSfn5 | US0008 | 2024-11-02T12:19:34.838Z | 2024-11-09T14:24:36.375Z |
5452808 | 5452808 | 20241101044249_wDbDk | US0008 | 2024-11-02T12:19:24.065Z | 2024-11-09T14:24:34.148Z |
5452719 | 5452719 | 20241101041411_OojLk | US0008 | 2024-11-02T12:19:17.009Z | 2024-11-09T14:24:33.360Z |
5452443 | 5452443 | 20241101031439_TEge6 | US0008 | 2024-11-02T12:18:49.566Z | 2024-11-09T14:24:31.120Z |
5452218 | 5452218 | 20241101022416_QL2jI | US0008 | 2024-11-02T12:18:28.814Z | 2024-11-09T14:24:29.551Z |
5451940 | 5451940 | 20241101013017_tPVrs | US0008 | 2024-11-02T12:18:07.115Z | 2024-11-09T14:24:26.954Z |
5451873 | 5451873 | 20241101011839_JRbYX | US0008 | 2024-11-02T12:18:03.216Z | 2024-11-09T14:24:26.278Z |
5451806 | 5451806 | 20241101010902_gOdBC | US0008 | 2024-11-02T12:17:58.689Z | 2024-11-09T14:24:25.544Z |
5447948 | 5447948 | 20241031122530_8bRzI | US0008 | 2024-11-02T12:09:29.475Z | 2024-11-09T14:24:01.967Z |
5447864 | 5447864 | 20241031121803_YTRvL | US0008 | 2024-11-02T12:09:20.228Z | 2024-11-09T14:24:01.552Z |
5447811 | 5447811 | 20241031121322_ktXXN | US0008 | 2024-11-02T12:09:11.527Z | 2024-11-09T14:24:01.415Z |
5447775 | 5447775 | 20241031120935_7VZBj | US0008 | 2024-11-02T12:09:04.296Z | 2024-11-09T14:24:01.361Z |
5447766 | 5447766 | 20241031120859_cqjx3 | US0008 | 2024-11-02T12:09:03.329Z | 2024-11-09T14:24:01.337Z |
5447689 | 5447689 | 20241031120249_0nLZk | US0008 | 2024-11-02T12:08:48.885Z | 2024-11-09T14:24:00.866Z |
5447588 | 5447588 | 20241031115447_1J1wa | US0008 | 2024-11-02T12:08:31.469Z | 2024-11-09T14:24:00.532Z |
5447363 | 5447363 | 20241031113525_H0twO | US0008 | 2024-11-02T12:07:59.806Z | 2024-11-09T14:23:59.443Z |
5447106 | 5447106 | 20241031110803_c88yJ | US0008 | 2024-11-02T12:07:18.888Z | 2024-11-09T14:23:57.940Z |
5446947 | 5446947 | 20241031105108_0pfwc | US0008 | 2024-11-02T12:06:46.071Z | 2024-11-09T14:23:57.189Z |
5446924 | 5446924 | 20241031104830_uJP7h | US0008 | 2024-11-02T12:06:43.336Z | 2024-11-09T14:23:57.139Z |
5446811 | 5446811 | 20241031103318_UQ4ou | US0008 | 2024-11-02T12:06:20.536Z | 2024-11-09T14:23:56.587Z |
5446728 | 5446728 | 20241031102705_X7kMQ | US0008 | 2024-11-02T12:06:08.362Z | 2024-11-09T14:23:56.113Z |
5446114 | 5446114 | 20241031092928_ccY9N | US0008 | 2024-11-02T12:04:17.370Z | 2024-11-09T14:23:53.047Z |
5445548 | 5445548 | 20241031081620_GIdgz | US0008 | 2024-11-02T12:02:19.224Z | 2024-11-09T14:23:50.571Z |
5445370 | 5445370 | 20241031075242_Ssa2I | US0008 | 2024-11-02T12:01:53.608Z | 2024-11-09T14:23:49.524Z |
5445303 | 5445303 | 20241031073542_iudmX | US0008 | 2024-11-02T12:01:37.182Z | 2024-11-09T14:23:48.871Z |
5445047 | 5445047 | 20241101073819_UUGqV | US0008 | 2024-11-02T12:00:45.876Z | 2024-11-09T14:23:10.814Z |
5444981 | 5444981 | 20241101071356_P3MkY | US0008 | 2024-11-02T12:00:24.270Z | 2024-11-09T14:23:09.450Z |
5444954 | 5444954 | 20241101065914_gdV4r | US0008 | 2024-11-02T12:00:18.911Z | 2024-11-09T14:23:08.118Z |
5444935 | 5444935 | 20241101065304_2Zea3 | US0008 | 2024-11-02T12:00:13.674Z | 2024-11-09T14:23:07.544Z |
5436038 | 5436038 | 20241030122240_Fm2ze | US0008 | 2024-11-01T12:06:36.665Z | 2024-11-08T14:22:52.601Z |
5435557 | 5435557 | 20241030114140_ZmXdD | US0008 | 2024-11-01T12:05:34.334Z | 2024-11-08T14:22:51.134Z |
5435395 | 5435395 | 20241030112358_2xgVT | US0008 | 2024-11-01T12:05:05.367Z | 2024-11-08T14:22:50.397Z |
5435353 | 5435353 | 20241030112037_osQTd | US0008 | 2024-11-01T12:04:58.520Z | 2024-11-08T14:22:50.251Z |
5435270 | 5435270 | 20241030111134_ngaey | US0008 | 2024-11-01T12:04:40.221Z | 2024-11-08T14:22:49.895Z |
5435078 | 5435078 | 20241030104742_QdWT2 | US0008 | 2024-11-01T12:04:14.238Z | 2024-11-08T14:22:49.147Z |
5435009 | 5435009 | 20241030103554_HiBiY | US0008 | 2024-11-01T12:03:56.422Z | 2024-11-08T14:22:48.937Z |
5434631 | 5434631 | 20241030095042_EanPz | US0008 | 2024-11-01T12:02:57.626Z | 2024-11-08T14:22:47.328Z |
5434489 | 5434489 | 20241030093137_iNgzv | US0008 | 2024-11-01T12:02:30.106Z | 2024-11-08T14:22:46.657Z |
5434478 | 5434478 | 20241030093037_RNNLA | US0008 | 2024-11-01T12:02:29.048Z | 2024-11-08T14:22:46.636Z |
5434393 | 5434393 | 20241030091457_PJxCI | US0008 | 2024-11-01T12:02:09.448Z | 2024-11-08T14:22:46.249Z |
5434335 | 5434335 | 20241030090053_AmUiC | US0008 | 2024-11-01T12:02:00.920Z | 2024-11-08T14:22:46.122Z |
5434100 | 5434100 | 20241030081954_qZCSS | US0008 | 2024-11-01T12:01:15.161Z | 2024-11-08T14:22:44.756Z |
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);