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

6,236 rows where station_code = "US002Y" 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
9612335 9612335 20260406095712_nU2X9 US002Y 2026-04-07T12:01:32.330Z 2026-04-07T12:01:32.330Z
9612064 9612064 20260406055858_k4nsO US002Y 2026-04-07T12:00:37.965Z 2026-04-07T12:00:37.965Z
9598757 9598757 20260331045710_jAkYi US002Y 2026-04-01T12:00:54.461Z 2026-04-07T12:22:13.806Z
9586805 9586805 20260327094245_ZTUV0 US002Y 2026-03-28T12:04:04.678Z 2026-04-05T12:33:49.498Z
9586732 9586732 20260327092006_B9lfl US002Y 2026-03-28T12:03:52.328Z 2026-04-05T12:33:39.516Z
9586168 9586168 20260327042203_Yzk7H US002Y 2026-03-28T12:02:24.970Z 2026-04-05T12:33:05.977Z
9583124 9583124 20260326110943_E5HDn US002Y 2026-03-27T12:07:48.654Z 2026-04-04T12:40:53.100Z
9582938 9582938 20260326100249_Zui93 US002Y 2026-03-27T12:07:16.445Z 2026-04-04T12:40:36.953Z
9582847 9582847 20260326094704_J8tqn US002Y 2026-03-27T12:06:59.939Z 2026-04-04T12:40:32.192Z
9582814 9582814 20260326094101_CAtvI US002Y 2026-03-27T12:06:53.611Z 2026-04-04T12:40:30.191Z
9582488 9582488 20260326080052_kHDtd US002Y 2026-03-27T12:05:57.353Z 2026-04-04T12:40:04.170Z
9577619 9577619 20260325074632_2UahB US002Y 2026-03-26T12:05:39.243Z 2026-04-03T12:37:10.874Z
9572124 9572124 20260324074732_0Mt4l US002Y 2026-03-25T12:03:56.709Z 2026-04-02T12:35:04.609Z
9563405 9563405 20260323081456_xL08U US002Y 2026-03-24T12:05:56.159Z 2026-03-31T12:26:42.538Z
9563326 9563326 20260323075849_9lndz US002Y 2026-03-24T12:05:44.555Z 2026-03-31T12:26:40.764Z
9556308 9556308 20260322100054_1olt8 US002Y 2026-03-23T12:04:38.674Z 2026-03-30T12:28:57.130Z
9556173 9556173 20260322093115_6jKM1 US002Y 2026-03-23T12:04:26.643Z 2026-03-30T12:28:46.606Z
9555965 9555965 20260322085444_J0EmG US002Y 2026-03-23T12:04:12.829Z 2026-03-30T12:28:40.526Z
9555957 9555957 20260322085228_SfuQV US002Y 2026-03-23T12:04:12.050Z 2026-03-30T12:28:40.284Z
9554708 9554708 20260322032816_pFwLq US002Y 2026-03-23T12:02:47.480Z 2026-03-30T12:28:07.688Z
9545799 9545799 20260321110758_DVhnh US002Y 2026-03-22T12:10:17.698Z 2026-03-29T12:19:44.481Z
9545521 9545521 20260321104439_oY92u US002Y 2026-03-22T12:09:37.886Z 2026-03-29T12:19:40.980Z
9545065 9545065 20260321095800_vc2i8 US002Y 2026-03-22T12:08:32.720Z 2026-03-29T12:19:36.702Z
9545029 9545029 20260321095207_0O1ns US002Y 2026-03-22T12:08:26.451Z 2026-03-29T12:19:36.332Z
9544836 9544836 20260321092818_D3L3p US002Y 2026-03-22T12:07:56.174Z 2026-03-29T12:19:34.377Z
9544642 9544642 20260321090613_1cQ25 US002Y 2026-03-22T12:07:22.301Z 2026-03-29T12:19:32.110Z
9544384 9544384 20260321082732_eCKfg US002Y 2026-03-22T12:06:38.411Z 2026-03-29T12:19:29.177Z
9544322 9544322 20260321081833_eeLej US002Y 2026-03-22T12:06:27.490Z 2026-03-29T12:19:28.307Z
9544046 9544046 20260321071359_Z7yog US002Y 2026-03-22T12:05:33.830Z 2026-03-29T12:19:15.549Z
9543970 9543970 20260321065041_SWcqx US002Y 2026-03-22T12:05:19.565Z 2026-03-29T12:19:14.611Z
9543808 9543808 20260321053806_1YloV US002Y 2026-03-22T12:04:49.664Z 2026-03-29T12:19:11.523Z
9537222 9537222 20260320111630_M7ogX US002Y 2026-03-21T12:15:19.066Z 2026-03-28T12:35:23.328Z
9537081 9537081 20260320110433_ic2DN US002Y 2026-03-21T12:15:02.806Z 2026-03-28T12:35:21.008Z
9537037 9537037 20260320105851_CBLGb US002Y 2026-03-21T12:14:57.505Z 2026-03-28T12:35:20.363Z
9536228 9536228 20260320092601_q51bC US002Y 2026-03-21T12:12:51.985Z 2026-03-28T12:34:58.721Z
9535677 9535677 20260320081634_8fn3C US002Y 2026-03-21T12:11:33.373Z 2026-03-28T12:34:48.906Z
9535449 9535449 20260320073800_Ztb73 US002Y 2026-03-21T12:10:50.042Z 2026-03-28T12:34:39.870Z
9535418 9535418 20260320073008_7S0BA US002Y 2026-03-21T12:10:43.803Z 2026-03-28T12:34:34.636Z
9524203 9524203 20260319112927_fl28i US002Y 2026-03-20T12:12:36.387Z 2026-03-27T12:41:49.714Z
9523970 9523970 20260319111037_SvKJa US002Y 2026-03-20T12:12:19.631Z 2026-03-27T12:41:47.732Z
9523764 9523764 20260319104036_P8HAG US002Y 2026-03-20T12:11:57.287Z 2026-03-27T12:41:44.816Z
9523495 9523495 20260319101349_xjo5x US002Y 2026-03-20T12:11:31.583Z 2026-03-27T12:41:29.544Z
9523444 9523444 20260319100428_pZXU1 US002Y 2026-03-20T12:11:27.305Z 2026-03-27T12:41:29.029Z
9523130 9523130 20260319092928_qAkEg US002Y 2026-03-20T12:10:55.025Z 2026-03-27T12:41:25.296Z
9523127 9523127 20260319092907_rY3Z2 US002Y 2026-03-20T12:10:54.664Z 2026-03-27T12:41:25.271Z
9522626 9522626 20260319083032_444Go US002Y 2026-03-20T12:10:08.405Z 2026-03-27T12:41:20.170Z
9522449 9522449 20260319074926_M7Uxz US002Y 2026-03-20T12:09:49.358Z 2026-03-27T12:41:18.233Z
9522431 9522431 20260319074701_Z6moX US002Y 2026-03-20T12:09:48.370Z 2026-03-27T12:41:18.148Z
9522024 9522024 20260319051535_MRU8W US002Y 2026-03-20T12:08:52.776Z 2026-03-27T12:41:12.856Z
9521725 9521725 20260319043944_mW3B7 US002Y 2026-03-20T12:08:27.429Z 2026-03-27T12:41:08.524Z
9513602 9513602 20260318093821_fXHip US002Y 2026-03-19T12:15:45.604Z 2026-03-26T12:37:56.778Z
9513408 9513408 20260318091042_Ur6J3 US002Y 2026-03-19T12:15:14.002Z 2026-03-26T12:37:55.009Z
9513258 9513258 20260318084909_Oqeqk US002Y 2026-03-19T12:14:48.304Z 2026-03-19T12:27:30.505Z
9513119 9513119 20260318083748_m2qk3 US002Y 2026-03-19T12:14:27.886Z 2026-03-26T12:37:52.636Z
9510311 9510311 20260318024406_9pUvm US002Y 2026-03-19T12:07:20.895Z 2026-03-19T12:27:29.902Z
9509493 9509493 20260318015259_dS7gF US002Y 2026-03-19T12:05:25.364Z 2026-03-26T12:37:05.715Z
9504336 9504336 20260317112209_vXSLI US002Y 2026-03-18T12:07:49.141Z 2026-03-25T12:42:21.082Z
9504307 9504307 20260317111630_84qO2 US002Y 2026-03-18T12:07:45.340Z 2026-03-25T12:42:20.867Z
9504255 9504255 20260317110425_37Ydw US002Y 2026-03-18T12:07:35.714Z 2026-03-25T12:42:20.577Z
9502621 9502621 20260317051208_VRvzN US002Y 2026-03-18T12:03:31.989Z 2026-03-25T12:41:51.759Z
9502491 9502491 20260317041514_YBvFn US002Y 2026-03-18T12:03:02.820Z 2026-03-25T12:41:50.478Z
9502436 9502436 20260317035413_DVwf6 US002Y 2026-03-18T12:02:49.253Z 2026-03-25T12:41:49.802Z
9502408 9502408 20260317034228_j1uNt US002Y 2026-03-18T12:02:43.457Z 2026-03-25T12:41:49.476Z
9502270 9502270 20260317030115_7GZvq US002Y 2026-03-18T12:02:11.083Z 2026-03-25T12:41:48.134Z
9502265 9502265 20260317030036_kj2NL US002Y 2026-03-18T12:02:09.776Z 2026-03-25T12:41:48.104Z
9502141 9502141 20260317021717_OhZU5 US002Y 2026-03-18T12:01:40.374Z 2026-03-25T12:41:46.850Z
9496516 9496516 20260316114305_yYZc0 US002Y 2026-03-17T12:09:59.349Z 2026-03-24T12:41:20.136Z
9496147 9496147 20260316104734_4Rb4E US002Y 2026-03-17T12:09:10.705Z 2026-03-24T12:41:18.570Z
9496126 9496126 20260316103757_XmcMk US002Y 2026-03-17T12:09:08.213Z 2026-03-24T12:41:18.414Z
9495985 9495985 20260316095604_vXUC6 US002Y 2026-03-17T12:08:42.596Z 2026-03-24T12:41:17.753Z
9495540 9495540 20260316082107_z6BeG US002Y 2026-03-17T12:07:33.463Z 2026-03-24T12:41:15.278Z
9479355 9479355 20260314112925_REOxn US002Y 2026-03-15T12:13:31.033Z 2026-03-22T12:42:26.258Z
9479161 9479161 20260314110147_zPn33 US002Y 2026-03-15T12:13:01.075Z 2026-03-22T12:42:18.439Z
9479086 9479086 20260314104712_fSC2k US002Y 2026-03-15T12:12:48.056Z 2026-03-22T12:42:14.223Z
9478958 9478958 20260314102659_9qHiM US002Y 2026-03-15T12:12:24.029Z 2026-03-22T12:42:12.624Z
9478267 9478267 20260314085740_CZpBa US002Y 2026-03-15T12:10:40.338Z 2026-03-22T12:42:09.357Z
9478078 9478078 20260314081718_NmSNt US002Y 2026-03-15T12:10:10.592Z 2026-03-22T12:42:08.325Z
9477971 9477971 20260314075305_ovj3u US002Y 2026-03-15T12:09:48.929Z 2026-03-22T12:42:06.832Z
9477863 9477863 20260314071153_SBuCM US002Y 2026-03-15T12:09:26.572Z 2026-03-22T12:42:06.020Z
9477229 9477229 20260314043117_x4K7E US002Y 2026-03-15T12:07:55.208Z 2026-03-22T12:42:01.914Z
9476885 9476885 20260314035238_ipH4K US002Y 2026-03-15T12:07:09.215Z 2026-03-22T12:41:59.975Z
9471769 9471769 20260313113218_IeYCT US002Y 2026-03-14T12:11:23.747Z 2026-03-21T12:49:42.830Z
9471700 9471700 20260313112141_k2Egw US002Y 2026-03-14T12:11:09.893Z 2026-03-21T12:49:41.956Z
9471618 9471618 20260313105947_RXPu5 US002Y 2026-03-14T12:10:57.345Z 2026-03-21T12:49:41.186Z
9471448 9471448 20260313101845_5o1UX US002Y 2026-03-14T12:10:28.038Z 2026-03-21T12:49:22.192Z
9471118 9471118 20260313090907_6P5Z7 US002Y 2026-03-14T12:09:29.203Z 2026-03-21T12:49:17.956Z
9469449 9469449 20260313025040_RNCI3 US002Y 2026-03-14T12:04:18.691Z 2026-03-21T12:48:39.609Z
9466013 9466013 20260312113547_UZXXM US002Y 2026-03-13T12:11:15.446Z 2026-03-20T12:37:06.989Z
9465961 9465961 20260312112756_92Jn2 US002Y 2026-03-13T12:11:07.986Z 2026-03-20T12:37:06.714Z
9465932 9465932 20260312112340_rZim7 US002Y 2026-03-13T12:11:04.971Z 2026-03-20T12:37:06.625Z
9465309 9465309 20260312093712_H4qWi US002Y 2026-03-13T12:09:35.821Z 2026-03-20T12:37:03.542Z
9464825 9464825 20260312074924_Vhm25 US002Y 2026-03-13T12:08:24.429Z 2026-03-20T12:36:56.013Z
9464719 9464719 20260312072413_O2QBp US002Y 2026-03-13T12:08:06.248Z 2026-03-20T12:36:53.202Z
9464511 9464511 20260312054623_arDMG US002Y 2026-03-13T12:07:32.014Z 2026-03-20T12:36:44.504Z
9464495 9464495 20260312053645_oKK3Y US002Y 2026-03-13T12:07:28.916Z 2026-03-20T12:36:43.410Z
9464474 9464474 20260312051659_h7sCo US002Y 2026-03-13T12:07:23.967Z 2026-03-20T12:36:42.935Z
9464437 9464437 20260312050307_WTSmS US002Y 2026-03-13T12:07:16.661Z 2026-03-20T12:36:40.894Z
9464430 9464430 20260312050202_3Scfi US002Y 2026-03-13T12:07:15.027Z 2026-03-20T12:36:40.818Z
9464269 9464269 20260312040743_NDVA7 US002Y 2026-03-13T12:06:45.429Z 2026-03-20T12:36:35.364Z
9409667 9409667 20260228041111_dOFMV US002Y 2026-03-01T14:01:58.664Z 2026-03-08T12:41:26.616Z

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