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,704 rows where station_code = "US001E" 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
5988896 5988896 20250124130824_qhOYz US001E 2025-01-25T14:10:17.746Z 2025-02-02T14:37:07.828Z
5988621 5988621 20250124122300_pejh0 US001E 2025-01-25T14:09:21.131Z 2025-02-02T14:37:04.288Z
5988333 5988333 20250124115201_eYQ8N US001E 2025-01-25T14:08:25.053Z 2025-02-02T14:37:00.391Z
5988254 5988254 20250124114007_QW6yx US001E 2025-01-25T14:08:08.968Z 2025-02-02T14:36:59.614Z
5987901 5987901 20250124103944_2Czx6 US001E 2025-01-25T14:06:29.905Z 2025-02-02T14:36:54.332Z
5987794 5987794 20250124102029_edwW7 US001E 2025-01-25T14:06:12.801Z 2025-02-02T14:36:52.973Z
5987782 5987782 20250124101853_nSIVu US001E 2025-01-25T14:06:07.326Z 2025-02-02T14:36:52.900Z
5987567 5987567 20250124095228_e83Vc US001E 2025-01-25T14:05:24.749Z 2025-02-02T14:36:49.483Z
5987538 5987538 20250124094754_WNnxX US001E 2025-01-25T14:05:19.751Z 2025-02-02T14:36:49.288Z
5987490 5987490 20250124093622_J3uep US001E 2025-01-25T14:05:09.286Z 2025-02-02T14:36:48.208Z
5987377 5987377 20250124091809_2bhww US001E 2025-01-25T14:04:39.929Z 2025-02-02T14:36:46.412Z
5986899 5986899 20250124070523_emKpZ US001E 2025-01-25T14:02:38.249Z 2025-02-02T14:36:40.807Z
5986807 5986807 20250124063143_m6kU4 US001E 2025-01-25T14:02:11.751Z 2025-02-02T14:36:39.730Z
5986579 5986579 20250124043741_JztOL US001E 2025-01-25T14:01:07.756Z 2025-02-02T14:36:36.285Z
5983188 5983188 20250123132825_CedfA US001E 2025-01-24T14:10:19.770Z 2025-02-01T14:40:19.574Z
5983125 5983125 20250123131803_lbHCr US001E 2025-01-24T14:09:58.393Z 2025-02-01T14:40:18.849Z
5982996 5982996 20250123130151_g2UiL US001E 2025-01-24T14:09:44.241Z 2025-02-01T14:40:17.413Z
5982931 5982931 20250123125423_6TV3t US001E 2025-01-24T14:09:37.588Z 2025-02-01T14:40:16.965Z
5982918 5982918 20250123125314_rv3df US001E 2025-01-24T14:09:35.705Z 2025-02-01T14:40:16.763Z
5982415 5982415 20250123114513_lcwtN US001E 2025-01-24T14:08:13.361Z 2025-02-01T14:40:09.293Z
5982342 5982342 20250123113404_InNJX US001E 2025-01-24T14:07:48.898Z 2025-02-01T14:40:08.418Z
5982321 5982321 20250123113153_72ptV US001E 2025-01-24T14:07:46.075Z 2025-02-01T14:40:08.134Z
5982273 5982273 20250123112321_JHxB2 US001E 2025-01-24T14:07:39.305Z 2025-02-01T14:40:07.683Z
5982200 5982200 20250123111311_Ld9hh US001E 2025-01-24T14:07:29.359Z 2025-02-01T14:40:06.438Z
5981916 5981916 20250123103709_GPaYQ US001E 2025-01-24T14:06:26.523Z 2025-02-01T14:40:01.397Z
5981836 5981836 20250123103145_zgXUc US001E 2025-01-24T14:06:12.431Z 2025-02-01T14:40:00.723Z
5981629 5981629 20250123100218_RYqtz US001E 2025-01-24T14:05:37.093Z 2025-02-01T14:39:58.159Z
5981607 5981607 20250123095929_3BEgh US001E 2025-01-24T14:05:34.422Z 2025-02-01T14:39:57.667Z
5981571 5981571 20250123095350_PWDao US001E 2025-01-24T14:05:27.635Z 2025-02-01T14:39:57.242Z
5981010 5981010 20250123081826_jzq8g US001E 2025-01-24T14:03:18.763Z 2025-02-01T14:39:47.459Z
5980855 5980855 20250123070742_Ukgpn US001E 2025-01-24T14:02:46.040Z 2025-02-01T14:39:42.599Z
5980853 5980853 20250123070654_F2kXa US001E 2025-01-24T14:02:45.425Z 2025-02-01T14:39:42.568Z
5980838 5980838 20250123065033_gGoTL US001E 2025-01-24T14:02:41.795Z 2025-02-01T14:39:42.464Z
5980817 5980817 20250123064351_Ctl9t US001E 2025-01-24T14:02:36.167Z 2025-02-01T14:39:41.625Z
5980810 5980810 20250123064007_gxin2 US001E 2025-01-24T14:02:34.146Z 2025-02-01T14:39:41.265Z
5980804 5980804 20250123063854_s5UtK US001E 2025-01-24T14:02:32.688Z 2025-02-01T14:39:41.140Z
5976960 5976960 20250121095748_Zy5of US001E 2025-01-23T14:15:42.066Z 2025-01-30T14:33:17.408Z
5976733 5976733 20250121085438_Xcs2a US001E 2025-01-23T14:15:15.173Z 2025-01-30T14:33:11.386Z
5976686 5976686 20250121083854_HdaA2 US001E 2025-01-23T14:15:10.278Z 2025-01-30T14:33:09.936Z
5976597 5976597 20250121080426_wLEL2 US001E 2025-01-23T14:14:51.186Z 2025-01-30T14:33:07.579Z
5976376 5976376 20250121060639_DJNnC US001E 2025-01-23T14:14:14.549Z 2025-01-30T14:33:02.168Z
5970536 5970536 20250116030044_0bOYa US001E 2025-01-22T14:31:54.553Z 2025-01-24T14:32:33.578Z
5969095 5969095 20250115134503_I4BKZ US001E 2025-01-22T14:30:22.170Z 2025-01-24T14:32:19.081Z
5969034 5969034 20250115132408_VWj2p US001E 2025-01-22T14:30:17.840Z 2025-01-24T14:32:18.562Z
5967346 5967346 20250116134849_H33jc US001E 2025-01-22T14:27:51.372Z 2025-01-25T14:39:32.136Z
5967193 5967193 20250116130143_3L2JD US001E 2025-01-22T14:27:41.192Z 2025-01-25T14:39:28.644Z
5958561 5958561 20250119132409_2gBzO US001E 2025-01-20T14:05:28.766Z 2025-01-28T14:35:40.233Z
5957399 5957399 20250119062220_fIs3X US001E 2025-01-20T14:01:13.812Z 2025-01-28T14:35:15.097Z
5956198 5956198 20250118124535_ihnuF US001E 2025-01-19T14:04:23.215Z 2025-01-27T14:44:42.644Z
5956173 5956173 20250118124323_iv7Ov US001E 2025-01-19T14:04:21.292Z 2025-01-27T14:44:42.450Z
5953989 5953989 20250117131751_ZsawS US001E 2025-01-18T14:03:04.664Z 2025-01-26T14:34:15.223Z
5953949 5953949 20250117125031_lFyqB US001E 2025-01-18T14:02:49.379Z 2025-01-26T14:34:14.251Z
5953400 5953400 20250116121911_0U9pk US001E 2025-01-17T14:03:47.334Z 2025-01-25T14:39:23.233Z
5953330 5953330 20250116115939_zwMrx US001E 2025-01-17T14:03:33.829Z 2025-01-25T14:39:21.658Z
5952177 5952177 20250115120120_EZbc9 US001E 2025-01-16T14:02:45.048Z 2025-01-24T14:32:15.582Z
5952175 5952175 20250115115819_XtekB US001E 2025-01-16T14:02:44.541Z 2025-01-24T14:32:15.569Z
5952022 5952022 20250115105803_vkSR4 US001E 2025-01-16T14:01:58.341Z 2025-01-24T14:32:13.849Z
5951948 5951948 20250115104057_yDfjN US001E 2025-01-16T14:01:43.892Z 2025-01-24T14:32:13.108Z
5950791 5950791 20250114132550_vyDvv US001E 2025-01-15T14:03:00.265Z 2025-01-23T14:33:24.218Z
5950716 5950716 20250114125724_CS2rc US001E 2025-01-15T14:02:37.214Z 2025-01-23T14:33:23.275Z
5950703 5950703 20250114125241_bgOcZ US001E 2025-01-15T14:02:34.451Z 2025-01-23T14:33:23.148Z
5950668 5950668 20250114123857_qQGkP US001E 2025-01-15T14:02:27.108Z 2025-01-23T14:33:22.683Z
5950666 5950666 20250114123829_ZUHfm US001E 2025-01-15T14:02:26.635Z 2025-01-23T14:33:22.679Z
5950529 5950529 20250114113936_dB68n US001E 2025-01-15T14:01:50.401Z 2025-01-23T14:33:20.935Z
5950504 5950504 20250114113123_EWDze US001E 2025-01-15T14:01:46.109Z 2025-01-23T14:33:20.664Z
5950464 5950464 20250114111432_VWtjE US001E 2025-01-15T14:01:36.435Z 2025-01-23T14:33:20.194Z
5950457 5950457 20250114111303_EbRcx US001E 2025-01-15T14:01:34.246Z 2025-01-23T14:33:20.130Z
5950398 5950398 20250114103553_3leoR US001E 2025-01-15T14:01:19.010Z 2025-01-23T14:33:19.174Z
5950360 5950360 20250114101316_FRNJf US001E 2025-01-15T14:01:04.469Z 2025-01-23T14:33:18.277Z
5950183 5950183 20250114074540_hCizb US001E 2025-01-15T14:00:23.326Z 2025-01-23T14:33:15.517Z
5948883 5948883 20250113133236_OTRYd US001E 2025-01-14T14:02:39.449Z 2025-01-22T14:33:43.282Z
5948832 5948832 20250113131855_db20L US001E 2025-01-14T14:02:30.675Z 2025-01-22T14:33:42.712Z
5948816 5948816 20250113131028_SV08P US001E 2025-01-14T14:02:28.611Z 2025-01-22T14:33:42.448Z
5948774 5948774 20250113125257_1cdcD US001E 2025-01-14T14:02:20.599Z 2025-01-22T14:33:41.601Z
5948715 5948715 20250113123717_hBzP5 US001E 2025-01-14T14:02:04.119Z 2025-01-22T14:33:40.546Z
5948692 5948692 20250113122156_2sNic US001E 2025-01-14T14:01:57.910Z 2025-01-22T14:33:40.275Z
5948590 5948590 20250113114544_G2E5B US001E 2025-01-14T14:01:41.126Z 2025-01-22T14:33:37.018Z
5948468 5948468 20250113110812_D8RTp US001E 2025-01-14T14:01:13.362Z 2025-01-22T14:33:34.634Z
5948387 5948387 20250113102807_Viu78 US001E 2025-01-14T14:00:57.427Z 2025-01-22T14:33:32.907Z
5948378 5948378 20250113102225_H0Pio US001E 2025-01-14T14:00:54.994Z 2025-01-22T14:33:32.812Z
5948253 5948253 20250113075106_V83SX US001E 2025-01-14T14:00:21.813Z 2025-01-22T14:33:30.858Z
5947104 5947104 20250112131033_lyI6e US001E 2025-01-13T14:03:50.952Z 2025-01-21T14:18:52.666Z
5947078 5947078 20250112130607_2lQVp US001E 2025-01-13T14:03:46.357Z 2025-01-21T14:18:44.463Z
5947046 5947046 20250112130028_Ya4MT US001E 2025-01-13T14:03:41.615Z 2025-01-21T14:18:43.096Z
5947003 5947003 20250112125241_ipBjP US001E 2025-01-13T14:03:31.348Z 2025-01-21T14:18:41.264Z
5946964 5946964 20250112124723_aL2PD US001E 2025-01-13T14:03:18.073Z 2025-01-21T14:18:37.915Z
5946666 5946666 20250112112647_jplcf US001E 2025-01-13T14:02:11.741Z 2025-01-21T14:18:25.595Z
5946658 5946658 20250112112505_Phjpn US001E 2025-01-13T14:02:02.777Z 2025-01-21T14:18:25.186Z
5946356 5946356 20250112100533_P0ALu US001E 2025-01-13T14:01:03.551Z 2025-01-21T14:18:07.636Z
5946354 5946354 20250112100338_7XfIW US001E 2025-01-13T14:01:03.078Z 2025-01-21T14:18:07.546Z
5946170 5946170 20250112083555_IVDx3 US001E 2025-01-13T14:00:26.886Z 2025-01-21T14:17:59.304Z
5945925 5945925 20250111130147_whZe7 US001E 2025-01-12T14:04:24.036Z 2025-01-20T14:20:49.745Z
5945782 5945782 20250111124027_Qnszc US001E 2025-01-12T14:03:52.687Z 2025-01-20T14:20:46.693Z
5945662 5945662 20250111122349_NRXRK US001E 2025-01-12T14:03:21.964Z 2025-01-20T14:20:43.999Z
5945601 5945601 20250111120804_0lFVH US001E 2025-01-12T14:03:07.796Z 2025-01-20T14:20:42.559Z
5945518 5945518 20250111115439_Ke9eh US001E 2025-01-12T14:02:47.769Z 2025-01-20T14:20:40.864Z
5945413 5945413 20250111113406_woaAT US001E 2025-01-12T14:02:21.483Z 2025-01-20T14:20:37.539Z
5945353 5945353 20250111111852_ChbvB US001E 2025-01-12T14:02:06.957Z 2025-01-20T14:20:32.809Z
5945244 5945244 20250111105353_Y2pl1 US001E 2025-01-12T14:01:42.241Z 2025-01-20T14:20:25.636Z
5945213 5945213 20250111104455_huDqP US001E 2025-01-12T14:01:34.142Z 2025-01-20T14:20:24.218Z

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