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

3,144 rows where station_code = "ES0009" 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
8666530 8666530 20251201060823_Np9h9 ES0009 2025-12-02T14:26:23.937Z 2025-12-06T14:42:34.118Z
8664684 8664684 20251201012443_b94X9 ES0009 2025-12-02T14:21:47.646Z 2025-12-06T14:40:54.654Z
8664002 8664002 20251130225902_WkEKX ES0009 2025-12-02T14:19:47.466Z 2025-12-06T14:40:19.351Z
8663851 8663851 20251130222010_GNSVF ES0009 2025-12-02T14:19:25.626Z 2025-12-06T14:40:13.054Z
8647896 8647896 20251129055622_Rad2B ES0009 2025-11-30T14:29:21.762Z 2025-12-06T14:56:55.035Z
8646945 8646945 20251129031706_VBWB9 ES0009 2025-11-30T14:27:09.725Z 2025-12-06T14:56:28.404Z
8646923 8646923 20251129031233_kIRYK ES0009 2025-11-30T14:27:08.364Z 2025-12-06T14:56:28.028Z
8637264 8637264 20251128052215_zyJdF ES0009 2025-11-29T14:27:02.098Z 2025-12-06T15:03:58.332Z
8637008 8637008 20251128044823_I1JiB ES0009 2025-11-29T14:26:32.051Z 2025-12-06T15:03:55.470Z
8636888 8636888 20251128043355_HfBwe ES0009 2025-11-29T14:26:18.928Z 2025-12-06T15:03:47.976Z
8635800 8635800 20251128024856_Aismw ES0009 2025-11-29T14:24:10.421Z 2025-12-06T15:02:51.576Z
8635394 8635394 20251128020903_fiI32 ES0009 2025-11-29T14:23:20.136Z 2025-12-06T15:02:43.968Z
8602527 8602527 20251125050111_26dPa ES0009 2025-11-26T14:26:05.417Z 2025-12-02T15:09:31.344Z
8574328 8574328 20251122055036_3MLmy ES0009 2025-11-23T14:43:06.457Z 2025-11-30T15:07:04.938Z
8573986 8573986 20251122045513_jB38F ES0009 2025-11-23T14:42:10.685Z 2025-11-30T15:06:54.843Z
8573950 8573950 20251122044753_weaqB ES0009 2025-11-23T14:42:08.538Z 2025-11-23T14:42:08.538Z
8572403 8572403 20251122003716_25iUL ES0009 2025-11-23T14:39:09.431Z 2025-11-30T15:05:49.035Z
8559437 8559437 20251121041051_LQFuV ES0009 2025-11-22T14:41:55.636Z 2025-11-29T14:54:38.512Z
8558068 8558068 20251121031356_00VfZ ES0009 2025-11-22T14:40:58.056Z 2025-11-29T14:54:35.258Z
8557829 8557829 20251121030526_QP7A1 ES0009 2025-11-22T14:40:49.949Z 2025-11-29T14:54:34.764Z
8523769 8523769 20251119024144_P2mNx ES0009 2025-11-20T14:19:17.339Z 2025-11-27T15:12:27.351Z
8520844 8520844 20251118200906_xOxD5 ES0009 2025-11-20T14:11:07.690Z 2025-11-27T15:11:35.845Z
8427851 8427851 20251111051833_ZxrWp ES0009 2025-11-12T14:29:14.694Z 2025-11-19T15:18:06.484Z
8427162 8427162 20251111041202_eyoiB ES0009 2025-11-12T14:27:20.338Z 2025-11-19T15:17:45.756Z
8426777 8426777 20251111034241_jIKmz ES0009 2025-11-12T14:26:22.232Z 2025-11-19T15:17:26.164Z
8426677 8426677 20251111033155_QJNRk ES0009 2025-11-12T14:26:00.165Z 2025-11-19T15:17:24.431Z
8414567 8414567 20251110031000_rWKM7 ES0009 2025-11-11T14:21:05.161Z 2025-11-18T15:21:09.230Z
8414049 8414049 20251110013200_jOERl ES0009 2025-11-11T14:19:22.818Z 2025-11-18T15:20:37.107Z
8413661 8413661 20251110001345_9ZfX3 ES0009 2025-11-11T14:18:03.158Z 2025-11-18T15:20:23.242Z
8413608 8413608 20251110000336_Goto5 ES0009 2025-11-11T14:17:56.587Z 2025-11-18T15:20:22.927Z
8406230 8406230 20251109054205_7buso ES0009 2025-11-10T14:16:16.131Z 2025-11-17T14:59:09.912Z
8404015 8404015 20251109005219_AP9zs ES0009 2025-11-10T14:10:35.415Z 2025-11-17T14:58:40.999Z
8403695 8403695 20251109000016_gepgw ES0009 2025-11-10T14:09:41.798Z 2025-11-17T14:58:38.189Z
8403431 8403431 20251108232150_cyAQV ES0009 2025-11-10T14:09:03.795Z 2025-11-17T14:58:35.726Z
8374782 8374782 20251103045417_zs9h8 ES0009 2025-11-05T14:33:12.032Z 2025-11-11T15:08:07.308Z
8374679 8374679 20251103043124_Y4aEA ES0009 2025-11-05T14:32:52.409Z 2025-11-11T15:08:04.605Z
8374053 8374053 20251103023726_jcn3Z ES0009 2025-11-05T14:30:45.763Z 2025-11-11T15:06:49.085Z
8373625 8373625 20251102230641_xKs3C ES0009 2025-11-05T14:28:17.804Z 2025-11-11T15:06:13.212Z
8284979 8284979 20251028052933_bN1hM ES0009 2025-10-29T12:46:50.015Z 2025-11-05T15:22:59.650Z
8284171 8284171 20251028042428_HsrzF ES0009 2025-10-29T12:45:21.117Z 2025-11-05T15:22:41.825Z
8284057 8284057 20251028041855_vMbjB ES0009 2025-10-29T12:45:17.598Z 2025-11-05T15:22:39.641Z
8283624 8283624 20251028035138_Q1egn ES0009 2025-10-29T12:45:00.519Z 2025-11-05T15:22:25.617Z
8282881 8282881 20251028025449_k92wk ES0009 2025-10-29T12:43:31.781Z 2025-11-05T15:21:52.383Z
8282561 8282561 20251028023103_qXxLj ES0009 2025-10-29T12:43:19.353Z 2025-11-05T15:21:44.404Z
8282471 8282471 20251028022650_gzySr ES0009 2025-10-29T12:43:07.130Z 2025-11-05T15:21:43.612Z
8281085 8281085 20251028005157_lqaEU ES0009 2025-10-29T12:40:30.112Z 2025-11-05T15:21:17.958Z
8281029 8281029 20251028004259_dViI3 ES0009 2025-10-29T12:40:24.314Z 2025-11-05T15:21:17.327Z
8280960 8280960 20251028003459_yx1h4 ES0009 2025-10-29T12:40:20.697Z 2025-11-05T15:21:15.964Z
8280811 8280811 20251028001842_sBQI6 ES0009 2025-10-29T12:40:12.758Z 2025-11-05T15:21:13.785Z
8280807 8280807 20251028001821_HiSSz ES0009 2025-10-29T12:40:12.506Z 2025-11-05T15:21:13.716Z
8280687 8280687 20251028000045_4SASZ ES0009 2025-10-29T12:40:04.895Z 2025-11-05T15:21:10.630Z
8280427 8280427 20251027233412_E19oi ES0009 2025-10-29T12:39:16.418Z 2025-11-05T15:21:03.922Z
8279739 8279739 20251027221018_8r4Rv ES0009 2025-10-29T12:38:02.314Z 2025-11-05T15:20:48.753Z
8279473 8279473 20251027212515_KeH6t ES0009 2025-10-29T12:36:56.073Z 2025-11-05T15:20:41.913Z
8279068 8279068 20251027192708_lrQ3F ES0009 2025-10-29T12:35:30.633Z 2025-11-05T15:20:07.863Z
8274903 8274903 20251027053937_QfWuY ES0009 2025-10-29T12:26:41.776Z 2025-11-04T15:45:51.103Z
8274471 8274471 20251027051509_zmoiz ES0009 2025-10-29T12:25:33.423Z 2025-11-04T15:45:16.329Z
8273538 8273538 20251027042807_if5sJ ES0009 2025-10-29T12:24:15.086Z 2025-11-04T15:44:58.352Z
8254665 8254665 20251027041254_aHdWy ES0009 2025-10-28T12:20:13.760Z 2025-11-04T15:44:52.657Z
8254008 8254008 20251027033916_05SYp ES0009 2025-10-28T12:19:11.315Z 2025-11-04T15:44:17.060Z
8253732 8253732 20251027031924_yXPm6 ES0009 2025-10-28T12:18:38.145Z 2025-11-04T15:44:10.624Z
8252839 8252839 20251027015442_6XuHI ES0009 2025-10-28T12:16:18.537Z 2025-11-04T15:43:15.598Z
8252776 8252776 20251027014639_nNMMQ ES0009 2025-10-28T12:16:01.822Z 2025-11-04T15:42:58.256Z
8252645 8252645 20251027012128_cyYMn ES0009 2025-10-28T12:15:41.748Z 2025-11-04T15:42:51.288Z
8251796 8251796 20251026231127_0tkyg ES0009 2025-10-28T12:12:55.916Z 2025-11-04T15:41:58.615Z
8251564 8251564 20251026215205_XC30l ES0009 2025-10-28T12:12:01.896Z 2025-11-04T15:41:46.876Z
8251494 8251494 20251026212709_HmPI5 ES0009 2025-10-28T12:11:41.017Z 2025-11-04T15:41:44.080Z
8251437 8251437 20251026205035_OYE4R ES0009 2025-10-28T12:11:29.549Z 2025-11-04T15:41:41.984Z
8240331 8240331 20251025012722_LSNwr ES0009 2025-10-27T12:31:25.882Z 2025-11-02T15:05:27.561Z
8239556 8239556 20251025004018_863lS ES0009 2025-10-27T12:30:25.076Z 2025-11-02T15:05:24.792Z
8146636 8146636 20251019035017_kn7oH ES0009 2025-10-20T12:22:56.959Z 2025-10-27T13:10:43.489Z
8145737 8145737 20251019024033_F79xR ES0009 2025-10-20T12:20:40.487Z 2025-10-27T13:10:30.254Z
8143913 8143913 20251019001904_RXEl2 ES0009 2025-10-20T12:15:45.144Z 2025-10-27T13:10:09.427Z
8142116 8142116 20251018204613_QanAG ES0009 2025-10-20T12:09:57.678Z 2025-10-27T13:09:49.859Z
8123547 8123547 20251017034747_lYxtO ES0009 2025-10-18T12:26:54.991Z 2025-10-25T13:29:09.728Z
8121786 8121786 20251017003222_kk8zJ ES0009 2025-10-18T12:21:29.753Z 2025-10-25T13:27:56.841Z
8121519 8121519 20251017000021_GS5y6 ES0009 2025-10-18T12:20:41.412Z 2025-10-25T13:27:39.558Z
8113140 8113140 20251016042221_hH2jl ES0009 2025-10-17T12:14:18.310Z 2025-10-24T13:16:50.830Z
8113054 8113054 20251016041554_JjBKm ES0009 2025-10-17T12:14:13.098Z 2025-10-24T13:16:50.484Z
8111625 8111625 20251016013511_Q3YVt ES0009 2025-10-17T12:10:40.813Z 2025-10-24T13:16:24.197Z
8110885 8110885 20251015234548_Otedo ES0009 2025-10-17T12:08:45.763Z 2025-10-24T13:16:07.966Z
8109836 8109836 20251015191937_1IamX ES0009 2025-10-17T12:06:05.801Z 2025-10-24T13:15:39.375Z
8109771 8109771 20251015190630_0So7U ES0009 2025-10-17T12:06:00.092Z 2025-10-24T13:15:35.431Z
8105341 8105341 20251015042912_4YxCh ES0009 2025-10-16T12:19:03.645Z 2025-10-23T13:09:02.795Z
8104609 8104609 20251015022836_BfL52 ES0009 2025-10-16T12:16:43.406Z 2025-10-23T13:08:51.399Z
8104555 8104555 20251015021535_bu9xQ ES0009 2025-10-16T12:16:23.900Z 2025-10-23T13:08:50.197Z
8103715 8103715 20251014233204_DePtG ES0009 2025-10-16T12:13:16.749Z 2025-10-23T13:08:28.837Z
8102992 8102992 20251014200455_p5S2K ES0009 2025-10-16T12:10:19.479Z 2025-10-23T13:08:15.294Z
8099141 8099141 20251014031404_j1D9j ES0009 2025-10-15T12:18:06.235Z 2025-10-22T13:10:04.003Z
8098931 8098931 20251014023909_73FET ES0009 2025-10-15T12:17:30.540Z 2025-10-22T13:10:02.098Z
8098885 8098885 20251014023147_2PtMl ES0009 2025-10-15T12:17:23.558Z 2025-10-22T13:10:01.716Z
8091388 8091388 20251012201002_U4xNB ES0009 2025-10-14T12:07:45.409Z 2025-10-21T13:08:59.685Z
8091099 8091099 20251012185947_ZO9HW ES0009 2025-10-14T12:06:59.574Z 2025-10-21T13:08:49.603Z
8079210 8079210 20251010041846_qgzIl ES0009 2025-10-11T12:11:22.725Z 2025-10-18T13:00:16.452Z
8078251 8078251 20251010001512_kE95B ES0009 2025-10-11T12:07:56.129Z 2025-10-18T12:59:57.662Z
8072103 8072103 20251007220309_tNyRw ES0009 2025-10-09T12:03:26.351Z 2025-10-16T12:48:08.904Z
8068140 8068140 20251003023649_oonn9 ES0009 2025-10-07T12:45:06.778Z 2025-10-11T12:42:05.400Z
8067315 8067315 20251005045111_mI1SP ES0009 2025-10-07T12:34:07.575Z 2025-10-13T12:34:11.228Z
8066244 8066244 20251005031735_FCybK ES0009 2025-10-07T12:32:47.510Z 2025-10-13T12:33:56.709Z
8065980 8065980 20251005025152_73DqH ES0009 2025-10-07T12:32:08.150Z 2025-10-13T12:33:54.103Z

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