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 = "US001T" 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
4224129 4224129 20240420112240_3lvjG US001T 2024-04-22T12:05:27.483Z 2024-04-28T12:21:45.095Z
4223957 4223957 20240420102625_7k2Wq US001T 2024-04-22T12:05:01.443Z 2024-04-28T12:21:39.271Z
4223911 4223911 20240420100743_Syaoh US001T 2024-04-22T12:04:52.443Z 2024-04-28T12:21:36.644Z
4223763 4223763 20240420063201_B848i US001T 2024-04-22T12:04:23.114Z 2024-04-28T12:21:32.276Z
4220849 4220849 20240419110949_8ScDL US001T 2024-04-21T12:05:13.939Z 2024-04-27T12:20:31.415Z
4220844 4220844 20240419110521_KB57u US001T 2024-04-21T12:05:12.793Z 2024-04-27T12:20:30.059Z
4220546 4220546 20240419083053_zhEsc US001T 2024-04-21T12:04:25.267Z 2024-04-27T12:20:23.194Z
4220542 4220542 20240419082617_QXIZ9 US001T 2024-04-21T12:04:24.597Z 2024-04-27T12:20:23.059Z
4220516 4220516 20240419081135_p2YB2 US001T 2024-04-21T12:04:21.097Z 2024-04-27T12:20:22.212Z
4220506 4220506 20240419080832_mLcD7 US001T 2024-04-21T12:04:20.421Z 2024-04-27T12:20:22.137Z
4220492 4220492 20240419075402_QhenT US001T 2024-04-21T12:04:18.263Z 2024-04-27T12:20:21.939Z
4220368 4220368 20240419050658_AggPR US001T 2024-04-21T12:03:50.645Z 2024-04-27T12:20:17.414Z
4215323 4215323 20240418120511_B42dw US001T 2024-04-20T12:08:20.950Z 2024-04-26T12:17:18.726Z
4215285 4215285 20240418120109_ruo7r US001T 2024-04-20T12:08:18.223Z 2024-04-26T12:17:18.362Z
4215091 4215091 20240418112341_Q2kfl US001T 2024-04-20T12:07:39.892Z 2024-04-26T12:17:15.577Z
4214587 4214587 20240418085628_ZlgD9 US001T 2024-04-20T12:06:12.659Z 2024-04-26T12:17:08.114Z
4214264 4214264 20240418062120_jj0ks US001T 2024-04-20T12:04:51.895Z 2024-04-26T12:17:01.808Z
4208406 4208406 20240417120808_3CnAZ US001T 2024-04-19T12:05:49.263Z 2024-04-25T12:22:00.761Z
4207323 4207323 20240417093528_LkRgO US001T 2024-04-19T12:03:59.919Z 2024-04-25T12:21:46.231Z
4206906 4206906 20240417073847_L0NxW US001T 2024-04-19T12:03:03.047Z 2024-04-25T12:21:37.760Z
4206883 4206883 20240417073624_krEuk US001T 2024-04-19T12:03:00.350Z 2024-04-25T12:21:37.459Z
4195266 4195266 20240415065235_qo98Q US001T 2024-04-17T12:05:33.033Z 2024-04-23T12:24:58.030Z
4177302 4177302 20240411090536_wZ2uw US001T 2024-04-13T12:11:33.939Z 2024-04-19T12:13:23.159Z
4177234 4177234 20240411082034_AZlk9 US001T 2024-04-13T12:11:27.303Z 2024-04-19T12:13:22.348Z
4177232 4177232 20240411081917_v3aaJ US001T 2024-04-13T12:11:27.071Z 2024-04-19T12:13:22.347Z
4177207 4177207 20240411081249_8C7X0 US001T 2024-04-13T12:11:25.157Z 2024-04-19T12:13:21.577Z
4173191 4173191 20240410113111_MPpAL US001T 2024-04-12T12:11:05.136Z 2024-04-18T12:21:34.217Z
4173166 4173166 20240410112603_vAlTn US001T 2024-04-12T12:11:01.918Z 2024-04-18T12:21:34.038Z
4173089 4173089 20240410110745_K3B4w US001T 2024-04-12T12:10:54.931Z 2024-04-18T12:21:33.489Z
4173024 4173024 20240410105213_lI25x US001T 2024-04-12T12:10:44.365Z 2024-04-18T12:21:32.890Z
4172963 4172963 20240410102859_un5RU US001T 2024-04-12T12:10:32.493Z 2024-04-18T12:21:32.418Z
4172572 4172572 20240410075358_vhpwR US001T 2024-04-12T12:09:53.277Z 2024-04-18T12:21:27.899Z
4172502 4172502 20240410072849_rgUE3 US001T 2024-04-12T12:09:42.211Z 2024-04-18T12:21:27.004Z
4172178 4172178 20240410041251_QxUQf US001T 2024-04-12T12:08:54.834Z 2024-04-18T12:21:22.758Z
4158159 4158159 20240407071400_TEfjo US001T 2024-04-09T12:08:53.378Z 2024-04-15T12:19:21.685Z
4158101 4158101 20240407064349_6wqsY US001T 2024-04-09T12:08:46.712Z 2024-04-15T12:19:21.367Z
4140190 4140190 20240402095744_J8091 US001T 2024-04-04T12:10:40.972Z 2024-04-10T12:18:13.738Z
4133645 4133645 20240401115750_qoJ2W US001T 2024-04-02T12:05:37.435Z 2024-04-09T12:21:20.655Z
4133610 4133610 20240401110047_62Z0a US001T 2024-04-02T12:05:30.392Z 2024-04-09T12:21:19.919Z
4133605 4133605 20240401105220_xDshP US001T 2024-04-02T12:05:29.854Z 2024-04-09T12:21:19.802Z
4133570 4133570 20240401100758_baIWU US001T 2024-04-02T12:05:26.638Z 2024-04-09T12:21:19.430Z
4133480 4133480 20240401080255_J34El US001T 2024-04-02T12:05:15.782Z 2024-04-09T12:21:18.201Z
4133278 4133278 20240401041342_Q3X5Y US001T 2024-04-02T12:04:40.539Z 2024-04-09T12:21:15.740Z
4131371 4131371 20240331122442_3UTgm US001T 2024-04-01T12:09:42.881Z 2024-04-08T12:19:02.779Z
4131086 4131086 20240331105843_sgKOE US001T 2024-04-01T12:09:16.907Z 2024-04-08T12:19:00.706Z
4131023 4131023 20240331103003_EUGC1 US001T 2024-04-01T12:09:10.187Z 2024-04-08T12:19:00.351Z
4131007 4131007 20240331102425_C7XgM US001T 2024-04-01T12:09:08.563Z 2024-04-08T12:19:00.274Z
4130990 4130990 20240331101931_moZ41 US001T 2024-04-01T12:09:06.767Z 2024-04-08T12:19:00.109Z
4130903 4130903 20240331093313_C2YKi US001T 2024-04-01T12:08:59.602Z 2024-04-08T12:18:59.160Z
4126076 4126076 20240330121257_ew7km US001T 2024-03-31T12:10:35.509Z 2024-04-07T12:24:33.725Z
4126019 4126019 20240330120338_dm2XG US001T 2024-03-31T12:10:29.205Z 2024-04-07T12:24:33.420Z
4125782 4125782 20240330110053_7Q5gv US001T 2024-03-31T12:10:16.865Z 2024-04-07T12:24:32.261Z
4125665 4125665 20240330102633_513Nz US001T 2024-03-31T12:10:10.313Z 2024-04-07T12:24:31.783Z
4125440 4125440 20240330092505_tyx7m US001T 2024-03-31T12:09:42.770Z 2024-04-07T12:24:30.640Z
3944785 3944785 20240210122542_GIZZS US001T 2024-02-11T14:08:44.748Z 2024-02-18T14:22:20.644Z
3773300 3773300 20240107141312_19ybw US001T 2024-01-10T14:06:28.578Z 2024-01-16T14:27:12.163Z
3759364 3759364 20240105103956_VlUmo US001T 2024-01-08T14:09:14.302Z 2024-01-14T14:23:06.409Z
3759125 3759125 20240105091705_uHVKk US001T 2024-01-08T14:08:47.571Z 2024-01-14T14:23:03.017Z
3759018 3759018 20240105084017_B5qRP US001T 2024-01-08T14:08:21.503Z 2024-01-14T14:23:01.662Z
3758886 3758886 20240105074550_kuXIe US001T 2024-01-08T14:08:05.454Z 2024-01-14T14:23:00.101Z
3711277 3711277 20231223122521_AWpIe US001T 2024-01-06T00:05:55.078Z 2024-01-06T00:05:55.078Z
3711263 3711263 20231223120544_QZjW9 US001T 2024-01-06T00:05:55.076Z 2024-01-06T00:05:55.076Z
3711140 3711140 20231223083225_DzIfY US001T 2024-01-06T00:05:53.916Z 2024-01-06T00:05:53.916Z
3549006 3549006 20231209011104_5d1jo US001T 2024-01-06T00:05:08.063Z 2024-01-06T00:05:08.063Z
3539910 3539910 20231208035419_QpveB US001T 2024-01-06T00:05:05.688Z 2024-01-06T00:05:05.688Z
3535238 3535238 20231207131030_bh7jx US001T 2024-01-06T00:05:03.800Z 2024-01-06T00:05:03.800Z
3482968 3482968 20231126140259_emqRq US001T 2024-01-06T00:04:44.832Z 2024-01-06T00:04:44.832Z
3482964 3482964 20231126140006_kg3Xf US001T 2024-01-06T00:04:44.831Z 2024-01-06T00:04:44.831Z
3482793 3482793 20231126123606_GNLp0 US001T 2024-01-06T00:04:44.810Z 2024-01-06T00:04:44.810Z
3482711 3482711 20231126121312_OWWDR US001T 2024-01-06T00:04:44.801Z 2024-01-06T00:04:44.801Z
3482591 3482591 20231126113443_IRHrx US001T 2024-01-06T00:04:44.788Z 2024-01-06T00:04:44.788Z
3482482 3482482 20231126110844_Xsy3l US001T 2024-01-06T00:04:44.776Z 2024-01-06T00:04:44.776Z
3482218 3482218 20231126091244_8NW0q US001T 2024-01-06T00:04:44.743Z 2024-01-06T00:04:44.743Z
3482190 3482190 20231126085023_ywL3p US001T 2024-01-06T00:04:44.739Z 2024-01-06T00:04:44.739Z
3482150 3482150 20231126083053_N35Nw US001T 2024-01-06T00:04:44.734Z 2024-01-06T00:04:44.734Z
3480952 3480952 20231125131149_PjNEv US001T 2024-01-06T00:04:43.414Z 2024-01-06T00:04:43.414Z
3480954 3480954 20231125131429_RX2l9 US001T 2024-01-06T00:04:43.414Z 2024-01-06T00:04:43.414Z
3480934 3480934 20231125130557_3dzb1 US001T 2024-01-06T00:04:43.411Z 2024-01-06T00:04:43.411Z
3470778 3470778 20231124140025_F5pff US001T 2024-01-06T00:04:41.408Z 2024-01-06T00:04:41.408Z
3470595 3470595 20231124125016_yVvY9 US001T 2024-01-06T00:04:41.390Z 2024-01-06T00:04:41.390Z
3470575 3470575 20231124124613_cmR3s US001T 2024-01-06T00:04:41.388Z 2024-01-06T00:04:41.388Z
3470460 3470460 20231124121306_LN9ko US001T 2024-01-06T00:04:41.374Z 2024-01-06T00:04:41.374Z
3470417 3470417 20231124120505_oxDz5 US001T 2024-01-06T00:04:41.369Z 2024-01-06T00:04:41.369Z
3470153 3470153 20231124111607_NOxKR US001T 2024-01-06T00:04:41.342Z 2024-01-06T00:04:41.342Z
3469829 3469829 20231124102212_Uu3KN US001T 2024-01-06T00:04:41.310Z 2024-01-06T00:04:41.310Z
3469521 3469521 20231124091622_9cdr3 US001T 2024-01-06T00:04:41.277Z 2024-01-06T00:04:41.277Z
3469448 3469448 20231124085356_EWTNg US001T 2024-01-06T00:04:41.268Z 2024-01-06T00:04:41.268Z
3469417 3469417 20231124084235_9Y8MU US001T 2024-01-06T00:04:41.264Z 2024-01-06T00:04:41.264Z
3469374 3469374 20231124082627_0Imnd US001T 2024-01-06T00:04:41.258Z 2024-01-06T00:04:41.258Z
3469259 3469259 20231124080347_xJC66 US001T 2024-01-06T00:04:41.247Z 2024-01-06T00:04:41.247Z
3448759 3448759 20231121054514_wt7Kv US001T 2024-01-06T00:04:35.356Z 2024-01-06T00:04:35.356Z
3448493 3448493 20231121042742_zs72O US001T 2024-01-06T00:04:35.319Z 2024-01-06T00:04:35.319Z
3441703 3441703 20231120080548_0woi9 US001T 2024-01-06T00:04:33.352Z 2024-01-06T00:04:33.352Z
3441387 3441387 20231120055616_9tpXF US001T 2024-01-06T00:04:33.309Z 2024-01-06T00:04:33.309Z
3343801 3343801 20231108083102_FDUit US001T 2024-01-06T00:04:05.777Z 2024-01-06T00:04:05.777Z
3343768 3343768 20231108082444_Hhk4K US001T 2024-01-06T00:04:05.766Z 2024-01-06T00:04:05.766Z
3315605 3315605 20231105105220_M3csS US001T 2024-01-06T00:03:53.007Z 2024-01-06T00:03:53.007Z
3315523 3315523 20231105103614_buNty US001T 2024-01-06T00:03:52.973Z 2024-01-06T00:03:52.973Z
3292072 3292072 20231031082200_joVc1 US001T 2024-01-06T00:03:36.773Z 2024-01-06T00:03:36.773Z
3291990 3291990 20231031080158_7iMK6 US001T 2024-01-06T00:03:36.765Z 2024-01-06T00:03:36.765Z

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