participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000K" 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 |
---|---|---|---|---|---|
5565247 | 5565247 | 20241120040751_7WrOs | US000K | 2024-11-21T14:18:43.737Z | 2024-11-21T14:18:54.180Z |
5564857 | 5564857 | 20241120033149_Y5Zb7 | US000K | 2024-11-21T14:18:08.410Z | 2024-11-21T14:18:54.112Z |
5564849 | 5564849 | 20241120033052_9BPlT | US000K | 2024-11-21T14:18:07.625Z | 2024-11-21T14:18:54.110Z |
5564127 | 5564127 | 20241120023147_IUrkE | US000K | 2024-11-21T14:17:12.618Z | 2024-11-21T14:18:53.985Z |
5560390 | 5560390 | 20241120124624_n2peD | US000K | 2024-11-21T14:08:46.719Z | 2024-11-21T14:08:46.719Z |
5560151 | 5560151 | 20241120120801_Pw7CK | US000K | 2024-11-21T14:08:07.755Z | 2024-11-21T14:08:07.755Z |
5560130 | 5560130 | 20241120120531_4kYOI | US000K | 2024-11-21T14:08:06.331Z | 2024-11-21T14:08:06.331Z |
5560042 | 5560042 | 20241120114950_YQzXy | US000K | 2024-11-21T14:07:55.697Z | 2024-11-21T14:07:55.697Z |
5559970 | 5559970 | 20241120113949_IFWsQ | US000K | 2024-11-21T14:07:42.590Z | 2024-11-21T14:07:42.590Z |
5559813 | 5559813 | 20241120112127_NoRsY | US000K | 2024-11-21T14:07:14.397Z | 2024-11-21T14:07:14.397Z |
5559515 | 5559515 | 20241120103601_A4Qi2 | US000K | 2024-11-21T14:06:30.155Z | 2024-11-21T14:06:30.155Z |
5559432 | 5559432 | 20241120102212_PD2YI | US000K | 2024-11-21T14:06:18.779Z | 2024-11-21T14:06:18.779Z |
5559340 | 5559340 | 20241120100552_DLgWy | US000K | 2024-11-21T14:06:01.372Z | 2024-11-21T14:06:01.372Z |
5559056 | 5559056 | 20241120090829_QMPUy | US000K | 2024-11-21T14:05:10.045Z | 2024-11-21T14:05:10.045Z |
5559052 | 5559052 | 20241120090803_xc9g2 | US000K | 2024-11-21T14:05:09.587Z | 2024-11-21T14:05:09.587Z |
5558988 | 5558988 | 20241120090256_82jXv | US000K | 2024-11-21T14:04:58.927Z | 2024-11-21T14:04:58.927Z |
5558770 | 5558770 | 20241120075903_MHTYq | US000K | 2024-11-21T14:04:18.898Z | 2024-11-21T14:04:18.898Z |
5558752 | 5558752 | 20241120075721_2yVOW | US000K | 2024-11-21T14:04:17.467Z | 2024-11-21T14:04:17.467Z |
5558722 | 5558722 | 20241120074712_hHilb | US000K | 2024-11-21T14:04:10.605Z | 2024-11-21T14:04:10.605Z |
5558644 | 5558644 | 20241120071542_sIkKk | US000K | 2024-11-21T14:03:55.541Z | 2024-11-21T14:03:55.541Z |
5557880 | 5557880 | 20241120052146_VqhJE | US000K | 2024-11-21T14:01:59.974Z | 2024-11-21T14:01:59.974Z |
5557788 | 5557788 | 20241120051129_oYbgh | US000K | 2024-11-21T14:01:45.185Z | 2024-11-21T14:01:45.185Z |
5557716 | 5557716 | 20241120050751_U9KtZ | US000K | 2024-11-21T14:01:34.804Z | 2024-11-21T14:01:34.804Z |
5556952 | 5556952 | 20241119030537_h43bo | US000K | 2024-11-20T14:11:45.850Z | 2024-11-21T14:20:41.797Z |
5556918 | 5556918 | 20241119024819_Cqikw | US000K | 2024-11-20T14:11:41.442Z | 2024-11-21T14:20:39.671Z |
5555257 | 5555257 | 20241119122505_h7GdN | US000K | 2024-11-20T14:05:01.424Z | 2024-11-21T14:18:53.236Z |
5555253 | 5555253 | 20241119122452_i6lHd | US000K | 2024-11-20T14:05:01.172Z | 2024-11-21T14:18:53.236Z |
5555108 | 5555108 | 20241119114528_aVyBD | US000K | 2024-11-20T14:04:27.908Z | 2024-11-21T14:18:53.202Z |
5555033 | 5555033 | 20241119112327_LMfHO | US000K | 2024-11-20T14:04:09.592Z | 2024-11-21T14:18:53.187Z |
5554955 | 5554955 | 20241119111031_iEX4N | US000K | 2024-11-20T14:03:53.344Z | 2024-11-21T14:18:53.172Z |
5554945 | 5554945 | 20241119110914_gvZ3V | US000K | 2024-11-20T14:03:52.136Z | 2024-11-21T14:18:53.169Z |
5554909 | 5554909 | 20241119110033_KmDxW | US000K | 2024-11-20T14:03:47.456Z | 2024-11-21T14:18:53.161Z |
5554855 | 5554855 | 20241119105033_X9Hbk | US000K | 2024-11-20T14:03:33.489Z | 2024-11-21T14:18:53.148Z |
5554634 | 5554634 | 20241119095200_7BJ3N | US000K | 2024-11-20T14:02:51.474Z | 2024-11-21T14:18:53.099Z |
5554466 | 5554466 | 20241119090920_mWNQs | US000K | 2024-11-20T14:02:14.310Z | 2024-11-21T14:18:53.062Z |
5554443 | 5554443 | 20241119090138_Ugeza | US000K | 2024-11-20T14:02:04.883Z | 2024-11-21T14:18:53.057Z |
5554247 | 5554247 | 20241119072414_pB6Y3 | US000K | 2024-11-20T14:01:14.267Z | 2024-11-21T14:18:53.009Z |
5553964 | 5553964 | 20241119045854_Qn4L9 | US000K | 2024-11-20T14:00:12.559Z | 2024-11-21T14:18:52.943Z |
5551114 | 5551114 | 20241118122820_XLBIN | US000K | 2024-11-19T14:03:55.935Z | 2024-11-21T14:19:43.581Z |
5551078 | 5551078 | 20241118122227_KXyz7 | US000K | 2024-11-19T14:03:53.190Z | 2024-11-21T14:19:42.734Z |
5551003 | 5551003 | 20241118120755_p9B7l | US000K | 2024-11-19T14:03:45.567Z | 2024-11-21T14:19:40.907Z |
5550975 | 5550975 | 20241118120525_2tctX | US000K | 2024-11-19T14:03:43.081Z | 2024-11-21T14:19:40.127Z |
5550897 | 5550897 | 20241118114453_hOssa | US000K | 2024-11-19T14:03:21.064Z | 2024-11-21T14:19:36.681Z |
5542599 | 5542599 | 20241115110924_8SEn7 | US000K | 2024-11-16T14:01:53.030Z | 2024-11-21T14:23:30.377Z |
5542577 | 5542577 | 20241115110556_vEcBh | US000K | 2024-11-16T14:01:50.065Z | 2024-11-21T14:23:29.852Z |
5542564 | 5542564 | 20241115105829_jClfW | US000K | 2024-11-16T14:01:47.995Z | 2024-11-21T14:23:29.651Z |
5542357 | 5542357 | 20241115085346_S5Qx8 | US000K | 2024-11-16T14:01:03.206Z | 2024-11-21T14:23:26.028Z |
5542299 | 5542299 | 20241115080941_RAOhG | US000K | 2024-11-16T14:00:55.531Z | 2024-11-21T14:23:25.009Z |
5542260 | 5542260 | 20241115074535_wJjmy | US000K | 2024-11-16T14:00:50.329Z | 2024-11-21T14:23:24.419Z |
5542237 | 5542237 | 20241115073229_UpCKv | US000K | 2024-11-16T14:00:46.793Z | 2024-11-21T14:23:23.664Z |
5542223 | 5542223 | 20241115072125_5rumA | US000K | 2024-11-16T14:00:43.100Z | 2024-11-21T14:23:23.127Z |
5541946 | 5541946 | 20241114051552_qBbMB | US000K | 2024-11-15T14:08:42.410Z | 2024-11-21T14:25:20.772Z |
5541875 | 5541875 | 20241114050049_OeyOQ | US000K | 2024-11-15T14:08:36.403Z | 2024-11-21T14:25:20.085Z |
5541743 | 5541743 | 20241114041545_yWU3j | US000K | 2024-11-15T14:08:18.878Z | 2024-11-21T14:25:18.395Z |
5540836 | 5540836 | 20241114121322_lMw87 | US000K | 2024-11-15T14:04:32.516Z | 2024-11-21T14:24:16.655Z |
5540822 | 5540822 | 20241114121119_J2ECc | US000K | 2024-11-15T14:04:31.561Z | 2024-11-21T14:24:16.564Z |
5540707 | 5540707 | 20241114115329_aRPMV | US000K | 2024-11-15T14:04:19.461Z | 2024-11-21T14:24:14.731Z |
5540609 | 5540609 | 20241114113913_7Z5Rb | US000K | 2024-11-15T14:04:08.582Z | 2024-11-21T14:24:13.932Z |
5540488 | 5540488 | 20241114111147_Qdnvb | US000K | 2024-11-15T14:03:54.632Z | 2024-11-21T14:24:11.959Z |
5540419 | 5540419 | 20241114110128_9tohj | US000K | 2024-11-15T14:03:39.650Z | 2024-11-21T14:24:11.121Z |
5540253 | 5540253 | 20241114102858_cqovB | US000K | 2024-11-15T14:03:11.526Z | 2024-11-21T14:24:09.387Z |
5540243 | 5540243 | 20241114102749_Gh5b9 | US000K | 2024-11-15T14:03:10.515Z | 2024-11-21T14:24:09.300Z |
5539945 | 5539945 | 20241114093302_7qwFE | US000K | 2024-11-15T14:02:22.649Z | 2024-11-21T14:24:05.319Z |
5539930 | 5539930 | 20241114093209_bp3wa | US000K | 2024-11-15T14:02:21.073Z | 2024-11-21T14:24:04.707Z |
5539921 | 5539921 | 20241114093104_b3PdL | US000K | 2024-11-15T14:02:19.881Z | 2024-11-21T14:24:04.643Z |
5539904 | 5539904 | 20241114092745_lGVLL | US000K | 2024-11-15T14:02:18.449Z | 2024-11-21T14:24:04.152Z |
5539640 | 5539640 | 20241114081926_nuLqE | US000K | 2024-11-15T14:01:35.496Z | 2024-11-21T14:23:58.447Z |
5539531 | 5539531 | 20241114074255_5LVpf | US000K | 2024-11-15T14:01:15.544Z | 2024-11-21T14:23:57.378Z |
5539370 | 5539370 | 20241114063601_o5zdQ | US000K | 2024-11-15T14:00:51.125Z | 2024-11-21T14:23:54.548Z |
5539022 | 5539022 | 20241113053334_jTTto | US000K | 2024-11-14T14:14:08.582Z | 2024-11-21T14:26:31.018Z |
5538766 | 5538766 | 20241113045251_zl0eq | US000K | 2024-11-14T14:13:56.340Z | 2024-11-21T14:26:28.695Z |
5538425 | 5538425 | 20241113034024_bHy7a | US000K | 2024-11-14T14:13:25.700Z | 2024-11-21T14:26:25.571Z |
5538082 | 5538082 | 20241113020651_McRwl | US000K | 2024-11-14T14:12:49.793Z | 2024-11-21T14:26:20.617Z |
5535519 | 5535519 | 20241112124254_KQ2zz | US000K | 2024-11-14T14:08:01.583Z | 2024-11-21T14:25:48.961Z |
5535369 | 5535369 | 20241112121907_ZDHuM | US000K | 2024-11-14T14:07:51.571Z | 2024-11-21T14:25:46.690Z |
5534966 | 5534966 | 20241112111653_IwyaK | US000K | 2024-11-14T14:07:02.404Z | 2024-11-21T14:25:42.706Z |
5534945 | 5534945 | 20241112111307_xTRRt | US000K | 2024-11-14T14:07:00.870Z | 2024-11-21T14:25:41.802Z |
5534887 | 5534887 | 20241112110435_PoUNx | US000K | 2024-11-14T14:06:57.275Z | 2024-11-21T14:25:41.454Z |
5534504 | 5534504 | 20241113122739_g8guM | US000K | 2024-11-14T14:04:30.016Z | 2024-11-21T14:25:02.774Z |
5534479 | 5534479 | 20241113121954_rwUmu | US000K | 2024-11-14T14:04:27.971Z | 2024-11-21T14:25:02.565Z |
5534424 | 5534424 | 20241113120414_JFoI2 | US000K | 2024-11-14T14:04:23.361Z | 2024-11-21T14:25:01.756Z |
5534413 | 5534413 | 20241113120209_HMqWF | US000K | 2024-11-14T14:04:22.810Z | 2024-11-21T14:25:01.604Z |
5534390 | 5534390 | 20241113115711_U4Y5S | US000K | 2024-11-14T14:04:20.863Z | 2024-11-21T14:25:01.269Z |
5534349 | 5534349 | 20241113114909_Xk15k | US000K | 2024-11-14T14:04:17.656Z | 2024-11-21T14:25:01.000Z |
5534212 | 5534212 | 20241113112028_KOw3a | US000K | 2024-11-14T14:03:48.367Z | 2024-11-21T14:24:59.861Z |
5534177 | 5534177 | 20241113111355_91NOY | US000K | 2024-11-14T14:03:42.259Z | 2024-11-21T14:24:59.625Z |
5534129 | 5534129 | 20241113110306_NwQub | US000K | 2024-11-14T14:03:38.564Z | 2024-11-21T14:24:59.222Z |
5534111 | 5534111 | 20241113110120_HlO31 | US000K | 2024-11-14T14:03:34.852Z | 2024-11-21T14:24:58.796Z |
5533989 | 5533989 | 20241113103550_ImtGd | US000K | 2024-11-14T14:03:23.867Z | 2024-11-21T14:24:57.885Z |
5533971 | 5533971 | 20241113103232_jK0vv | US000K | 2024-11-14T14:03:21.866Z | 2024-11-21T14:24:57.729Z |
5533914 | 5533914 | 20241113102604_vhmqA | US000K | 2024-11-14T14:03:16.431Z | 2024-11-21T14:24:56.922Z |
5533881 | 5533881 | 20241113102234_8Gi3u | US000K | 2024-11-14T14:03:10.483Z | 2024-11-21T14:24:56.505Z |
5533817 | 5533817 | 20241113101254_WikWa | US000K | 2024-11-14T14:02:54.964Z | 2024-11-21T14:24:55.692Z |
5533776 | 5533776 | 20241113100601_7pXQp | US000K | 2024-11-14T14:02:47.272Z | 2024-11-21T14:24:55.064Z |
5533742 | 5533742 | 20241113100004_omSZ4 | US000K | 2024-11-14T14:02:43.996Z | 2024-11-21T14:24:54.580Z |
5533484 | 5533484 | 20241113090616_AOW2o | US000K | 2024-11-14T14:02:06.574Z | 2024-11-21T14:24:50.581Z |
5533448 | 5533448 | 20241113085719_5uQr9 | US000K | 2024-11-14T14:02:00.855Z | 2024-11-21T14:24:50.021Z |
5533310 | 5533310 | 20241113082643_OaKec | US000K | 2024-11-14T14:01:41.332Z | 2024-11-21T14:24:48.033Z |
5533289 | 5533289 | 20241113082304_L0L6C | US000K | 2024-11-14T14:01:39.932Z | 2024-11-21T14:24:47.809Z |
5533280 | 5533280 | 20241113081708_FHAtp | US000K | 2024-11-14T14:01:38.939Z | 2024-11-21T14:24:47.682Z |
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);