participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,634 rows where station_code = "US001V" 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 |
---|---|---|---|---|---|
5564989 | 5564989 | 20241120034336_JfDuD | US001V | 2024-11-21T14:18:17.879Z | 2024-11-21T14:18:54.135Z |
5563934 | 5563934 | 20241120021722_FTUOb | US001V | 2024-11-21T14:16:59.814Z | 2024-11-21T14:18:53.950Z |
5563833 | 5563833 | 20241120020910_AVNdM | US001V | 2024-11-21T14:16:47.790Z | 2024-11-21T14:18:53.925Z |
5562896 | 5562896 | 20241120002540_R21qn | US001V | 2024-11-21T14:15:26.628Z | 2024-11-21T14:18:53.756Z |
5560310 | 5560310 | 20241120123444_ayfei | US001V | 2024-11-21T14:08:35.264Z | 2024-11-21T14:08:35.264Z |
5560190 | 5560190 | 20241120121600_ILMtP | US001V | 2024-11-21T14:08:13.399Z | 2024-11-21T14:08:13.399Z |
5560117 | 5560117 | 20241120120356_2b3Gh | US001V | 2024-11-21T14:08:04.771Z | 2024-11-21T14:08:04.771Z |
5560070 | 5560070 | 20241120115405_PFZMp | US001V | 2024-11-21T14:07:58.985Z | 2024-11-21T14:07:58.985Z |
5560036 | 5560036 | 20241120114901_l8mD9 | US001V | 2024-11-21T14:07:54.502Z | 2024-11-21T14:07:54.502Z |
5559789 | 5559789 | 20241120111726_vLaXW | US001V | 2024-11-21T14:07:11.474Z | 2024-11-21T14:07:11.474Z |
5559779 | 5559779 | 20241120111703_KMeAL | US001V | 2024-11-21T14:07:10.717Z | 2024-11-21T14:07:10.717Z |
5559645 | 5559645 | 20241120105340_e2MNM | US001V | 2024-11-21T14:06:52.161Z | 2024-11-21T14:06:52.161Z |
5559634 | 5559634 | 20241120105204_M2pXl | US001V | 2024-11-21T14:06:49.119Z | 2024-11-21T14:06:49.119Z |
5559617 | 5559617 | 20241120105005_EslPQ | US001V | 2024-11-21T14:06:44.385Z | 2024-11-21T14:06:44.385Z |
5559524 | 5559524 | 20241120103842_PSCX8 | US001V | 2024-11-21T14:06:32.078Z | 2024-11-21T14:06:32.078Z |
5559374 | 5559374 | 20241120101311_5KpAb | US001V | 2024-11-21T14:06:10.982Z | 2024-11-21T14:06:10.982Z |
5559307 | 5559307 | 20241120100121_NB5dI | US001V | 2024-11-21T14:05:55.876Z | 2024-11-21T14:05:55.876Z |
5559269 | 5559269 | 20241120095245_i7edA | US001V | 2024-11-21T14:05:46.908Z | 2024-11-21T14:05:46.908Z |
5559196 | 5559196 | 20241120093733_nNAv0 | US001V | 2024-11-21T14:05:35.297Z | 2024-11-21T14:05:35.297Z |
5559159 | 5559159 | 20241120093132_GmVEG | US001V | 2024-11-21T14:05:30.337Z | 2024-11-21T14:05:30.337Z |
5559101 | 5559101 | 20241120092408_KwoCt | US001V | 2024-11-21T14:05:21.777Z | 2024-11-21T14:05:21.777Z |
5559061 | 5559061 | 20241120091009_xOch0 | US001V | 2024-11-21T14:05:11.166Z | 2024-11-21T14:05:11.166Z |
5558992 | 5558992 | 20241120090305_V2uYO | US001V | 2024-11-21T14:04:59.663Z | 2024-11-21T14:04:59.663Z |
5558861 | 5558861 | 20241120083224_4IEhi | US001V | 2024-11-21T14:04:40.425Z | 2024-11-21T14:04:40.425Z |
5558794 | 5558794 | 20241120080311_81a3i | US001V | 2024-11-21T14:04:23.918Z | 2024-11-21T14:04:23.918Z |
5558743 | 5558743 | 20241120075446_oEqkK | US001V | 2024-11-21T14:04:15.525Z | 2024-11-21T14:04:15.525Z |
5558733 | 5558733 | 20241120075135_uxfQv | US001V | 2024-11-21T14:04:12.459Z | 2024-11-21T14:04:12.459Z |
5558660 | 5558660 | 20241120072134_8cs9t | US001V | 2024-11-21T14:03:58.887Z | 2024-11-21T14:03:58.887Z |
5558625 | 5558625 | 20241120071018_S6rE2 | US001V | 2024-11-21T14:03:52.239Z | 2024-11-21T14:03:52.239Z |
5558524 | 5558524 | 20241120062148_rh32B | US001V | 2024-11-21T14:03:30.883Z | 2024-11-21T14:03:30.883Z |
5558460 | 5558460 | 20241120060744_dvsUo | US001V | 2024-11-21T14:03:19.466Z | 2024-11-21T14:03:19.466Z |
5558369 | 5558369 | 20241120060059_hXN1B | US001V | 2024-11-21T14:03:08.789Z | 2024-11-21T14:03:08.789Z |
5558134 | 5558134 | 20241120054012_xHH1s | US001V | 2024-11-21T14:02:34.804Z | 2024-11-21T14:02:34.804Z |
5555206 | 5555206 | 20241119121456_E8kkn | US001V | 2024-11-20T14:04:45.527Z | 2024-11-21T14:18:53.227Z |
5555186 | 5555186 | 20241119120726_73L2j | US001V | 2024-11-20T14:04:41.076Z | 2024-11-21T14:18:53.221Z |
5555115 | 5555115 | 20241119114734_E0Mad | US001V | 2024-11-20T14:04:29.126Z | 2024-11-21T14:18:53.205Z |
5555074 | 5555074 | 20241119113311_H3lN2 | US001V | 2024-11-20T14:04:24.386Z | 2024-11-21T14:18:53.197Z |
5554892 | 5554892 | 20241119105651_5M9jQ | US001V | 2024-11-20T14:03:44.704Z | 2024-11-21T14:18:53.158Z |
5554867 | 5554867 | 20241119105104_lLeZx | US001V | 2024-11-20T14:03:40.067Z | 2024-11-21T14:18:53.151Z |
5554789 | 5554789 | 20241119104000_7Ddnt | US001V | 2024-11-20T14:03:18.252Z | 2024-11-21T14:18:53.134Z |
5554376 | 5554376 | 20241119083741_NqYc8 | US001V | 2024-11-20T14:01:48.600Z | 2024-11-21T14:18:53.041Z |
5554308 | 5554308 | 20241119080124_hZkry | US001V | 2024-11-20T14:01:30.577Z | 2024-11-21T14:18:53.024Z |
5554292 | 5554292 | 20241119074906_ctBBg | US001V | 2024-11-20T14:01:25.003Z | 2024-11-21T14:18:53.020Z |
5546700 | 5546700 | 20241117122008_RGmfv | US001V | 2024-11-18T14:03:52.858Z | 2024-11-21T14:21:24.404Z |
5546608 | 5546608 | 20241117115341_j2Ps5 | US001V | 2024-11-18T14:03:38.794Z | 2024-11-21T14:21:21.321Z |
5546532 | 5546532 | 20241117112552_Zu2sh | US001V | 2024-11-18T14:03:21.900Z | 2024-11-21T14:21:19.645Z |
5546446 | 5546446 | 20241117110305_dcx9f | US001V | 2024-11-18T14:03:07.962Z | 2024-11-21T14:21:18.726Z |
5546441 | 5546441 | 20241117110029_ht7u2 | US001V | 2024-11-18T14:03:07.117Z | 2024-11-21T14:21:18.547Z |
5546349 | 5546349 | 20241117103106_r4aho | US001V | 2024-11-18T14:02:54.522Z | 2024-11-21T14:21:17.100Z |
5546325 | 5546325 | 20241117102554_QrmQG | US001V | 2024-11-18T14:02:51.097Z | 2024-11-21T14:21:16.716Z |
5546246 | 5546246 | 20241117100534_LJpyr | US001V | 2024-11-18T14:02:34.215Z | 2024-11-21T14:21:15.155Z |
5546244 | 5546244 | 20241117100429_TTq7l | US001V | 2024-11-18T14:02:33.517Z | 2024-11-21T14:21:15.121Z |
5546133 | 5546133 | 20241117092200_BwQGg | US001V | 2024-11-18T14:02:12.397Z | 2024-11-21T14:21:11.097Z |
5546044 | 5546044 | 20241117085750_xbLGv | US001V | 2024-11-18T14:01:49.862Z | 2024-11-21T14:21:09.225Z |
5546025 | 5546025 | 20241117085302_qOnXM | US001V | 2024-11-18T14:01:45.075Z | 2024-11-21T14:21:08.840Z |
5546014 | 5546014 | 20241117084755_RYj52 | US001V | 2024-11-18T14:01:43.082Z | 2024-11-21T14:21:08.381Z |
5545686 | 5545686 | 20241117061426_Z7fLa | US001V | 2024-11-18T14:00:39.234Z | 2024-11-21T14:20:57.159Z |
5544466 | 5544466 | 20241116112919_rrjwx | US001V | 2024-11-17T14:01:14.588Z | 2024-11-21T14:22:34.347Z |
5544448 | 5544448 | 20241116111516_jDbkI | US001V | 2024-11-17T14:01:11.419Z | 2024-11-21T14:22:34.137Z |
5544376 | 5544376 | 20241116103355_3xgHv | US001V | 2024-11-17T14:00:58.694Z | 2024-11-21T14:22:32.555Z |
5544348 | 5544348 | 20241116101452_IY4n2 | US001V | 2024-11-17T14:00:55.263Z | 2024-11-21T14:22:32.058Z |
5544273 | 5544273 | 20241116092742_0p6C8 | US001V | 2024-11-17T14:00:43.548Z | 2024-11-21T14:22:30.011Z |
5544268 | 5544268 | 20241116092209_ciBRK | US001V | 2024-11-17T14:00:41.862Z | 2024-11-21T14:22:29.939Z |
5544266 | 5544266 | 20241116092021_wV6p4 | US001V | 2024-11-17T14:00:40.746Z | 2024-11-21T14:22:29.899Z |
5544232 | 5544232 | 20241116085650_egVxu | US001V | 2024-11-17T14:00:32.121Z | 2024-11-21T14:22:29.096Z |
5544174 | 5544174 | 20241116073118_cVS6o | US001V | 2024-11-17T14:00:22.611Z | 2024-11-21T14:22:28.213Z |
5544149 | 5544149 | 20241116070156_baS1z | US001V | 2024-11-17T14:00:19.598Z | 2024-11-21T14:22:28.029Z |
5544147 | 5544147 | 20241116065956_IMdUD | US001V | 2024-11-17T14:00:19.211Z | 2024-11-21T14:22:28.022Z |
5544032 | 5544032 | 20241115052234_GGaJi | US001V | 2024-11-16T14:07:51.443Z | 2024-11-21T14:24:37.892Z |
5543930 | 5543930 | 20241115044238_t7d2c | US001V | 2024-11-16T14:07:41.502Z | 2024-11-21T14:24:36.846Z |
5543914 | 5543914 | 20241115043224_I8kxN | US001V | 2024-11-16T14:07:39.357Z | 2024-11-21T14:24:36.304Z |
5543909 | 5543909 | 20241115042752_uEhTA | US001V | 2024-11-16T14:07:38.609Z | 2024-11-21T14:24:36.141Z |
5542447 | 5542447 | 20241115095238_W83P5 | US001V | 2024-11-16T14:01:20.385Z | 2024-11-21T14:23:27.531Z |
5542381 | 5542381 | 20241115090242_4Grzy | US001V | 2024-11-16T14:01:06.652Z | 2024-11-21T14:23:26.303Z |
5542286 | 5542286 | 20241115080530_1dlnz | US001V | 2024-11-16T14:00:54.283Z | 2024-11-21T14:23:24.880Z |
5542248 | 5542248 | 20241115074248_RK8sH | US001V | 2024-11-16T14:00:48.772Z | 2024-11-21T14:23:23.874Z |
5542206 | 5542206 | 20241115071154_IcwEo | US001V | 2024-11-16T14:00:39.752Z | 2024-11-21T14:23:22.844Z |
5542195 | 5542195 | 20241115070440_BMdXS | US001V | 2024-11-16T14:00:37.476Z | 2024-11-21T14:23:22.536Z |
5542173 | 5542173 | 20241115063406_toeHJ | US001V | 2024-11-16T14:00:29.627Z | 2024-11-21T14:23:21.936Z |
5542098 | 5542098 | 20241115053353_vBLij | US001V | 2024-11-16T14:00:10.188Z | 2024-11-21T14:23:20.383Z |
5541014 | 5541014 | 20241114124536_R9al5 | US001V | 2024-11-15T14:04:56.466Z | 2024-11-21T14:24:18.386Z |
5540754 | 5540754 | 20241114120228_JV3R2 | US001V | 2024-11-15T14:04:24.886Z | 2024-11-21T14:24:15.480Z |
5540752 | 5540752 | 20241114120158_eF9J2 | US001V | 2024-11-15T14:04:24.469Z | 2024-11-21T14:24:15.466Z |
5540647 | 5540647 | 20241114114456_xUPgm | US001V | 2024-11-15T14:04:13.557Z | 2024-11-21T14:24:14.320Z |
5540625 | 5540625 | 20241114114223_h4QYT | US001V | 2024-11-15T14:04:10.952Z | 2024-11-21T14:24:14.058Z |
5540586 | 5540586 | 20241114113504_LOGRC | US001V | 2024-11-15T14:04:05.699Z | 2024-11-21T14:24:13.806Z |
5540562 | 5540562 | 20241114113229_bjsuU | US001V | 2024-11-15T14:04:03.354Z | 2024-11-21T14:24:13.554Z |
5540505 | 5540505 | 20241114111651_pSwSz | US001V | 2024-11-15T14:03:56.577Z | 2024-11-21T14:24:12.745Z |
5540499 | 5540499 | 20241114111513_XlXGb | US001V | 2024-11-15T14:03:55.623Z | 2024-11-21T14:24:12.640Z |
5540425 | 5540425 | 20241114110449_4b8hZ | US001V | 2024-11-15T14:03:42.630Z | 2024-11-21T14:24:11.143Z |
5540394 | 5540394 | 20241114105429_oc3IA | US001V | 2024-11-15T14:03:34.698Z | 2024-11-21T14:24:11.034Z |
5540290 | 5540290 | 20241114103417_S22qr | US001V | 2024-11-15T14:03:16.023Z | 2024-11-21T14:24:10.081Z |
5540275 | 5540275 | 20241114103259_zV8qO | US001V | 2024-11-15T14:03:13.633Z | 2024-11-21T14:24:09.887Z |
5540179 | 5540179 | 20241114101801_Spvbx | US001V | 2024-11-15T14:03:04.769Z | 2024-11-21T14:24:08.554Z |
5540177 | 5540177 | 20241114101758_0FLB7 | US001V | 2024-11-15T14:03:04.521Z | 2024-11-21T14:24:08.540Z |
5540146 | 5540146 | 20241114101457_1OtW5 | US001V | 2024-11-15T14:03:01.760Z | 2024-11-21T14:24:08.372Z |
5540142 | 5540142 | 20241114101341_irawF | US001V | 2024-11-15T14:03:01.245Z | 2024-11-21T14:24:08.241Z |
5540025 | 5540025 | 20241114095142_34CSY | US001V | 2024-11-15T14:02:36.460Z | 2024-11-21T14:24:06.884Z |
5539999 | 5539999 | 20241114094709_6ZKZQ | US001V | 2024-11-15T14:02:30.900Z | 2024-11-21T14:24:06.511Z |
5539933 | 5539933 | 20241114093216_xZnyi | US001V | 2024-11-15T14:02:21.317Z | 2024-11-21T14:24:04.716Z |
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);