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

1,049 rows where station_code = "US0047" 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
9809674 9809674 20260424092558_bMgH2 US0047 2026-04-28T12:59:08.719Z 2026-05-02T13:13:27.194Z
9809671 9809671 20260424092524_Dc9Od US0047 2026-04-28T12:59:08.417Z 2026-05-02T13:13:27.138Z
9809663 9809663 20260424062342_Lx29v US0047 2026-04-28T12:58:05.021Z 2026-05-02T13:12:35.108Z
9809656 9809656 20260424044510_s9piZ US0047 2026-04-28T12:57:44.130Z 2026-05-02T13:12:28.708Z
9809653 9809653 20260424035427_j3jxL US0047 2026-04-28T12:57:37.908Z 2026-05-02T13:12:25.790Z
9809644 9809644 20260424023009_QR3dn US0047 2026-04-28T12:57:02.072Z 2026-05-02T13:11:46.660Z
9775254 9775254 20260423100356_9F2q2 US0047 2026-04-25T12:56:22.494Z 2026-04-30T13:13:58.752Z
9774870 9774870 20260423092632_p0y5X US0047 2026-04-25T12:55:35.662Z 2026-04-30T13:13:55.228Z
9774854 9774854 20260423092438_7re1Z US0047 2026-04-25T12:55:34.369Z 2026-04-30T13:13:54.936Z
9773077 9773077 20260423055611_Dz2gC US0047 2026-04-25T12:51:26.938Z 2026-04-30T13:12:42.252Z
9772919 9772919 20260423051457_T0eSE US0047 2026-04-25T12:50:56.909Z 2026-04-30T13:12:40.272Z
9741228 9741228 20260422101111_5Onv4 US0047 2026-04-23T12:28:05.628Z 2026-04-30T13:21:54.930Z
9741164 9741164 20260422095533_G7k2j US0047 2026-04-23T12:27:42.474Z 2026-04-30T13:21:53.902Z
9741125 9741125 20260422094725_KgDxt US0047 2026-04-23T12:27:39.905Z 2026-04-30T13:21:53.363Z
9740873 9740873 20260422090919_LeGc2 US0047 2026-04-23T12:27:24.216Z 2026-04-30T13:21:37.533Z
9740757 9740757 20260422085241_oK4oT US0047 2026-04-23T12:27:09.920Z 2026-04-30T13:21:29.465Z
9740642 9740642 20260422082948_K4miK US0047 2026-04-23T12:26:44.780Z 2026-04-30T13:21:09.497Z
9730211 9730211 20260421100715_5e6br US0047 2026-04-22T12:30:15.070Z 2026-04-29T13:22:51.560Z
9730197 9730197 20260421100140_YHrYV US0047 2026-04-22T12:30:12.392Z 2026-04-29T13:22:49.824Z
9730164 9730164 20260421095039_xbaii US0047 2026-04-22T12:29:56.338Z 2026-04-29T13:22:44.807Z
9730117 9730117 20260421093947_iuaDq US0047 2026-04-22T12:29:49.664Z 2026-04-29T13:22:37.486Z
9730090 9730090 20260421093359_clmII US0047 2026-04-22T12:29:40.568Z 2026-04-29T13:22:37.198Z
9729808 9729808 20260421083339_wyz5z US0047 2026-04-22T12:28:50.811Z 2026-04-29T13:22:32.817Z
9729726 9729726 20260421081925_Ek3tc US0047 2026-04-22T12:28:42.234Z 2026-04-29T13:22:29.760Z
9729205 9729205 20260421061623_Okq48 US0047 2026-04-22T12:26:58.878Z 2026-04-29T13:22:21.714Z
9728939 9728939 20260421042735_BD8J0 US0047 2026-04-22T12:26:08.265Z 2026-04-29T13:21:43.263Z
9728822 9728822 20260421033930_TgLRs US0047 2026-04-22T12:25:41.297Z 2026-04-29T13:21:32.904Z
9728524 9728524 20260421030121_4VWDj US0047 2026-04-22T12:24:49.119Z 2026-04-29T13:21:19.895Z
9728126 9728126 20260421023715_z6byA US0047 2026-04-22T12:24:01.446Z 2026-04-29T13:21:14.171Z
9727351 9727351 20260421014751_e2N6M US0047 2026-04-22T12:22:10.500Z 2026-04-29T13:21:06.330Z
9721667 9721667 20260420094039_MikVV US0047 2026-04-21T12:31:31.542Z 2026-04-28T13:40:16.878Z
9721603 9721603 20260420092040_OD0rw US0047 2026-04-21T12:31:09.122Z 2026-04-28T13:40:00.124Z
9721574 9721574 20260420090746_52enn US0047 2026-04-21T12:31:06.580Z 2026-04-28T13:39:51.835Z
9721381 9721381 20260420072531_rLLe3 US0047 2026-04-21T12:30:23.911Z 2026-04-28T13:39:35.522Z
9721240 9721240 20260420053851_J8Eo2 US0047 2026-04-21T12:29:51.538Z 2026-04-28T13:39:30.477Z
9721151 9721151 20260420042908_NOiYb US0047 2026-04-21T12:29:26.014Z 2026-04-28T13:39:28.411Z
9721145 9721145 20260420042639_wrUWN US0047 2026-04-21T12:29:24.942Z 2026-04-28T13:39:28.282Z
9704240 9704240 20260418092742_2yYSg US0047 2026-04-19T12:29:27.947Z 2026-04-26T13:14:14.623Z
9704096 9704096 20260418085725_HKW5w US0047 2026-04-19T12:28:59.040Z 2026-04-26T13:13:52.619Z
9703732 9703732 20260418072244_jxSXU US0047 2026-04-19T12:27:50.704Z 2026-04-26T13:12:41.921Z
9703664 9703664 20260418070608_vIdfc US0047 2026-04-19T12:27:42.311Z 2026-04-26T13:12:35.156Z
9703440 9703440 20260418052556_0BdLd US0047 2026-04-19T12:26:48.074Z 2026-04-26T13:12:24.690Z
9697353 9697353 20260418100436_4O3dU US0047 2026-04-19T12:00:47.849Z 2026-04-27T13:43:35.461Z
9697351 9697351 20260418100228_iXMTN US0047 2026-04-19T12:00:47.265Z 2026-04-27T13:43:35.301Z
9697242 9697242 20260418093603_UXKVK US0047 2026-04-19T12:00:16.122Z 2026-04-27T13:43:18.063Z
9696977 9696977 20260417080506_uFb2u US0047 2026-04-18T12:27:41.277Z 2026-04-25T14:01:13.706Z
9691580 9691580 20260417093446_lXizn US0047 2026-04-18T12:00:47.365Z 2026-04-26T13:06:47.519Z
9691541 9691541 20260417091714_tb717 US0047 2026-04-18T12:00:32.610Z 2026-04-26T13:06:41.167Z
9691231 9691231 20260416075519_WJ85j US0047 2026-04-17T12:34:05.514Z 2026-04-24T12:25:26.970Z
9682237 9682237 20260416092656_SAlI5 US0047 2026-04-17T12:01:34.707Z 2026-04-25T13:51:50.203Z
9681940 9681940 20260416084016_kiBC8 US0047 2026-04-17T12:00:28.830Z 2026-04-25T13:51:25.603Z
9681545 9681545 20260415063018_lFZc9 US0047 2026-04-16T12:25:46.492Z 2026-04-23T13:13:08.128Z
9675350 9675350 20260414064841_FSzRd US0047 2026-04-15T12:33:20.130Z 2026-04-22T13:16:21.361Z
9674354 9674354 20260414022237_ros3e US0047 2026-04-15T12:31:14.784Z 2026-04-22T13:16:05.598Z
9666067 9666067 20260413064813_5tLQp US0047 2026-04-14T12:30:10.541Z 2026-04-21T13:18:22.809Z
9666018 9666018 20260413053526_3iRwd US0047 2026-04-14T12:30:03.711Z 2026-04-21T13:18:21.699Z
9665111 9665111 20260413020032_HQn8y US0047 2026-04-14T12:28:19.099Z 2026-04-21T13:18:12.511Z
9659145 9659145 20260413083921_eN6qn US0047 2026-04-14T12:00:59.648Z 2026-04-22T13:11:30.924Z
9659053 9659053 20260413080955_H7dDq US0047 2026-04-14T12:00:40.377Z 2026-04-22T13:11:29.037Z
9658822 9658822 20260412061749_3ShPX US0047 2026-04-13T12:31:12.202Z 2026-04-20T13:08:31.609Z
9652162 9652162 20260412101155_hqOgH US0047 2026-04-13T12:04:45.536Z 2026-04-21T13:14:10.743Z
9652082 9652082 20260412095736_U51fW US0047 2026-04-13T12:04:20.864Z 2026-04-21T13:14:09.473Z
9651579 9651579 20260412074545_rosif US0047 2026-04-13T12:01:52.025Z 2026-04-21T13:13:56.083Z
9651358 9651358 20260412065101_NYSYk US0047 2026-04-13T12:00:38.398Z 2026-04-21T13:13:19.277Z
9651285 9651285 20260412063134_u8vsl US0047 2026-04-13T12:00:17.078Z 2026-04-21T13:13:18.221Z
9651092 9651092 20260410050355_BLqlx US0047 2026-04-12T12:39:55.390Z 2026-04-18T13:04:16.763Z
9651084 9651084 20260410050131_bur2F US0047 2026-04-12T12:39:54.822Z 2026-04-18T13:04:16.491Z
9641859 9641859 20260410101253_7WFIK US0047 2026-04-12T12:07:53.797Z 2026-04-19T13:17:44.225Z
9641520 9641520 20260410084023_Z2cat US0047 2026-04-12T12:06:39.648Z 2026-04-19T13:17:21.947Z
9640446 9640446 20260411093825_X95Sn US0047 2026-04-12T12:01:58.300Z 2026-04-20T13:05:03.142Z
9640246 9640246 20260411073658_JMRRI US0047 2026-04-12T12:00:49.359Z 2026-04-20T13:04:57.950Z
9640186 9640186 20260411065945_o3A9h US0047 2026-04-12T12:00:32.045Z 2026-04-20T13:04:56.841Z
9638989 9638989 20260409085757_FGRio US0047 2026-04-11T12:11:33.265Z 2026-04-18T13:01:08.707Z
9631380 9631380 20260408010928_BUMoP US0047 2026-04-09T12:23:38.711Z 2026-04-16T13:01:28.865Z
9625016 9625016 20260408091540_uOlCB US0047 2026-04-09T12:03:54.520Z 2026-04-17T13:08:19.080Z
9624479 9624479 20260408070901_Uy8ho US0047 2026-04-09T12:01:37.567Z 2026-04-17T13:07:45.521Z
9617091 9617091 20260407102250_n2ZFO US0047 2026-04-08T12:01:56.910Z 2026-04-16T12:57:51.453Z
9617065 9617065 20260407094442_tWjUV US0047 2026-04-08T12:01:44.429Z 2026-04-16T12:57:51.086Z
9616890 9616890 20260407071840_qwN1o US0047 2026-04-08T12:00:53.481Z 2026-04-16T12:57:42.406Z
9616855 9616855 20260407064628_1NZ5k US0047 2026-04-08T12:00:44.360Z 2026-04-16T12:57:41.154Z
9616765 9616765 20260407045557_KWSGD US0047 2026-04-08T12:00:19.100Z 2026-04-16T12:57:36.396Z
9616760 9616760 20260407044101_8VgLd US0047 2026-04-08T12:00:17.973Z 2026-04-16T12:57:36.225Z
9612102 9612102 20260406065923_gWBsd US0047 2026-04-07T12:00:47.986Z 2026-04-15T13:06:18.670Z
9609039 9609039 20260404030909_tWt83 US0047 2026-04-05T12:12:45.200Z 2026-04-12T13:02:11.673Z
9603438 9603438 20260402101933_B2yUS US0047 2026-04-03T12:03:05.516Z 2026-04-11T12:42:05.897Z
9593403 9593403 20260329101829_xsiLO US0047 2026-03-30T12:03:51.647Z 2026-04-07T12:27:09.357Z
9593379 9593379 20260329095840_OSZGI US0047 2026-03-30T12:03:47.074Z 2026-04-07T12:27:08.663Z
9593340 9593340 20260329093513_vIAMv US0047 2026-03-30T12:03:40.815Z 2026-04-07T12:27:07.803Z
9593260 9593260 20260329084524_ejFBz US0047 2026-03-30T12:03:25.052Z 2026-04-07T12:27:05.824Z
9590619 9590619 20260328102645_TC0HT US0047 2026-03-29T12:03:01.413Z 2026-04-06T12:38:27.663Z
9590324 9590324 20260328081524_U0kXZ US0047 2026-03-29T12:02:25.325Z 2026-04-06T12:38:01.337Z
9586746 9586746 20260327092341_6OU6Z US0047 2026-03-28T12:03:55.082Z 2026-04-05T12:33:46.442Z
9586312 9586312 20260327060639_eajQe US0047 2026-03-28T12:02:48.421Z 2026-04-05T12:33:20.398Z
9586302 9586302 20260327060009_2M9ZB US0047 2026-03-28T12:02:47.226Z 2026-04-05T12:33:20.016Z
9586164 9586164 20260327041929_wA1gb US0047 2026-03-28T12:02:23.849Z 2026-04-05T12:33:04.364Z
9582660 9582660 20260326085704_UWBiJ US0047 2026-03-27T12:06:28.553Z 2026-04-04T12:40:17.817Z
9582577 9582577 20260326083136_5KW2v US0047 2026-03-27T12:06:14.410Z 2026-04-04T12:40:11.664Z
9581759 9581759 20260326035522_0OEJN US0047 2026-03-27T12:03:49.271Z 2026-04-04T12:39:20.063Z
9578143 9578143 20260325102410_rduCb US0047 2026-03-26T12:06:50.384Z 2026-04-03T12:37:38.962Z
9571910 9571910 20260324054332_q3gJT US0047 2026-03-25T12:03:09.693Z 2026-04-02T12:34:54.741Z

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