home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

8,953 rows where station_code = "US002X" sorted by created_at descending

✎ View and edit SQL

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
9599036 9599036 20260331110748_mw7Sk US002X 2026-04-01T12:02:08.597Z 2026-04-06T12:27:21.754Z
9598957 9598957 20260331093709_j75R0 US002X 2026-04-01T12:01:45.128Z 2026-04-06T12:27:11.903Z
9598883 9598883 20260331082551_yWtj8 US002X 2026-04-01T12:01:25.472Z 2026-04-06T12:27:04.613Z
9598803 9598803 20260331073231_hqD21 US002X 2026-04-01T12:01:09.137Z 2026-04-06T12:27:00.068Z
9598777 9598777 20260331061028_RirFt US002X 2026-04-01T12:01:01.677Z 2026-04-06T12:26:58.378Z
9598775 9598775 20260331060717_ABu6P US002X 2026-04-01T12:01:00.902Z 2026-04-06T12:26:58.204Z
9596113 9596113 20260330111513_udxtO US002X 2026-03-31T12:03:30.459Z 2026-04-06T12:30:58.744Z
9596076 9596076 20260330110407_zpBIH US002X 2026-03-31T12:03:21.308Z 2026-04-06T12:30:51.147Z
9596063 9596063 20260330105759_I5Jk8 US002X 2026-03-31T12:03:17.801Z 2026-04-06T12:30:50.414Z
9596061 9596061 20260330105755_xb23X US002X 2026-03-31T12:03:17.352Z 2026-04-06T12:30:50.236Z
9595847 9595847 20260330092348_Ss45I US002X 2026-03-31T12:02:41.759Z 2026-04-06T12:30:37.498Z
9595786 9595786 20260330083928_5LQeJ US002X 2026-03-31T12:02:30.351Z 2026-04-06T12:30:33.069Z
9595781 9595781 20260330083837_exrGj US002X 2026-03-31T12:02:28.301Z 2026-04-06T12:30:32.542Z
9595611 9595611 20260330071247_TWBg2 US002X 2026-03-31T12:01:54.685Z 2026-04-06T12:30:13.445Z
9595567 9595567 20260330060800_saj28 US002X 2026-03-31T12:01:46.904Z 2026-04-06T12:30:10.349Z
9593320 9593320 20260329091048_0yG9J US002X 2026-03-30T12:03:35.993Z 2026-04-06T12:35:11.120Z
9587113 9587113 20260327111612_uM0XX US002X 2026-03-28T12:04:47.613Z 2026-04-05T12:34:02.136Z
9587098 9587098 20260327110932_T6Bua US002X 2026-03-28T12:04:45.835Z 2026-04-05T12:34:01.634Z
9587051 9587051 20260327105933_PbCL2 US002X 2026-03-28T12:04:41.617Z 2026-04-05T12:34:00.267Z
9586962 9586962 20260327103243_rxEe7 US002X 2026-03-28T12:04:27.858Z 2026-04-05T12:33:56.315Z
9586835 9586835 20260327095549_40VBU US002X 2026-03-28T12:04:11.610Z 2026-04-05T12:33:51.221Z
9586673 9586673 20260327090522_OD5Cx US002X 2026-03-28T12:03:45.047Z 2026-04-05T12:33:37.135Z
9586650 9586650 20260327085415_MazBe US002X 2026-03-28T12:03:39.382Z 2026-04-05T12:33:35.954Z
9586533 9586533 20260327081259_3BE6a US002X 2026-03-28T12:03:21.535Z 2026-04-05T12:33:29.578Z
9586497 9586497 20260327080227_bL3zw US002X 2026-03-28T12:03:16.883Z 2026-04-05T12:33:28.137Z
9586279 9586279 20260327054218_mhzZU US002X 2026-03-28T12:02:42.755Z 2026-04-05T12:33:18.824Z
9586276 9586276 20260327054118_1IViP US002X 2026-03-28T12:02:42.411Z 2026-04-05T12:33:18.695Z
9585874 9585874 20260327025538_Fe9wr US002X 2026-03-28T12:01:37.718Z 2026-04-05T12:32:50.772Z
9583154 9583154 20260326112439_v0B3F US002X 2026-03-27T12:07:53.425Z 2026-04-04T12:40:54.173Z
9582713 9582713 20260326091012_01seP US002X 2026-03-27T12:06:34.992Z 2026-04-04T12:40:25.010Z
9582636 9582636 20260326085057_ckU3T US002X 2026-03-27T12:06:24.418Z 2026-04-04T12:40:16.583Z
9582571 9582571 20260326082956_LKlPd US002X 2026-03-27T12:06:12.285Z 2026-04-04T12:40:11.144Z
9582539 9582539 20260326082102_UrdQM US002X 2026-03-27T12:06:05.876Z 2026-04-04T12:40:07.919Z
9582439 9582439 20260326072834_4JKjt US002X 2026-03-27T12:05:45.660Z 2026-04-04T12:40:00.980Z
9582179 9582179 20260326044914_rvFai US002X 2026-03-27T12:04:49.770Z 2026-04-04T12:39:40.432Z
9581869 9581869 20260326040351_P2ie3 US002X 2026-03-27T12:04:00.402Z 2026-04-04T12:39:23.487Z
9581064 9581064 20260326021815_F2ZW2 US002X 2026-03-27T12:02:02.699Z 2026-04-04T12:38:41.265Z
9577474 9577474 20260325062801_VVjJ4 US002X 2026-03-26T12:05:14.325Z 2026-04-03T12:37:03.055Z
9577371 9577371 20260325052246_erjAY US002X 2026-03-26T12:04:56.741Z 2026-04-03T12:36:59.110Z
9577351 9577351 20260325050613_OOW23 US002X 2026-03-26T12:04:52.720Z 2026-04-03T12:36:58.044Z
9577242 9577242 20260325042305_Zer4I US002X 2026-03-26T12:04:31.334Z 2026-04-03T12:36:52.969Z
9562619 9562619 20260323024832_3BJk3 US002X 2026-03-24T12:03:34.673Z 2026-03-31T12:26:15.838Z
9556731 9556731 20260322112623_2yNGO US002X 2026-03-23T12:05:09.637Z 2026-03-30T12:29:09.297Z
9556365 9556365 20260322101553_6ZnNi US002X 2026-03-23T12:04:42.692Z 2026-03-30T12:28:58.751Z
9556330 9556330 20260322100509_b7HEC US002X 2026-03-23T12:04:40.103Z 2026-03-30T12:28:57.657Z
9556130 9556130 20260322092158_2DyCn US002X 2026-03-23T12:04:23.049Z 2026-03-30T12:28:45.577Z
9556104 9556104 20260322091933_qZ2at US002X 2026-03-23T12:04:21.569Z 2026-03-30T12:28:44.976Z
9555781 9555781 20260322075442_aw1Gp US002X 2026-03-23T12:03:54.093Z 2026-03-30T12:28:34.814Z
9555638 9555638 20260322071345_BWyHH US002X 2026-03-23T12:03:43.571Z 2026-03-30T12:28:31.086Z
9555631 9555631 20260322070604_JPS4s US002X 2026-03-23T12:03:42.792Z 2026-03-30T12:28:30.860Z
9555625 9555625 20260322070453_MeDSt US002X 2026-03-23T12:03:42.350Z 2026-03-30T12:28:30.755Z
9555554 9555554 20260322063639_2TGa4 US002X 2026-03-23T12:03:37.114Z 2026-03-30T12:28:29.246Z
9555492 9555492 20260322054527_nMUkw US002X 2026-03-23T12:03:29.649Z 2026-03-30T12:28:27.491Z
9555486 9555486 20260322052453_2Ewp3 US002X 2026-03-23T12:03:29.352Z 2026-03-30T12:28:27.473Z
9555420 9555420 20260322045537_3UM2X US002X 2026-03-23T12:03:25.335Z 2026-03-30T12:28:26.376Z
9555043 9555043 20260322035859_9wHUa US002X 2026-03-23T12:03:06.804Z 2026-03-30T12:28:13.632Z
9554123 9554123 20260322024129_FICq8 US002X 2026-03-23T12:02:14.895Z 2026-03-30T12:27:58.615Z
9553905 9553905 20260322022422_HSw2h US002X 2026-03-23T12:01:59.205Z 2026-03-30T12:27:54.767Z
9553469 9553469 20260322014426_Sckks US002X 2026-03-23T12:01:32.216Z 2026-03-30T12:27:41.757Z
9545848 9545848 20260321111347_ud10x US002X 2026-03-22T12:10:24.844Z 2026-03-29T12:19:45.007Z
9545623 9545623 20260321105234_zl8ki US002X 2026-03-22T12:09:52.402Z 2026-03-29T12:19:41.928Z
9545454 9545454 20260321103711_4YmpP US002X 2026-03-22T12:09:27.447Z 2026-03-29T12:19:40.345Z
9545418 9545418 20260321103238_mEQSA US002X 2026-03-22T12:09:23.201Z 2026-03-29T12:19:39.970Z
9545195 9545195 20260321101200_kQhxu US002X 2026-03-22T12:08:52.606Z 2026-03-29T12:19:37.983Z
9544956 9544956 20260321094537_uvSgj US002X 2026-03-22T12:08:14.283Z 2026-03-29T12:19:35.724Z
9544858 9544858 20260321093228_h4Jnz US002X 2026-03-22T12:08:00.125Z 2026-03-29T12:19:34.634Z
9544745 9544745 20260321091755_aSMvr US002X 2026-03-22T12:07:39.623Z 2026-03-29T12:19:33.544Z
9544693 9544693 20260321091003_1zr5D US002X 2026-03-22T12:07:31.036Z 2026-03-29T12:19:32.587Z
9544453 9544453 20260321083910_MU7dL US002X 2026-03-22T12:06:52.047Z 2026-03-29T12:19:30.026Z
9544286 9544286 20260321081155_x62dA US002X 2026-03-22T12:06:17.954Z 2026-03-29T12:19:27.908Z
9544118 9544118 20260321074211_USPr0 US002X 2026-03-22T12:05:47.237Z 2026-03-29T12:19:16.497Z
9544116 9544116 20260321073946_R29jn US002X 2026-03-22T12:05:46.696Z 2026-03-29T12:19:16.479Z
9544035 9544035 20260321070729_kWy2W US002X 2026-03-22T12:05:31.323Z 2026-03-29T12:19:15.420Z
9543823 9543823 20260321054029_8Ql66 US002X 2026-03-22T12:04:51.775Z 2026-03-29T12:19:11.641Z
9543803 9543803 20260321053626_VMr7P US002X 2026-03-22T12:04:48.899Z 2026-03-29T12:19:11.479Z
9543255 9543255 20260321031650_HVLDu US002X 2026-03-22T12:03:11.172Z 2026-03-29T12:19:05.185Z
9542883 9542883 20260321014437_5Ky26 US002X 2026-03-22T12:01:53.110Z 2026-03-29T12:18:59.429Z
9536925 9536925 20260320104520_wTzYp US002X 2026-03-21T12:14:41.265Z 2026-03-28T12:35:18.659Z
9536775 9536775 20260320103124_gocWm US002X 2026-03-21T12:14:19.225Z 2026-03-28T12:35:15.871Z
9536588 9536588 20260320100652_hgFgb US002X 2026-03-21T12:13:49.689Z 2026-03-28T12:35:04.118Z
9536491 9536491 20260320095701_Qm3Y4 US002X 2026-03-21T12:13:37.357Z 2026-03-28T12:35:02.658Z
9536447 9536447 20260320095233_XS9lX US002X 2026-03-21T12:13:30.230Z 2026-03-28T12:35:01.986Z
9536024 9536024 20260320090105_aO58J US002X 2026-03-21T12:12:23.887Z 2026-03-28T12:34:55.497Z
9535971 9535971 20260320085553_MZd4y US002X 2026-03-21T12:12:16.457Z 2026-03-28T12:34:54.734Z
9535777 9535777 20260320083249_m1Px5 US002X 2026-03-21T12:11:50.816Z 2026-03-28T12:34:51.052Z
9535673 9535673 20260320081501_FsjKp US002X 2026-03-21T12:11:31.165Z 2026-03-28T12:34:48.697Z
9535624 9535624 20260320081041_u2Uvj US002X 2026-03-21T12:11:22.534Z 2026-03-28T12:34:47.823Z
9535574 9535574 20260320080251_jB9g2 US002X 2026-03-21T12:11:13.095Z 2026-03-28T12:34:47.029Z
9535148 9535148 20260320054954_Hyprr US002X 2026-03-21T12:09:53.964Z 2026-03-28T12:34:28.323Z
9535129 9535129 20260320054727_dWtzP US002X 2026-03-21T12:09:50.622Z 2026-03-28T12:34:27.951Z
9535117 9535117 20260320054102_QYyEU US002X 2026-03-21T12:09:48.379Z 2026-03-28T12:34:27.778Z
9535092 9535092 20260320053302_hIIca US002X 2026-03-21T12:09:43.375Z 2026-03-28T12:34:27.073Z
9535041 9535041 20260320051713_H70ey US002X 2026-03-21T12:09:34.422Z 2026-03-28T12:34:26.131Z
9534976 9534976 20260320045215_IFi0I US002X 2026-03-21T12:09:22.189Z 2026-03-28T12:34:24.517Z
9534411 9534411 20260320034837_RyIuN US002X 2026-03-21T12:07:55.781Z 2026-03-28T12:34:18.062Z
9534195 9534195 20260320033511_Vi7G9 US002X 2026-03-21T12:07:25.505Z 2026-03-28T12:34:15.883Z
9533050 9533050 20260320015317_yT2zy US002X 2026-03-21T12:04:18.674Z 2026-03-28T12:33:48.109Z
9523806 9523806 20260319104703_Ut5fE US002X 2026-03-20T12:12:01.986Z 2026-03-27T12:41:45.377Z
9523766 9523766 20260319104055_LFtLq US002X 2026-03-20T12:11:57.517Z 2026-03-27T12:41:44.875Z
9523263 9523263 20260319094530_X5IBg US002X 2026-03-20T12:11:09.830Z 2026-03-27T12:41:27.273Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network