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

300 rows where station_code = "US006D" 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
9612310 9612310 20260406093819_hWzT2 US006D 2026-04-07T12:01:27.130Z 2026-04-07T12:01:27.130Z
9612198 9612198 20260406080551_NZ4Fs US006D 2026-04-07T12:01:04.201Z 2026-04-07T12:01:04.201Z
9608798 9608798 20260404013235_DRTJk US006D 2026-04-05T12:11:46.003Z 2026-04-07T12:18:29.067Z
9607343 9607343 20260404075311_tHHEx US006D 2026-04-05T12:01:44.025Z 2026-04-07T12:14:31.942Z
9607243 9607243 20260404060408_pw4cW US006D 2026-04-05T12:01:09.497Z 2026-04-07T12:14:12.868Z
9607233 9607233 20260404060255_w83Rm US006D 2026-04-05T12:01:02.187Z 2026-04-07T12:14:09.028Z
9607157 9607157 20260404040646_8Ksh3 US006D 2026-04-05T12:00:38.377Z 2026-04-07T12:13:46.424Z
9595574 9595574 20260330062147_PmN3s US006D 2026-03-31T12:01:48.074Z 2026-04-07T12:24:08.206Z
9595572 9595572 20260330062126_xDaZO US006D 2026-03-31T12:01:47.639Z 2026-04-07T12:24:08.169Z
9595564 9595564 20260330060419_VWsda US006D 2026-03-31T12:01:46.157Z 2026-04-07T12:24:07.848Z
9594916 9594916 20260329010132_R1SEk US006D 2026-03-30T12:10:37.645Z 2026-04-06T12:40:20.541Z
9593205 9593205 20260329075605_3Ze2f US006D 2026-03-30T12:03:16.361Z 2026-04-07T12:27:04.410Z
9593111 9593111 20260329061703_QUBJD US006D 2026-03-30T12:02:58.386Z 2026-04-07T12:27:02.047Z
9593062 9593062 20260329045409_NgN4y US006D 2026-03-30T12:02:48.266Z 2026-04-07T12:27:00.504Z
9592976 9592976 20260329040737_VAs1q US006D 2026-03-30T12:02:28.922Z 2026-04-07T12:26:58.215Z
9592684 9592684 20260329030208_TWwHo US006D 2026-03-30T12:01:36.964Z 2026-04-07T12:26:38.452Z
9592633 9592633 20260329024808_JrgaY US006D 2026-03-30T12:01:27.700Z 2026-04-07T12:26:36.269Z
9590500 9590500 20260328093851_Zwk37 US006D 2026-03-29T12:02:48.456Z 2026-04-06T12:38:12.899Z
9590473 9590473 20260328092142_b52N2 US006D 2026-03-29T12:02:43.392Z 2026-04-06T12:38:11.285Z
9590406 9590406 20260328085630_2Q5PP US006D 2026-03-29T12:02:34.758Z 2026-04-06T12:38:06.277Z
9590369 9590369 20260328083845_kOG40 US006D 2026-03-29T12:02:29.543Z 2026-04-06T12:38:03.356Z
9590343 9590343 20260328082112_SgeXU US006D 2026-03-29T12:02:26.985Z 2026-04-06T12:38:02.167Z
9590292 9590292 20260328080622_M5ZVJ US006D 2026-03-29T12:02:22.748Z 2026-04-06T12:38:00.038Z
9590222 9590222 20260328073420_4fUfu US006D 2026-03-29T12:02:14.908Z 2026-04-06T12:37:56.909Z
9590136 9590136 20260328065136_kss32 US006D 2026-03-29T12:02:04.876Z 2026-04-06T12:37:52.673Z
9590134 9590134 20260328065107_13Z00 US006D 2026-03-29T12:02:04.539Z 2026-04-06T12:37:52.506Z
9590093 9590093 20260328051359_2vgBg US006D 2026-03-29T12:01:59.393Z 2026-04-06T12:37:50.311Z
9589789 9589789 20260328040848_4dLtU US006D 2026-03-29T12:01:38.151Z 2026-04-06T12:37:33.460Z
9588754 9588754 20260328010302_MqO1S US006D 2026-03-29T12:00:10.137Z 2026-04-06T12:36:49.850Z
9578102 9578102 20260325095949_RyCml US006D 2026-03-26T12:06:44.444Z 2026-04-03T12:37:37.034Z
9577623 9577623 20260325075015_Ouq3c US006D 2026-03-26T12:05:39.657Z 2026-04-03T12:37:10.982Z
9577545 9577545 20260325071229_hrOc2 US006D 2026-03-26T12:05:28.609Z 2026-04-03T12:37:05.864Z
9577519 9577519 20260325070037_WoLD3 US006D 2026-03-26T12:05:23.846Z 2026-04-03T12:37:04.897Z
9577479 9577479 20260325062819_S40EF US006D 2026-03-26T12:05:14.777Z 2026-04-03T12:37:03.214Z
9572510 9572510 20260324092007_nBdho US006D 2026-03-25T12:05:25.106Z 2026-04-02T12:35:27.924Z
9571668 9571668 20260324032826_mN6G8 US006D 2026-03-25T12:02:16.669Z 2026-04-02T12:34:37.144Z
9571496 9571496 20260324023044_Xmejj US006D 2026-03-25T12:01:41.820Z 2026-04-02T12:34:29.209Z
9536181 9536181 20260320092056_xZmtV US006D 2026-03-21T12:12:46.175Z 2026-03-28T12:34:58.435Z
9536087 9536087 20260320091048_SCCMw US006D 2026-03-21T12:12:35.070Z 2026-03-28T12:34:57.396Z
9535968 9535968 20260320085309_jyTiz US006D 2026-03-21T12:12:15.426Z 2026-03-28T12:34:54.668Z
9535577 9535577 20260320080314_8IkOA US006D 2026-03-21T12:11:13.511Z 2026-03-28T12:34:47.166Z
9535564 9535564 20260320080050_NWJem US006D 2026-03-21T12:11:10.992Z 2026-03-28T12:34:46.714Z
9535509 9535509 20260320074852_5L9IB US006D 2026-03-21T12:11:01.042Z 2026-03-28T12:34:45.318Z
9535316 9535316 20260320070357_jyIrW US006D 2026-03-21T12:10:22.172Z 2026-03-28T12:34:32.676Z
9518394 9518394 20260319005558_NE8be US006D 2026-03-20T12:02:26.509Z 2026-03-27T12:40:09.144Z
9513863 9513863 20260318101207_pV35w US006D 2026-03-19T12:16:21.445Z 2026-03-26T12:38:09.991Z
9513593 9513593 20260318093708_Jhyke US006D 2026-03-19T12:15:43.651Z 2026-03-26T12:37:56.688Z
9513427 9513427 20260318091146_AFjva US006D 2026-03-19T12:15:16.864Z 2026-03-26T12:37:55.166Z
9513097 9513097 20260318083500_tAYwe US006D 2026-03-19T12:14:24.654Z 2026-03-26T12:37:52.558Z
9513080 9513080 20260318083109_IFiSW US006D 2026-03-19T12:14:20.632Z 2026-03-26T12:37:51.417Z
9513040 9513040 20260318082556_EcPE5 US006D 2026-03-19T12:14:13.652Z 2026-03-26T12:37:51.096Z
9512712 9512712 20260318073831_Qt8xC US006D 2026-03-19T12:13:23.725Z 2026-03-26T12:37:48.273Z
9512684 9512684 20260318073327_Ol2RL US006D 2026-03-19T12:13:17.191Z 2026-03-26T12:37:47.990Z
9512620 9512620 20260318071810_OCGyT US006D 2026-03-19T12:13:07.045Z 2026-03-26T12:37:47.321Z
9512546 9512546 20260318070147_q6mCa US006D 2026-03-19T12:12:53.238Z 2026-03-26T12:37:46.511Z
9512543 9512543 20260318070127_sGPjT US006D 2026-03-19T12:12:52.769Z 2026-03-26T12:37:46.466Z
9512491 9512491 20260318063648_yZUYW US006D 2026-03-19T12:12:43.179Z 2026-03-26T12:37:45.962Z
9512427 9512427 20260318061032_3s8MW US006D 2026-03-19T12:12:31.135Z 2026-03-26T12:37:45.172Z
9511374 9511374 20260318034814_arXVB US006D 2026-03-19T12:10:03.383Z 2026-03-26T12:37:36.405Z
9511207 9511207 20260318034017_BRhWj US006D 2026-03-19T12:09:40.913Z 2026-03-26T12:37:26.982Z
9510020 9510020 20260318022847_Cn8H7 US006D 2026-03-19T12:06:45.607Z 2026-03-26T12:37:09.426Z
9508202 9508202 20260318003358_J9QrY US006D 2026-03-19T12:02:36.284Z 2026-03-26T12:36:57.021Z
9484867 9484867 20260315015132_sJjWh US006D 2026-03-16T12:04:25.559Z 2026-03-23T12:21:48.753Z
9478523 9478523 20260314093049_iXegb US006D 2026-03-15T12:11:20.795Z 2026-03-22T12:42:10.573Z
9478187 9478187 20260314083955_kSZne US006D 2026-03-15T12:10:27.113Z 2026-03-22T12:42:08.879Z
9478144 9478144 20260314083544_3CG73 US006D 2026-03-15T12:10:19.297Z 2026-03-22T12:42:08.688Z
9477880 9477880 20260314071914_aqe2A US006D 2026-03-15T12:09:30.729Z 2026-03-22T12:42:06.184Z
9477730 9477730 20260314061600_3DZh1 US006D 2026-03-15T12:08:56.484Z 2026-03-22T12:42:04.762Z
9477673 9477673 20260314055121_ofZJI US006D 2026-03-15T12:08:48.537Z 2026-03-22T12:42:04.451Z
9477458 9477458 20260314045815_32n59 US006D 2026-03-15T12:08:20.767Z 2026-03-22T12:42:02.916Z
9476746 9476746 20260314033754_IDfZR US006D 2026-03-15T12:06:45.726Z 2026-03-22T12:41:59.004Z
9476730 9476730 20260314033559_ELzek US006D 2026-03-15T12:06:43.788Z 2026-03-22T12:41:58.813Z
9476710 9476710 20260314033328_yM2PP US006D 2026-03-15T12:06:41.159Z 2026-03-22T12:41:58.682Z
9470854 9470854 20260313075857_I8BGI US006D 2026-03-14T12:08:38.691Z 2026-03-21T12:49:14.689Z
9470717 9470717 20260313072910_6zvvH US006D 2026-03-14T12:08:11.633Z 2026-03-21T12:49:12.493Z
9470544 9470544 20260313061957_z8FSB US006D 2026-03-14T12:07:40.477Z 2026-03-21T12:49:10.758Z
9470538 9470538 20260313061553_WWH13 US006D 2026-03-14T12:07:39.651Z 2026-03-21T12:49:10.703Z
9470512 9470512 20260313061138_HmwFV US006D 2026-03-14T12:07:36.410Z 2026-03-21T12:49:10.490Z
9470416 9470416 20260313054008_QXOjn US006D 2026-03-14T12:07:18.741Z 2026-03-21T12:49:08.994Z
9470408 9470408 20260313053611_2ZBy2 US006D 2026-03-14T12:07:17.357Z 2026-03-21T12:49:08.745Z
9470366 9470366 20260313052252_ciq2s US006D 2026-03-14T12:07:08.898Z 2026-03-21T12:49:07.938Z
9470286 9470286 20260313050350_e0EoF US006D 2026-03-14T12:06:53.139Z 2026-03-21T12:49:07.166Z
9469927 9469927 20260313040414_NWlAp US006D 2026-03-14T12:05:59.491Z 2026-03-21T12:49:04.353Z
9469707 9469707 20260313033221_5ncyI US006D 2026-03-14T12:05:15.774Z 2026-03-21T12:49:01.004Z
9469633 9469633 20260313032147_37olv US006D 2026-03-14T12:05:01.099Z 2026-03-21T12:48:52.928Z
9457860 9457860 20260311062853_8uRfb US006D 2026-03-12T12:04:50.755Z 2026-03-19T12:44:53.235Z
9457017 9457017 20260311021025_HNybK US006D 2026-03-12T12:02:35.304Z 2026-03-19T12:44:24.754Z
9456957 9456957 20260311015345_GJwSf US006D 2026-03-12T12:02:21.701Z 2026-03-19T12:44:24.085Z
9452344 9452344 20260310093722_XxhOv US006D 2026-03-11T12:05:15.238Z 2026-03-18T12:39:12.112Z
9452270 9452270 20260310091025_InD7i US006D 2026-03-11T12:05:07.102Z 2026-03-18T12:39:11.450Z
9452265 9452265 20260310090947_T5VCC US006D 2026-03-11T12:05:06.528Z 2026-03-18T12:39:11.395Z
9452152 9452152 20260310081459_ZIe7X US006D 2026-03-11T12:04:48.532Z 2026-03-18T12:39:10.031Z
9452003 9452003 20260310053655_T6VWJ US006D 2026-03-11T12:04:24.347Z 2026-03-18T12:39:08.191Z
9451989 9451989 20260310052257_Uq2Oc US006D 2026-03-11T12:04:20.893Z 2026-03-18T12:39:07.946Z
9451847 9451847 20260310042341_QimSr US006D 2026-03-11T12:04:02.497Z 2026-03-18T12:39:05.751Z
9451747 9451747 20260310033702_Kn3dy US006D 2026-03-11T12:03:43.363Z 2026-03-18T12:39:03.792Z
9448331 9448331 20260309102730_qhVN5 US006D 2026-03-10T12:09:33.809Z 2026-03-17T12:42:13.900Z
9448113 9448113 20260309095751_8vmy7 US006D 2026-03-10T12:08:54.373Z 2026-03-17T12:42:00.245Z
9447790 9447790 20260309085014_jXEU8 US006D 2026-03-10T12:07:49.210Z 2026-03-17T12:41:56.735Z
9447767 9447767 20260309084507_r4Lqw US006D 2026-03-10T12:07:45.141Z 2026-03-17T12:41:56.426Z

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