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

7,552 rows where station_code = "FR0013" 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
9262884 9262884 20260126041709_abNhU FR0013 2026-01-27T14:15:58.662Z 2026-01-29T14:38:58.677Z
9260426 9260426 20260125042106_LbMnY FR0013 2026-01-26T14:21:46.525Z 2026-01-29T14:44:12.019Z
9260320 9260320 20260125033847_n07ag FR0013 2026-01-26T14:21:16.456Z 2026-01-29T14:44:05.512Z
9260281 9260281 20260125032416_yYuPi FR0013 2026-01-26T14:21:02.262Z 2026-01-29T14:44:03.639Z
9260240 9260240 20260125031331_6vB1v FR0013 2026-01-26T14:20:54.826Z 2026-01-29T14:44:01.613Z
9260094 9260094 20260125023217_rWCGg FR0013 2026-01-26T14:20:15.312Z 2026-01-29T14:43:46.258Z
9260089 9260089 20260125023157_x7P5N FR0013 2026-01-26T14:20:14.182Z 2026-01-29T14:43:45.971Z
9260084 9260084 20260125023025_TsBgS FR0013 2026-01-26T14:20:12.434Z 2026-01-29T14:43:45.751Z
9260068 9260068 20260125022110_VHKzU FR0013 2026-01-26T14:20:08.957Z 2026-01-29T14:43:44.800Z
9259994 9259994 20260125015027_omSt3 FR0013 2026-01-26T14:19:42.990Z 2026-01-29T14:43:39.938Z
9259973 9259973 20260125013720_qk2dc FR0013 2026-01-26T14:19:37.268Z 2026-01-29T14:43:38.135Z
9259952 9259952 20260125012347_7nlPn FR0013 2026-01-26T14:19:31.921Z 2026-01-29T14:43:36.690Z
9259881 9259881 20260125005807_n0XUx FR0013 2026-01-26T14:19:09.013Z 2026-01-29T14:43:33.038Z
9259742 9259742 20260124234909_LiRZ2 FR0013 2026-01-26T14:18:20.673Z 2026-01-29T14:43:16.547Z
9259674 9259674 20260124230704_0wDeK FR0013 2026-01-26T14:18:03.572Z 2026-01-29T14:43:12.499Z
9256209 9256209 20260124062024_a25Qt FR0013 2026-01-25T14:16:13.124Z 2026-01-29T14:48:28.845Z
9256201 9256201 20260124061735_2yBgU FR0013 2026-01-25T14:16:11.323Z 2026-01-29T14:48:28.207Z
9256143 9256143 20260124060302_cm8wo FR0013 2026-01-25T14:16:02.415Z 2026-01-29T14:48:25.688Z
9255784 9255784 20260124045544_Q94Lv FR0013 2026-01-25T14:14:41.888Z 2026-01-29T14:47:57.272Z
9255763 9255763 20260124044947_3BH2V FR0013 2026-01-25T14:14:36.802Z 2026-01-29T14:47:56.073Z
9255757 9255757 20260124044752_Buzyi FR0013 2026-01-25T14:14:34.996Z 2026-01-29T14:47:55.612Z
9255750 9255750 20260124044407_mtIOV FR0013 2026-01-25T14:14:33.025Z 2026-01-29T14:47:55.054Z
9255602 9255602 20260124041907_ONViK FR0013 2026-01-25T14:14:05.332Z 2026-01-29T14:47:42.461Z
9255600 9255600 20260124041820_QnKDN FR0013 2026-01-25T14:14:04.742Z 2026-01-29T14:47:42.316Z
9255592 9255592 20260124041724_vMAfd FR0013 2026-01-25T14:14:03.577Z 2026-01-29T14:47:41.843Z
9255590 9255590 20260124041713_66C2u FR0013 2026-01-25T14:14:02.913Z 2026-01-29T14:47:41.634Z
9255582 9255582 20260124041700_bbM6S FR0013 2026-01-25T14:14:01.909Z 2026-01-29T14:47:41.270Z
9255538 9255538 20260124040649_AVQ4I FR0013 2026-01-25T14:13:53.767Z 2026-01-29T14:47:38.950Z
9255453 9255453 20260124033748_wzUu2 FR0013 2026-01-25T14:13:29.989Z 2026-01-29T14:47:31.638Z
9255430 9255430 20260124032954_Qes2S FR0013 2026-01-25T14:13:25.103Z 2026-01-29T14:47:30.261Z
9255344 9255344 20260124025720_bJ5Cu FR0013 2026-01-25T14:12:59.810Z 2026-01-29T14:47:25.126Z
9255309 9255309 20260124024356_tgzb9 FR0013 2026-01-25T14:12:48.519Z 2026-01-29T14:47:22.903Z
9255306 9255306 20260124024327_xWwPT FR0013 2026-01-25T14:12:47.993Z 2026-01-29T14:47:22.745Z
9255259 9255259 20260124021239_F3MKv FR0013 2026-01-25T14:12:33.995Z 2026-01-29T14:47:12.675Z
9255255 9255255 20260124021145_48emz FR0013 2026-01-25T14:12:33.194Z 2026-01-29T14:47:12.451Z
9255143 9255143 20260124011831_CEMPO FR0013 2026-01-25T14:12:03.036Z 2026-01-29T14:47:04.745Z
9255134 9255134 20260124011131_GeAqo FR0013 2026-01-25T14:12:00.486Z 2026-01-29T14:47:04.117Z
9255115 9255115 20260124010039_FHh3q FR0013 2026-01-25T14:11:56.734Z 2026-01-29T14:47:03.195Z
9251852 9251852 20260122232620_z85Ck FR0013 2026-01-24T14:13:24.054Z 2026-01-29T14:52:13.235Z
9251781 9251781 20260122224013_Hu3U6 FR0013 2026-01-24T14:13:12.794Z 2026-01-29T14:52:09.519Z
9251723 9251723 20260122221257_wesDn FR0013 2026-01-24T14:13:00.428Z 2026-01-29T14:52:05.710Z
9249618 9249618 20260122060648_6RzqS FR0013 2026-01-23T14:15:48.266Z 2026-01-29T14:58:47.105Z
9249612 9249612 20260122060405_ByhPc FR0013 2026-01-23T14:15:47.267Z 2026-01-29T14:58:46.695Z
9249569 9249569 20260122055018_bf9qB FR0013 2026-01-23T14:15:43.417Z 2026-01-29T14:58:45.091Z
9249509 9249509 20260122053340_XhyDV FR0013 2026-01-23T14:15:36.901Z 2026-01-29T14:58:42.383Z
9249492 9249492 20260122053048_oQzdr FR0013 2026-01-23T14:15:35.603Z 2026-01-29T14:58:41.688Z
9249476 9249476 20260122052739_AZ3ht FR0013 2026-01-23T14:15:28.513Z 2026-01-29T14:58:40.969Z
9249376 9249376 20260122050418_fPqsX FR0013 2026-01-23T14:15:14.689Z 2026-01-29T14:58:27.765Z
9249320 9249320 20260122044550_B9Pjt FR0013 2026-01-23T14:15:09.952Z 2026-01-29T14:58:25.564Z
9248450 9248450 20260121234926_b2FF6 FR0013 2026-01-23T14:12:49.451Z 2026-01-29T14:57:19.520Z
9248429 9248429 20260121234256_hYHKZ FR0013 2026-01-23T14:12:46.440Z 2026-01-29T14:57:18.309Z
9248292 9248292 20260121224742_iHOnM FR0013 2026-01-23T14:12:24.999Z 2026-01-29T14:57:12.103Z
9248266 9248266 20260121224304_Bx0iP FR0013 2026-01-23T14:12:22.344Z 2026-01-29T14:57:11.029Z
9248199 9248199 20260121221400_Q8Q2X FR0013 2026-01-23T14:12:13.577Z 2026-01-29T14:57:08.255Z
9248184 9248184 20260121220541_1kIjN FR0013 2026-01-23T14:12:12.488Z 2026-01-29T14:57:07.621Z
9248179 9248179 20260121220258_BPoTC FR0013 2026-01-23T14:12:11.763Z 2026-01-29T14:57:07.320Z
9247970 9247970 20260121205338_HhVEv FR0013 2026-01-23T14:11:38.557Z 2026-01-29T14:56:46.516Z
9247928 9247928 20260121203504_kdid3 FR0013 2026-01-23T14:11:33.544Z 2026-01-29T14:56:44.221Z
9247487 9247487 20260121184531_OoSLI FR0013 2026-01-23T14:10:10.417Z 2026-01-29T14:56:11.257Z
9244773 9244773 20260119181123_NJ2UW FR0013 2026-01-22T14:30:44.036Z 2026-01-28T14:56:45.020Z
9224669 9224669 20260118053601_ly224 FR0013 2026-01-19T14:25:25.882Z 2026-01-26T15:03:44.960Z
9224354 9224354 20260118042538_9PFnk FR0013 2026-01-19T14:24:03.243Z 2026-01-26T15:03:15.380Z
9224127 9224127 20260118033010_BQZyH FR0013 2026-01-19T14:23:00.571Z 2026-01-26T15:03:05.807Z
9223905 9223905 20260118024735_q2ReI FR0013 2026-01-19T14:21:46.863Z 2026-01-26T15:02:40.992Z
9223901 9223901 20260118024635_w642H FR0013 2026-01-19T14:21:45.785Z 2026-01-26T15:02:40.835Z
9223663 9223663 20260118015851_sHK4m FR0013 2026-01-19T14:20:33.793Z 2026-01-26T15:02:31.399Z
9223618 9223618 20260118014614_kc0ss FR0013 2026-01-19T14:20:12.374Z 2026-01-26T15:02:29.631Z
9222813 9222813 20260117205635_WBwyw FR0013 2026-01-19T14:16:20.344Z 2026-01-26T15:01:22.044Z
9207646 9207646 20260115023913_aeF30 FR0013 2026-01-16T14:09:32.205Z 2026-01-22T15:03:29.081Z
9150483 9150483 20260105022304_OtmoG FR0013 2026-01-06T14:10:12.528Z 2026-01-13T15:13:35.278Z
9150417 9150417 20260105020916_2dy8d FR0013 2026-01-06T14:09:56.210Z 2026-01-13T15:13:31.482Z
9150401 9150401 20260105020507_piQNW FR0013 2026-01-06T14:09:52.285Z 2026-01-13T15:13:23.316Z
9150164 9150164 20260105011705_dDXu8 FR0013 2026-01-06T14:08:51.362Z 2026-01-13T15:13:08.758Z
9150129 9150129 20260105010705_3t1xT FR0013 2026-01-06T14:08:42.913Z 2026-01-13T15:13:06.320Z
9150067 9150067 20260105004940_oQvfX FR0013 2026-01-06T14:08:26.035Z 2026-01-13T15:13:01.808Z
9150026 9150026 20260105003351_a1aYk FR0013 2026-01-06T14:08:14.635Z 2026-01-13T15:12:52.098Z
9149878 9149878 20260105000119_3aIJU FR0013 2026-01-06T14:07:37.467Z 2026-01-13T15:12:43.827Z
9149772 9149772 20260104233123_WAOr9 FR0013 2026-01-06T14:07:06.286Z 2026-01-13T15:12:38.186Z
9149698 9149698 20260104230148_Ety2W FR0013 2026-01-06T14:06:41.821Z 2026-01-13T15:12:34.173Z
9149668 9149668 20260104225148_KFQlj FR0013 2026-01-06T14:06:35.352Z 2026-01-13T15:12:25.884Z
9149372 9149372 20260104202523_e6G7D FR0013 2026-01-06T14:05:09.286Z 2026-01-13T15:12:06.859Z
9149189 9149189 20260104191715_KX23l FR0013 2026-01-06T14:04:14.411Z 2026-01-13T15:11:47.645Z
9149049 9149049 20260104183554_WH2t2 FR0013 2026-01-06T14:03:36.041Z 2026-01-13T15:11:39.725Z
9148897 9148897 20260104175534_ULws1 FR0013 2026-01-06T14:02:55.776Z 2026-01-13T15:11:25.619Z
9148205 9148205 20260103173410_wm2pa FR0013 2026-01-05T14:30:20.997Z 2026-01-10T15:04:20.578Z
9148054 9148054 20260103172849_zkSEn FR0013 2026-01-05T14:30:15.379Z 2026-01-10T15:04:13.531Z
9143185 9143185 20260104015915_gcjP2 FR0013 2026-01-05T14:17:14.385Z 2026-01-12T15:06:16.800Z
9142649 9142649 20260104014257_W8g5y FR0013 2026-01-05T14:16:16.023Z 2026-01-12T15:05:48.600Z
9141065 9141065 20260104004207_egpHN FR0013 2026-01-05T14:14:08.549Z 2026-01-12T15:04:39.540Z
9133925 9133925 20260102171213_hB24g FR0013 2026-01-04T14:29:45.877Z 2026-01-09T14:50:59.308Z
9129877 9129877 20260103011634_7rvA1 FR0013 2026-01-04T14:06:58.293Z 2026-01-10T14:58:21.701Z
9129634 9129634 20260102233358_VaqXv FR0013 2026-01-04T14:05:10.466Z 2026-01-10T14:57:59.329Z
9119867 9119867 20251230192157_xJkwg FR0013 2026-01-01T14:57:32.548Z 2026-01-07T15:13:24.738Z
9119840 9119840 20251230191158_RbyrQ FR0013 2026-01-01T14:57:25.023Z 2026-01-07T15:13:22.806Z
9119682 9119682 20251230183918_BhZLZ FR0013 2026-01-01T14:56:48.537Z 2026-01-07T15:13:01.012Z
9119666 9119666 20251230183714_Ap8eE FR0013 2026-01-01T14:56:46.773Z 2026-01-07T15:13:00.223Z
9119611 9119611 20251230182722_2RdZj FR0013 2026-01-01T14:56:40.198Z 2026-01-07T15:12:56.441Z
9119364 9119364 20251230174122_tEbo8 FR0013 2026-01-01T14:55:57.002Z 2026-01-07T15:12:28.992Z
9119344 9119344 20251230173932_emoon FR0013 2026-01-01T14:55:47.925Z 2026-01-07T15:12:27.942Z
9119252 9119252 20251230171312_EX2X5 FR0013 2026-01-01T14:55:28.495Z 2026-01-01T14:58:01.619Z

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