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

1,824 rows where station_code = "DE0015" 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
8683655 8683655 20251130005714_o9iwK DE0015 2025-12-04T14:40:19.109Z 2025-12-04T14:40:19.109Z
8656092 8656092 20251130043642_S414j DE0015 2025-12-01T14:28:02.795Z 2025-12-04T14:42:52.982Z
8656006 8656006 20251130042958_M4Amg DE0015 2025-12-01T14:27:55.924Z 2025-12-04T14:42:51.413Z
8655371 8655371 20251130035842_3f3mI DE0015 2025-12-01T14:26:51.513Z 2025-12-01T14:26:51.513Z
8655253 8655253 20251130035107_Usxkr DE0015 2025-12-01T14:26:41.714Z 2025-12-04T14:42:23.841Z
8655161 8655161 20251130034640_dPheK DE0015 2025-12-01T14:26:36.661Z 2025-12-04T14:42:21.903Z
8654753 8654753 20251130033149_3hBek DE0015 2025-12-01T14:25:58.309Z 2025-12-04T14:42:12.675Z
8654493 8654493 20251130031826_C2oQG DE0015 2025-12-01T14:25:29.745Z 2025-12-01T14:25:29.745Z
8654111 8654111 20251130025933_SVGtH DE0015 2025-12-01T14:24:52.500Z 2025-12-04T14:41:44.498Z
8653767 8653767 20251130023919_LBdQp DE0015 2025-12-01T14:24:12.864Z 2025-12-04T14:41:34.412Z
8653212 8653212 20251130020316_qm2bq DE0015 2025-12-01T14:23:05.160Z 2025-12-04T14:41:03.930Z
8652520 8652520 20251130011442_vsiUc DE0015 2025-12-01T14:21:37.896Z 2025-12-04T14:40:43.673Z
8652431 8652431 20251130010843_apht1 DE0015 2025-12-01T14:21:23.187Z 2025-12-04T14:40:41.174Z
8652422 8652422 20251130010829_tY1Y2 DE0015 2025-12-01T14:21:22.567Z 2025-12-04T14:40:40.964Z
8652322 8652322 20251130010256_XzzmV DE0015 2025-12-01T14:21:16.148Z 2025-12-04T14:40:22.024Z
8652295 8652295 20251130010231_Z0lE0 DE0015 2025-12-01T14:21:14.523Z 2025-12-04T14:40:21.517Z
8652238 8652238 20251130005743_5BHPi DE0015 2025-12-01T14:20:59.119Z 2025-12-04T14:40:19.318Z
8652234 8652234 20251130005714_euG3A DE0015 2025-12-01T14:20:58.068Z 2025-12-02T14:37:56.952Z
8652018 8652018 20251130004130_XzadC DE0015 2025-12-01T14:20:29.136Z 2025-12-04T14:40:11.004Z
8652003 8652003 20251130004041_Vi47g DE0015 2025-12-01T14:20:27.178Z 2025-12-04T14:40:10.637Z
8651978 8651978 20251130003910_KrMXx DE0015 2025-12-01T14:20:23.123Z 2025-12-04T14:40:10.044Z
8651956 8651956 20251130003727_iAQ62 DE0015 2025-12-01T14:20:19.669Z 2025-12-04T14:40:09.358Z
8651941 8651941 20251130003547_Ft3sV DE0015 2025-12-01T14:20:18.593Z 2025-12-04T14:40:09.113Z
8651735 8651735 20251130001517_SzNVj DE0015 2025-12-01T14:19:47.436Z 2025-12-04T14:40:03.163Z
8651689 8651689 20251130001050_VEWT1 DE0015 2025-12-01T14:19:41.545Z 2025-12-04T14:40:01.798Z
8651635 8651635 20251130000725_2s101 DE0015 2025-12-01T14:19:36.335Z 2025-12-04T14:40:00.353Z
8651619 8651619 20251130000249_YgZuh DE0015 2025-12-01T14:19:33.978Z 2025-12-04T14:39:59.956Z
8651448 8651448 20251129234404_IZ0Co DE0015 2025-12-01T14:19:08.454Z 2025-12-04T14:39:55.185Z
8651425 8651425 20251129234135_R74n2 DE0015 2025-12-01T14:19:02.310Z 2025-12-04T14:39:54.337Z
8651297 8651297 20251129232223_dSeBT DE0015 2025-12-01T14:18:42.130Z 2025-12-04T14:39:35.255Z
8651285 8651285 20251129232116_vYDai DE0015 2025-12-01T14:18:35.480Z 2025-12-04T14:39:34.989Z
8651274 8651274 20251129232030_bRNvU DE0015 2025-12-01T14:18:31.925Z 2025-12-04T14:39:34.642Z
8651214 8651214 20251129230731_Xul7y DE0015 2025-12-01T14:18:25.318Z 2025-12-04T14:39:30.798Z
8650750 8650750 20251129212124_RvGtz DE0015 2025-12-01T14:17:05.438Z 2025-12-04T14:39:17.022Z
8650679 8650679 20251129210620_l0Lp0 DE0015 2025-12-01T14:16:53.343Z 2025-12-04T14:39:14.952Z
8650651 8650651 20251129205927_wNiJ7 DE0015 2025-12-01T14:16:48.651Z 2025-12-04T14:39:14.075Z
8635828 8635828 20251128025241_sNzq2 DE0015 2025-11-29T14:24:13.028Z 2025-12-04T14:57:47.254Z
8635823 8635823 20251128025129_mFyEQ DE0015 2025-11-29T14:24:12.585Z 2025-12-04T14:57:47.195Z
8635365 8635365 20251128020726_dCYGz DE0015 2025-11-29T14:23:08.650Z 2025-12-04T14:56:57.141Z
8635339 8635339 20251128020452_Qks1r DE0015 2025-11-29T14:23:04.228Z 2025-12-04T14:56:56.601Z
8635059 8635059 20251128013822_Y2Hnx DE0015 2025-11-29T14:22:36.668Z 2025-12-04T14:56:48.865Z
8634669 8634669 20251128010848_pgndo DE0015 2025-11-29T14:21:54.284Z 2025-12-04T14:56:42.529Z
8634655 8634655 20251128010746_jJR3J DE0015 2025-11-29T14:21:52.049Z 2025-12-04T14:56:42.309Z
8634490 8634490 20251128005418_nswv6 DE0015 2025-11-29T14:21:24.747Z 2025-12-04T14:56:40.174Z
8634338 8634338 20251128004022_ohbF2 DE0015 2025-11-29T14:21:13.904Z 2025-12-04T14:56:38.028Z
8634044 8634044 20251128001721_6Vs3T DE0015 2025-11-29T14:20:39.741Z 2025-12-04T14:56:34.391Z
8633753 8633753 20251127235213_5PZeG DE0015 2025-11-29T14:20:15.808Z 2025-12-04T14:56:30.486Z
8633645 8633645 20251127234414_mLgHT DE0015 2025-11-29T14:20:01.982Z 2025-12-04T14:56:27.897Z
8459660 8459660 20251114042141_SgnUg DE0015 2025-11-15T14:20:14.172Z 2025-11-22T15:22:08.189Z
8459659 8459659 20251114042114_pc1ul DE0015 2025-11-15T14:20:14.011Z 2025-11-22T15:22:08.052Z
8459628 8459628 20251114041544_gRFEC DE0015 2025-11-15T14:20:09.055Z 2025-11-22T15:22:07.335Z
8459135 8459135 20251114025531_LIUw0 DE0015 2025-11-15T14:18:56.325Z 2025-11-22T15:21:39.198Z
8458913 8458913 20251114021115_hJLvZ DE0015 2025-11-15T14:18:15.407Z 2025-11-22T15:21:27.745Z
8458905 8458905 20251114020740_QCol9 DE0015 2025-11-15T14:18:14.314Z 2025-11-22T15:21:27.238Z
8458897 8458897 20251114020633_EjOhq DE0015 2025-11-15T14:18:13.199Z 2025-11-22T15:21:27.052Z
8458866 8458866 20251114020315_Oxb2I DE0015 2025-11-15T14:18:08.375Z 2025-11-22T15:21:24.506Z
8458785 8458785 20251114014507_2rKqV DE0015 2025-11-15T14:17:48.166Z 2025-11-22T15:21:22.112Z
8458757 8458757 20251114013901_zh6zs DE0015 2025-11-15T14:17:44.412Z 2025-11-22T15:21:21.476Z
8458735 8458735 20251114013245_wGeyd DE0015 2025-11-15T14:17:41.652Z 2025-11-22T15:21:20.870Z
8458689 8458689 20251114011137_1Vnar DE0015 2025-11-15T14:17:34.630Z 2025-11-22T15:21:18.376Z
8458656 8458656 20251114010516_3Lqde DE0015 2025-11-15T14:17:30.463Z 2025-11-22T15:21:16.672Z
8458636 8458636 20251114010122_gIu2a DE0015 2025-11-15T14:17:27.615Z 2025-11-22T15:21:16.408Z
8458625 8458625 20251114005845_2scJz DE0015 2025-11-15T14:17:26.608Z 2025-11-22T15:21:16.354Z
8458535 8458535 20251114003451_bVLmk DE0015 2025-11-15T14:17:05.377Z 2025-11-22T15:21:10.034Z
8458479 8458479 20251114002009_eBNFg DE0015 2025-11-15T14:16:56.074Z 2025-11-22T15:21:05.060Z
8458471 8458471 20251114001918_NEMcU DE0015 2025-11-15T14:16:53.993Z 2025-11-22T15:21:04.523Z
8458469 8458469 20251114001914_jGx4l DE0015 2025-11-15T14:16:53.769Z 2025-11-22T15:21:04.420Z
8449451 8449451 20251113020949_vmQqD DE0015 2025-11-14T14:20:26.625Z 2025-11-21T15:12:03.387Z
8441778 8441778 20251112004135_PC4kK DE0015 2025-11-13T14:31:47.634Z 2025-11-20T15:23:53.369Z
8439606 8439606 20251112041236_pD1qd DE0015 2025-11-13T14:26:49.755Z 2025-11-20T15:25:29.064Z
8439033 8439033 20251112030443_iS7J2 DE0015 2025-11-13T14:25:24.065Z 2025-11-20T15:24:56.854Z
8439024 8439024 20251112030359_jMQQH DE0015 2025-11-13T14:25:23.764Z 2025-11-20T15:24:56.551Z
8438928 8438928 20251112025237_2O2vL DE0015 2025-11-13T14:25:10.109Z 2025-11-20T15:24:52.249Z
8438789 8438789 20251112023959_f3BfF DE0015 2025-11-13T14:24:43.390Z 2025-11-20T15:24:47.959Z
8438741 8438741 20251112023156_31KT3 DE0015 2025-11-13T14:24:34.447Z 2025-11-20T15:24:46.427Z
8438677 8438677 20251112022627_xPPkD DE0015 2025-11-13T14:24:29.232Z 2025-11-20T15:24:45.197Z
8438663 8438663 20251112022424_hPQPb DE0015 2025-11-13T14:24:27.982Z 2025-11-20T15:24:45.066Z
8438648 8438648 20251112022335_IKXLw DE0015 2025-11-13T14:24:26.017Z 2025-11-20T15:24:44.848Z
8438623 8438623 20251112021912_bIvNZ DE0015 2025-11-13T14:24:21.939Z 2025-11-20T15:24:43.159Z
8438591 8438591 20251112021718_WSvMc DE0015 2025-11-13T14:24:18.572Z 2025-11-20T15:24:41.968Z
8438515 8438515 20251112020815_N2Z6R DE0015 2025-11-13T14:23:57.698Z 2025-11-20T15:24:38.290Z
8438499 8438499 20251112020645_j62tC DE0015 2025-11-13T14:23:54.602Z 2025-11-20T15:24:37.423Z
8438432 8438432 20251112015753_LfnSJ DE0015 2025-11-13T14:23:46.935Z 2025-11-20T15:24:34.962Z
8438412 8438412 20251112015340_eBAxq DE0015 2025-11-13T14:23:44.328Z 2025-11-20T15:24:33.032Z
8438325 8438325 20251112014432_i1Q7T DE0015 2025-11-13T14:23:34.004Z 2025-11-20T15:24:25.248Z
8438181 8438181 20251112013431_GRKYf DE0015 2025-11-13T14:23:01.821Z 2025-11-20T15:24:17.505Z
8438081 8438081 20251112012009_IOo6g DE0015 2025-11-13T14:22:51.716Z 2025-11-20T15:24:13.393Z
8438061 8438061 20251112011719_j2aKB DE0015 2025-11-13T14:22:49.996Z 2025-11-20T15:24:13.063Z
8437991 8437991 20251112010824_dnTu2 DE0015 2025-11-13T14:22:29.447Z 2025-11-20T15:24:05.313Z
8437963 8437963 20251112010333_MJago DE0015 2025-11-13T14:22:22.487Z 2025-11-20T15:24:02.205Z
8437784 8437784 20251112004441_zB1su DE0015 2025-11-13T14:22:05.545Z 2025-11-20T15:23:53.613Z
8437781 8437781 20251112004433_V6cO3 DE0015 2025-11-13T14:22:05.311Z 2025-11-20T15:23:53.592Z
8437754 8437754 20251112004132_rf7cu DE0015 2025-11-13T14:21:52.844Z 2025-11-20T15:23:52.823Z
8437657 8437657 20251112003213_TKoYy DE0015 2025-11-13T14:21:45.616Z 2025-11-20T15:23:49.859Z
8437651 8437651 20251112003154_EdDL9 DE0015 2025-11-13T14:21:45.259Z 2025-11-20T15:23:49.793Z
8437624 8437624 20251112003001_VD2mr DE0015 2025-11-13T14:21:43.162Z 2025-11-20T15:23:49.087Z
8437580 8437580 20251112002029_7fBCN DE0015 2025-11-13T14:21:23.881Z 2025-11-20T15:23:44.306Z
8437573 8437573 20251112001945_E657K DE0015 2025-11-13T14:21:23.238Z 2025-11-20T15:23:44.030Z
8437569 8437569 20251112001917_3mZzr DE0015 2025-11-13T14:21:22.729Z 2025-11-20T15:23:44.018Z
8437132 8437132 20251111232631_fk4hg DE0015 2025-11-13T14:20:15.918Z 2025-11-20T15:23:15.344Z

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