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

2,436 rows where station_code = "US001G" 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
9593224 9593224 20260329081149_A8Yq7 US001G 2026-03-30T12:03:18.731Z 2026-04-06T12:34:58.093Z
9593171 9593171 20260329072229_UfRY3 US001G 2026-03-30T12:03:11.200Z 2026-04-06T12:34:54.486Z
9593107 9593107 20260329061542_jK9cw US001G 2026-03-30T12:02:58.092Z 2026-04-06T12:34:50.865Z
9590137 9590137 20260328065919_E7QHD US001G 2026-03-29T12:02:05.130Z 2026-04-06T12:37:52.763Z
9577779 9577779 20260325083325_FpNzt US001G 2026-03-26T12:06:03.693Z 2026-04-03T12:37:26.753Z
9577734 9577734 20260325081943_VU2Ik US001G 2026-03-26T12:05:57.516Z 2026-04-03T12:37:25.065Z
9577427 9577427 20260325060921_YnyXK US001G 2026-03-26T12:05:06.969Z 2026-04-03T12:37:01.249Z
9577062 9577062 20260325034746_zIFqk US001G 2026-03-26T12:04:00.689Z 2026-04-03T12:36:33.039Z
9572414 9572414 20260324090057_p3ZFs US001G 2026-03-25T12:05:02.070Z 2026-04-02T12:35:23.818Z
9513007 9513007 20260318081756_iU41C US001G 2026-03-19T12:14:07.859Z 2026-03-26T12:37:50.786Z
9512905 9512905 20260318080255_Gvu1u US001G 2026-03-19T12:13:52.392Z 2026-03-26T12:37:50.031Z
9512663 9512663 20260318072721_sdyTn US001G 2026-03-19T12:13:13.245Z 2026-03-26T12:37:47.824Z
9510132 9510132 20260318023353_OzsEK US001G 2026-03-19T12:06:57.022Z 2026-03-26T12:37:10.196Z
9486258 9486258 20260315060741_WTpHZ US001G 2026-03-16T12:09:18.195Z 2026-03-23T12:21:56.261Z
9485909 9485909 20260315040826_vN5NZ US001G 2026-03-16T12:07:59.768Z 2026-03-23T12:21:54.511Z
9485679 9485679 20260315034108_iZVPr US001G 2026-03-16T12:07:15.018Z 2026-03-23T12:21:53.480Z
9485616 9485616 20260315032718_O3aKS US001G 2026-03-16T12:06:58.748Z 2026-03-23T12:21:53.114Z
9484661 9484661 20260315012310_U3Yb5 US001G 2026-03-16T12:03:40.521Z 2026-03-23T12:21:47.755Z
9475986 9475986 20260314022726_0iB0q US001G 2026-03-15T12:04:48.856Z 2026-03-22T12:41:53.568Z
9475946 9475946 20260314022302_tFLit US001G 2026-03-15T12:04:39.079Z 2026-03-22T12:41:53.206Z
9471290 9471290 20260313094232_UYs8P US001G 2026-03-14T12:09:57.320Z 2026-03-21T12:49:19.682Z
9471065 9471065 20260313085446_ZoqK6 US001G 2026-03-14T12:09:19.114Z 2026-03-21T12:49:17.403Z
9457863 9457863 20260311063355_gDemg US001G 2026-03-12T12:04:51.500Z 2026-03-19T12:44:53.298Z
9457709 9457709 20260311045933_t7Rh2 US001G 2026-03-12T12:04:25.015Z 2026-03-19T12:44:51.289Z
9452314 9452314 20260310092727_pkpku US001G 2026-03-11T12:05:11.708Z 2026-03-18T12:39:11.844Z
9452032 9452032 20260310062211_oH84h US001G 2026-03-11T12:04:31.798Z 2026-03-18T12:39:08.630Z
9447265 9447265 20260309061835_Vdbh3 US001G 2026-03-10T12:05:49.713Z 2026-03-17T12:41:49.728Z
9446916 9446916 20260309033504_Yh7Ii US001G 2026-03-10T12:04:28.367Z 2026-03-17T12:41:44.704Z
9425801 9425801 20260305002815_oIDdU US001G 2026-03-06T14:01:43.636Z 2026-03-13T12:34:28.329Z
9416388 9416388 20260302102411_r4uVS US001G 2026-03-03T14:03:36.276Z 2026-03-10T12:36:12.019Z
9412854 9412854 20260301070634_bu6tO US001G 2026-03-02T14:02:15.657Z 2026-03-09T12:39:53.471Z
9410272 9410272 20260228101535_No1ys US001G 2026-03-01T14:03:15.331Z 2026-03-08T12:41:56.793Z
9409968 9409968 20260228074432_xvhJ5 US001G 2026-03-01T14:02:39.215Z 2026-03-08T12:41:45.378Z
9409863 9409863 20260228061318_7FcXr US001G 2026-03-01T14:02:23.274Z 2026-03-08T12:41:35.973Z
9409855 9409855 20260228055920_Zc7G2 US001G 2026-03-01T14:02:22.036Z 2026-03-08T12:41:35.565Z
9409851 9409851 20260228055459_GXpai US001G 2026-03-01T14:02:21.446Z 2026-03-08T12:41:34.445Z
9409690 9409690 20260228042027_sJZLM US001G 2026-03-01T14:02:00.962Z 2026-03-08T12:41:27.525Z
9409579 9409579 20260228035136_H2GOI US001G 2026-03-01T14:01:47.431Z 2026-03-08T12:41:22.996Z
9403534 9403534 20260227100617_CdBYD US001G 2026-02-28T14:08:32.188Z 2026-03-07T14:47:56.784Z
9392811 9392811 20260225065618_54vZP US001G 2026-02-26T14:08:29.018Z 2026-03-05T14:37:09.621Z
9392801 9392801 20260225064452_eq8kb US001G 2026-02-26T14:08:26.684Z 2026-03-05T14:37:09.132Z
9392674 9392674 20260225052023_UUOxb US001G 2026-02-26T14:08:00.175Z 2026-03-05T14:37:04.094Z
9391377 9391377 20260225023135_UHB9t US001G 2026-02-26T14:04:12.522Z 2026-03-05T14:36:19.011Z
9345560 9345560 20260218100745_81yIC US001G 2026-02-20T14:01:33.371Z 2026-02-27T14:34:39.362Z
9345542 9345542 20260218100540_R2Eda US001G 2026-02-20T14:01:33.217Z 2026-02-27T14:34:38.986Z
9345311 9345311 20260218092636_GlMZR US001G 2026-02-20T14:01:28.834Z 2026-02-27T14:34:36.730Z
9345087 9345087 20260218082520_vNDW1 US001G 2026-02-20T14:01:24.284Z 2026-02-27T14:34:33.858Z
9344896 9344896 20260218063250_X8OgS US001G 2026-02-20T14:01:20.646Z 2026-02-27T14:34:30.710Z
9344531 9344531 20260218034611_d8Ov8 US001G 2026-02-20T14:01:14.740Z 2026-02-27T14:34:12.171Z
9335203 9335203 20260217005529_NzMNE US001G 2026-02-18T14:00:12.020Z 2026-02-26T14:38:51.689Z
9328135 9328135 20260215101442_0cXKj US001G 2026-02-16T14:07:30.795Z 2026-02-24T14:42:07.408Z
9328045 9328045 20260215095527_AlQ7c US001G 2026-02-16T14:07:06.156Z 2026-02-24T14:42:06.375Z
9327952 9327952 20260215092820_DXyDg US001G 2026-02-16T14:06:41.875Z 2026-02-24T14:42:05.034Z
9327828 9327828 20260215084927_cH5Gh US001G 2026-02-16T14:06:08.591Z 2026-02-24T14:42:02.077Z
9327690 9327690 20260215080951_4edHY US001G 2026-02-16T14:05:32.923Z 2026-02-24T14:41:59.740Z
9327688 9327688 20260215080844_diy2X US001G 2026-02-16T14:05:32.313Z 2026-02-24T14:41:59.615Z
9327431 9327431 20260215053948_MF6Ag US001G 2026-02-16T14:04:19.207Z 2026-02-24T14:41:54.110Z
9327216 9327216 20260215044152_3AXK7 US001G 2026-02-16T14:03:10.143Z 2026-02-24T14:41:49.609Z
9322065 9322065 20260213014208_LnIzy US001G 2026-02-14T14:22:30.464Z 2026-02-21T14:37:41.662Z
9320203 9320203 20260213083637_z6tTo US001G 2026-02-14T14:05:17.250Z 2026-02-22T14:41:50.524Z
9320201 9320201 20260213083441_aUha7 US001G 2026-02-14T14:05:16.443Z 2026-02-22T14:41:50.441Z
9320122 9320122 20260213073350_g9zAU US001G 2026-02-14T14:04:38.718Z 2026-02-22T14:41:47.652Z
9320117 9320117 20260213072953_Cq1vr US001G 2026-02-14T14:04:37.104Z 2026-02-22T14:41:47.502Z
9320058 9320058 20260213070839_5Vo1y US001G 2026-02-14T14:04:11.483Z 2026-02-22T14:41:46.085Z
9317704 9317704 20260212103738_HesHQ US001G 2026-02-13T14:06:48.187Z 2026-02-21T14:37:02.560Z
9317646 9317646 20260212102021_S3LnD US001G 2026-02-13T14:06:22.645Z 2026-02-21T14:37:01.837Z
9317442 9317442 20260212092801_upak2 US001G 2026-02-13T14:05:12.570Z 2026-02-21T14:36:57.377Z
9317369 9317369 20260212091255_3Z3M2 US001G 2026-02-13T14:04:50.303Z 2026-02-21T14:36:55.874Z
9317307 9317307 20260212085818_FF38y US001G 2026-02-13T14:04:28.191Z 2026-02-21T14:36:54.483Z
9317259 9317259 20260212084534_xN0w0 US001G 2026-02-13T14:04:04.966Z 2026-02-21T14:36:53.519Z
9316967 9316967 20260212051345_pMfXs US001G 2026-02-13T14:01:53.656Z 2026-02-21T14:36:47.625Z
9316962 9316962 20260212051029_EAGqW US001G 2026-02-13T14:01:51.558Z 2026-02-21T14:36:47.531Z
9316944 9316944 20260212045718_pfo10 US001G 2026-02-13T14:01:42.966Z 2026-02-21T14:36:47.172Z
9312118 9312118 20260210074127_YH6QX US001G 2026-02-11T14:03:49.142Z 2026-02-18T14:55:56.917Z
9312023 9312023 20260210063117_6HZth US001G 2026-02-11T14:03:08.191Z 2026-02-18T14:55:44.936Z
9294771 9294771 20260205035931_cB1qW US001G 2026-02-06T14:21:06.335Z 2026-02-13T14:58:06.784Z
9294746 9294746 20260205032921_uUTFY US001G 2026-02-06T14:21:01.125Z 2026-02-13T14:58:03.510Z
9292642 9292642 20260205103607_nG0Ab US001G 2026-02-06T14:06:04.053Z 2026-02-14T15:03:19.892Z
9292469 9292469 20260205095744_BwSAk US001G 2026-02-06T14:05:08.913Z 2026-02-14T15:03:03.949Z
9291825 9291825 20260205070344_GoPXq US001G 2026-02-06T14:01:36.192Z 2026-02-14T15:02:02.367Z
9291662 9291662 20260205045718_weGbx US001G 2026-02-06T14:00:35.277Z 2026-02-14T15:01:47.280Z
9288615 9288615 20260203012327_xTwcl US001G 2026-02-04T14:11:02.429Z 2026-02-11T14:51:05.980Z
9287302 9287302 20260203092234_dV4l5 US001G 2026-02-04T14:01:59.756Z 2026-02-12T14:50:16.556Z
9287259 9287259 20260203090429_urpKp US001G 2026-02-04T14:01:42.461Z 2026-02-12T14:50:13.111Z
9287192 9287192 20260203080329_4s5w4 US001G 2026-02-04T14:01:10.161Z 2026-02-12T14:50:07.252Z
9287183 9287183 20260203073533_BeJm3 US001G 2026-02-04T14:01:06.135Z 2026-02-12T14:50:05.878Z
9287175 9287175 20260203072354_5NUw2 US001G 2026-02-04T14:01:01.361Z 2026-02-12T14:50:02.008Z
9286600 9286600 20260202103034_xYm3X US001G 2026-02-03T14:01:59.049Z 2026-02-11T14:50:08.615Z
9284584 9284584 20260131031032_SPWwT US001G 2026-02-01T14:16:17.940Z 2026-02-08T14:50:11.813Z
9282404 9282404 20260131103710_Rm5U3 US001G 2026-02-01T14:03:29.690Z 2026-02-09T14:50:02.360Z
9282366 9282366 20260131102744_mx7aW US001G 2026-02-01T14:03:18.994Z 2026-02-09T14:49:59.385Z
9282348 9282348 20260131102149_YUP8P US001G 2026-02-01T14:03:13.444Z 2026-02-09T14:49:57.737Z
9282091 9282091 20260131091149_j2RZa US001G 2026-02-01T14:02:03.723Z 2026-02-09T14:49:34.217Z
9282006 9282006 20260131084427_GrnVa US001G 2026-02-01T14:01:39.113Z 2026-02-09T14:49:28.498Z
9281976 9281976 20260131081800_t9tU8 US001G 2026-02-01T14:01:27.029Z 2026-02-09T14:49:25.431Z
9281974 9281974 20260131081737_k2YgG US001G 2026-02-01T14:01:26.090Z 2026-02-09T14:49:25.097Z
9281765 9281765 20260131055713_GnArS US001G 2026-02-01T14:00:12.727Z 2026-02-09T14:49:05.333Z
9281683 9281683 20260130053701_ri1H9 US001G 2026-01-31T14:20:37.823Z 2026-02-07T14:55:09.075Z
9281586 9281586 20260130045655_fNJ1c US001G 2026-01-31T14:20:10.755Z 2026-02-07T14:54:59.558Z
9278336 9278336 20260130072610_9GpZW US001G 2026-01-31T14:00:36.942Z 2026-02-08T14:45:59.824Z

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