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

2,952 rows where station_code = "DE000Y" 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
8675927 8675927 20251202052313_ustN0 DE000Y 2025-12-03T14:24:30.957Z 2025-12-06T14:35:04.885Z
8675728 8675728 20251202051126_QbyjR DE000Y 2025-12-03T14:24:12.753Z 2025-12-06T14:34:59.320Z
8674765 8674765 20251202032048_hFIMO DE000Y 2025-12-03T14:22:19.127Z 2025-12-06T14:34:18.186Z
8673756 8673756 20251201223634_0znD3 DE000Y 2025-12-03T14:19:58.386Z 2025-12-06T14:33:32.067Z
8673531 8673531 20251201195519_DyxTi DE000Y 2025-12-03T14:19:08.599Z 2025-12-06T14:33:21.742Z
8673391 8673391 20251201185447_6JqRG DE000Y 2025-12-03T14:18:41.971Z 2025-12-06T14:33:06.520Z
8673288 8673288 20251201180920_GUgPB DE000Y 2025-12-03T14:18:11.993Z 2025-12-06T14:32:56.719Z
8666386 8666386 20251201053110_f2BUJ DE000Y 2025-12-02T14:25:55.685Z 2025-12-06T14:42:20.627Z
8666296 8666296 20251201050942_u4im3 DE000Y 2025-12-02T14:25:43.665Z 2025-12-06T14:42:16.679Z
8666101 8666101 20251201043714_ZMGjl DE000Y 2025-12-02T14:25:14.270Z 2025-12-06T14:42:11.644Z
8666035 8666035 20251201042603_3u2vF DE000Y 2025-12-02T14:25:07.307Z 2025-12-06T14:42:10.105Z
8665921 8665921 20251201041114_g9jCE DE000Y 2025-12-02T14:24:55.748Z 2025-12-06T14:42:07.099Z
8665372 8665372 20251201031317_i2KeH DE000Y 2025-12-02T14:23:35.876Z 2025-12-06T14:41:36.253Z
8665236 8665236 20251201025016_gKeJQ DE000Y 2025-12-02T14:23:11.463Z 2025-12-06T14:41:30.326Z
8665231 8665231 20251201025013_29X3H DE000Y 2025-12-02T14:23:11.097Z 2025-12-06T14:41:30.243Z
8665191 8665191 20251201024616_sQogP DE000Y 2025-12-02T14:23:06.527Z 2025-12-06T14:41:29.074Z
8665091 8665091 20251201022717_pj2Nj DE000Y 2025-12-02T14:22:54.795Z 2025-12-06T14:41:25.868Z
8665020 8665020 20251201021733_ohzpI DE000Y 2025-12-02T14:22:37.623Z 2025-12-06T14:41:06.827Z
8664895 8664895 20251201020005_IQli6 DE000Y 2025-12-02T14:22:24.046Z 2025-12-06T14:41:02.299Z
8664794 8664794 20251201013817_12MW4 DE000Y 2025-12-02T14:22:05.447Z 2025-12-06T14:40:57.784Z
8664430 8664430 20251201002626_H3nHa DE000Y 2025-12-02T14:21:03.910Z 2025-12-06T14:40:46.621Z
8664140 8664140 20251130232517_m6E1s DE000Y 2025-12-02T14:20:09.626Z 2025-12-06T14:40:38.259Z
8664121 8664121 20251130231856_m93s5 DE000Y 2025-12-02T14:20:07.069Z 2025-12-06T14:40:36.107Z
8664035 8664035 20251130230927_kqpIa DE000Y 2025-12-02T14:19:59.175Z 2025-12-06T14:40:21.010Z
8664011 8664011 20251130230222_7J3QO DE000Y 2025-12-02T14:19:51.857Z 2025-12-06T14:40:19.707Z
8663983 8663983 20251130225348_FIeCR DE000Y 2025-12-02T14:19:45.164Z 2025-12-06T14:40:18.881Z
8663961 8663961 20251130225106_NyLS2 DE000Y 2025-12-02T14:19:41.966Z 2025-12-06T14:40:17.932Z
8612456 8612456 20251126023227_AUnTa DE000Y 2025-11-27T14:24:14.731Z 2025-12-04T15:09:30.897Z
8611874 8611874 20251126020443_1p1rt DE000Y 2025-11-27T14:23:00.673Z 2025-12-04T15:09:25.077Z
8611246 8611246 20251126013405_8X5cR DE000Y 2025-11-27T14:21:43.966Z 2025-12-04T15:09:02.365Z
8611179 8611179 20251126012802_bLmnj DE000Y 2025-11-27T14:21:35.663Z 2025-12-04T15:08:56.321Z
8608014 8608014 20251125214409_bASTV DE000Y 2025-11-27T14:15:05.764Z 2025-12-04T15:07:40.251Z
8607685 8607685 20251125211137_1OSR3 DE000Y 2025-11-27T14:14:12.337Z 2025-12-04T15:07:13.524Z
8587599 8587599 20251123222149_D2yf4 DE000Y 2025-11-25T14:15:37.875Z 2025-12-02T15:11:17.761Z
8587442 8587442 20251123220501_7J3M5 DE000Y 2025-11-25T14:15:20.893Z 2025-12-02T15:11:13.407Z
8587301 8587301 20251123214358_wIb2o DE000Y 2025-11-25T14:14:58.720Z 2025-12-02T15:11:10.905Z
8587169 8587169 20251123213246_XaBdY DE000Y 2025-11-25T14:14:47.522Z 2025-12-02T15:11:09.089Z
8586774 8586774 20251123205014_lMdPL DE000Y 2025-11-25T14:13:55.104Z 2025-12-02T15:11:02.887Z
8586747 8586747 20251123204446_BDID0 DE000Y 2025-11-25T14:13:44.845Z 2025-12-02T15:11:02.462Z
8586648 8586648 20251123202559_yUGLL DE000Y 2025-11-25T14:13:32.960Z 2025-12-02T15:10:56.742Z
8586054 8586054 20251123183714_rvzo0 DE000Y 2025-11-25T14:11:43.296Z 2025-12-02T15:10:40.027Z
8585768 8585768 20251123174201_9D1vM DE000Y 2025-11-25T14:10:48.581Z 2025-12-02T15:10:19.520Z
8580535 8580535 20251123044647_CmIGn DE000Y 2025-11-24T14:17:19.450Z 2025-12-01T15:22:19.028Z
8580392 8580392 20251123041008_dq2CJ DE000Y 2025-11-24T14:16:54.084Z 2025-12-01T15:22:16.337Z
8580325 8580325 20251123035102_LLkgb DE000Y 2025-11-24T14:16:45.735Z 2025-12-01T15:22:14.657Z
8580321 8580321 20251123034920_NHCVE DE000Y 2025-11-24T14:16:45.292Z 2025-12-01T15:22:14.585Z
8580279 8580279 20251123033553_WtjDZ DE000Y 2025-11-24T14:16:40.313Z 2025-12-01T15:22:11.593Z
8580253 8580253 20251123031830_kYWW1 DE000Y 2025-11-24T14:16:30.022Z 2025-12-01T15:22:04.214Z
8580248 8580248 20251123031631_zo3gO DE000Y 2025-11-24T14:16:29.430Z 2025-12-01T15:22:03.672Z
8580237 8580237 20251123031244_1609Y DE000Y 2025-11-24T14:16:28.058Z 2025-12-01T15:22:02.107Z
8580233 8580233 20251123031222_FYvy9 DE000Y 2025-11-24T14:16:27.342Z 2025-12-01T15:22:01.874Z
8580230 8580230 20251123031205_fY9T0 DE000Y 2025-11-24T14:16:26.950Z 2025-12-01T15:22:01.845Z
8580219 8580219 20251123030145_RZRqZ DE000Y 2025-11-24T14:16:23.792Z 2025-12-01T15:21:57.707Z
8580203 8580203 20251123025428_c6P6n DE000Y 2025-11-24T14:16:21.965Z 2025-12-01T15:21:52.943Z
8580160 8580160 20251123024329_J11uf DE000Y 2025-11-24T14:16:16.482Z 2025-12-01T15:21:44.495Z
8580084 8580084 20251123022805_3ZK7R DE000Y 2025-11-24T14:16:06.392Z 2025-12-01T15:21:37.531Z
8580035 8580035 20251123021830_3bYSv DE000Y 2025-11-24T14:15:53.874Z 2025-12-01T15:21:34.260Z
8580030 8580030 20251123021829_DhWRO DE000Y 2025-11-24T14:15:53.566Z 2025-12-01T15:21:34.242Z
8580000 8580000 20251123021336_PsjAR DE000Y 2025-11-24T14:15:48.243Z 2025-12-01T15:21:31.429Z
8579956 8579956 20251123020032_rcvFR DE000Y 2025-11-24T14:15:42.649Z 2025-12-01T15:21:24.936Z
8579952 8579952 20251123015932_dd4VE DE000Y 2025-11-24T14:15:42.049Z 2025-12-01T15:21:22.914Z
8579933 8579933 20251123015426_pjh6S DE000Y 2025-11-24T14:15:39.546Z 2025-12-01T15:21:20.214Z
8579887 8579887 20251123014141_RIu3Q DE000Y 2025-11-24T14:15:32.420Z 2025-12-01T15:21:15.046Z
8579816 8579816 20251123012316_Ewi1v DE000Y 2025-11-24T14:15:15.457Z 2025-12-01T15:21:10.906Z
8579788 8579788 20251123011559_uO3tZ DE000Y 2025-11-24T14:15:09.648Z 2025-12-01T15:21:08.159Z
8579750 8579750 20251123010547_qbDTC DE000Y 2025-11-24T14:15:05.446Z 2025-12-01T15:21:00.237Z
8579612 8579612 20251123002626_f8dxR DE000Y 2025-11-24T14:14:50.808Z 2025-12-01T15:20:48.169Z
8579574 8579574 20251123001605_mg87D DE000Y 2025-11-24T14:14:39.940Z 2025-12-01T15:20:43.443Z
8579572 8579572 20251123001558_MY9bt DE000Y 2025-11-24T14:14:39.601Z 2025-12-01T15:20:43.181Z
8579509 8579509 20251123000107_Ijksl DE000Y 2025-11-24T14:14:30.014Z 2025-12-01T15:20:34.754Z
8579424 8579424 20251122233758_UwcKv DE000Y 2025-11-24T14:14:19.924Z 2025-12-01T15:20:18.821Z
8579029 8579029 20251122220927_JTEPr DE000Y 2025-11-24T14:13:20.724Z 2025-12-01T15:19:58.822Z
8578970 8578970 20251122215934_SxttT DE000Y 2025-11-24T14:13:12.642Z 2025-12-01T15:19:57.549Z
8578853 8578853 20251122213934_u03DY DE000Y 2025-11-24T14:12:51.160Z 2025-12-01T15:19:53.952Z
8578807 8578807 20251122212901_EKTU6 DE000Y 2025-11-24T14:12:44.198Z 2025-12-01T15:19:53.167Z
8578684 8578684 20251122211456_UOPKZ DE000Y 2025-11-24T14:12:20.897Z 2025-12-01T15:19:49.792Z
8577573 8577573 20251122183242_VkOfg DE000Y 2025-11-24T14:09:04.743Z 2025-12-01T15:18:54.289Z
8577410 8577410 20251122180336_U21Nn DE000Y 2025-11-24T14:08:32.922Z 2025-12-01T15:18:49.052Z
8577311 8577311 20251122175347_9wpYI DE000Y 2025-11-24T14:08:20.908Z 2025-12-01T15:18:47.209Z
8568640 8568640 20251121052825_iR8E5 DE000Y 2025-11-23T14:31:17.248Z 2025-11-29T14:54:47.149Z
8568195 8568195 20251121050438_Me60b DE000Y 2025-11-23T14:30:57.296Z 2025-11-29T14:54:46.321Z
8568091 8568091 20251121050115_3V9jM DE000Y 2025-11-23T14:30:47.551Z 2025-11-29T14:54:46.054Z
8567613 8567613 20251121002128_KTU3G DE000Y 2025-11-23T14:26:14.644Z 2025-11-29T14:54:28.165Z
8567318 8567318 20251122052918_JyO2t DE000Y 2025-11-23T14:19:29.943Z 2025-11-30T15:07:02.635Z
8566945 8566945 20251122031146_M9ZRA DE000Y 2025-11-23T14:18:11.282Z 2025-11-30T15:06:24.448Z
8566900 8566900 20251122025356_htLd2 DE000Y 2025-11-23T14:17:58.866Z 2025-11-30T15:06:15.179Z
8566859 8566859 20251122024231_S1GK3 DE000Y 2025-11-23T14:17:46.727Z 2025-11-30T15:06:12.380Z
8566809 8566809 20251122022847_z2lH8 DE000Y 2025-11-23T14:17:35.963Z 2025-11-30T15:06:09.683Z
8566778 8566778 20251122021911_blb3p DE000Y 2025-11-23T14:17:30.558Z 2025-11-30T15:06:08.810Z
8566728 8566728 20251122020323_Mrurp DE000Y 2025-11-23T14:17:11.069Z 2025-11-30T15:06:06.809Z
8566709 8566709 20251122015554_GGdc7 DE000Y 2025-11-23T14:17:07.360Z 2025-11-30T15:06:05.658Z
8566688 8566688 20251122015010_QQHX3 DE000Y 2025-11-23T14:17:03.854Z 2025-11-30T15:06:04.566Z
8566660 8566660 20251122014203_Z8mMt DE000Y 2025-11-23T14:16:59.521Z 2025-11-30T15:06:00.825Z
8566632 8566632 20251122013600_KM7ur DE000Y 2025-11-23T14:16:54.313Z 2025-11-30T15:05:57.449Z
8566630 8566630 20251122013536_gkKMI DE000Y 2025-11-23T14:16:53.825Z 2025-11-30T15:05:57.332Z
8566623 8566623 20251122013257_SbdpE DE000Y 2025-11-23T14:16:51.076Z 2025-11-30T15:05:56.731Z
8566610 8566610 20251122012847_CRcDm DE000Y 2025-11-23T14:16:41.921Z 2025-11-30T15:05:55.083Z
8566608 8566608 20251122012812_iyfqP DE000Y 2025-11-23T14:16:41.499Z 2025-11-30T15:05:54.953Z
8566557 8566557 20251122011238_rntyt DE000Y 2025-11-23T14:16:34.418Z 2025-11-30T15:05:52.256Z
8566549 8566549 20251122011127_ROyGk DE000Y 2025-11-23T14:16:33.786Z 2025-11-30T15:05:51.824Z

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