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,400 rows where station_code = "DK000J" 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
8675928 8675928 20251202052313_ustN0 DK000J 2025-12-03T14:24:30.957Z 2025-12-06T14:35:04.885Z
8674766 8674766 20251202032048_hFIMO DK000J 2025-12-03T14:22:19.127Z 2025-12-06T14:34:18.187Z
8673392 8673392 20251201185447_6JqRG DK000J 2025-12-03T14:18:41.971Z 2025-12-06T14:33:06.520Z
8665192 8665192 20251201024616_sQogP DK000J 2025-12-02T14:23:06.528Z 2025-12-06T14:41:29.074Z
8624263 8624263 20251127035113_OcZ26 DK000J 2025-11-28T14:24:22.751Z 2025-12-05T15:04:56.874Z
8624246 8624246 20251127034701_EcpAh DK000J 2025-11-28T14:24:21.067Z 2025-12-05T15:04:55.904Z
8624134 8624134 20251127031509_QB363 DK000J 2025-11-28T14:23:51.179Z 2025-12-05T15:04:47.979Z
8624108 8624108 20251127030955_TBc89 DK000J 2025-11-28T14:23:47.535Z 2025-12-05T15:04:44.364Z
8624018 8624018 20251127024814_3ft8d DK000J 2025-11-28T14:23:37.864Z 2025-12-05T15:04:36.621Z
8624012 8624012 20251127024456_sMIm2 DK000J 2025-11-28T14:23:37.125Z 2025-12-05T15:04:34.110Z
8624006 8624006 20251127024443_fJTWs DK000J 2025-11-28T14:23:36.511Z 2025-12-05T15:04:33.953Z
8623990 8623990 20251127024036_yUQah DK000J 2025-11-28T14:23:31.935Z 2025-12-05T15:04:32.197Z
8623976 8623976 20251127023736_EAS3s DK000J 2025-11-28T14:23:17.105Z 2025-12-05T15:04:31.880Z
8623966 8623966 20251127023430_yz3Ui DK000J 2025-11-28T14:23:13.046Z 2025-12-05T15:04:31.193Z
8623872 8623872 20251127021929_yVhKy DK000J 2025-11-28T14:23:02.027Z 2025-12-05T15:04:23.821Z
8623122 8623122 20251126225700_CyU9H DK000J 2025-11-28T14:20:54.926Z 2025-12-05T15:03:30.414Z
8623034 8623034 20251126223248_LARds DK000J 2025-11-28T14:20:31.570Z 2025-12-05T15:03:26.018Z
8622939 8622939 20251126221016_28W2p DK000J 2025-11-28T14:20:21.052Z 2025-12-05T15:03:20.270Z
8622730 8622730 20251126205503_T5C80 DK000J 2025-11-28T14:19:45.499Z 2025-12-05T15:03:05.538Z
8622609 8622609 20251126201516_w60kA DK000J 2025-11-28T14:19:29.268Z 2025-12-05T15:03:04.045Z
8622475 8622475 20251126192947_l35Au DK000J 2025-11-28T14:18:56.550Z 2025-12-05T15:03:02.099Z
8612457 8612457 20251126023227_AUnTa DK000J 2025-11-27T14:24:14.731Z 2025-12-04T15:09:30.897Z
8611247 8611247 20251126013405_8X5cR DK000J 2025-11-27T14:21:43.966Z 2025-12-04T15:09:02.365Z
8611180 8611180 20251126012802_bLmnj DK000J 2025-11-27T14:21:35.663Z 2025-12-04T15:08:56.321Z
8607686 8607686 20251125211137_1OSR3 DK000J 2025-11-27T14:14:12.414Z 2025-12-04T15:07:13.524Z
8588699 8588699 20251124002315_cI43w DK000J 2025-11-25T14:18:09.885Z 2025-12-02T15:11:50.094Z
8587777 8587777 20251123224307_kjciP DK000J 2025-11-25T14:16:02.177Z 2025-12-02T15:11:19.720Z
8587600 8587600 20251123222149_D2yf4 DK000J 2025-11-25T14:15:37.875Z 2025-12-02T15:11:17.761Z
8587280 8587280 20251123214028_Aag4l DK000J 2025-11-25T14:14:56.823Z 2025-12-02T15:11:10.123Z
8587170 8587170 20251123213246_XaBdY DK000J 2025-11-25T14:14:47.522Z 2025-12-02T15:11:09.089Z
8586775 8586775 20251123205014_lMdPL DK000J 2025-11-25T14:13:55.104Z 2025-12-02T15:11:02.887Z
8586748 8586748 20251123204446_BDID0 DK000J 2025-11-25T14:13:44.845Z 2025-12-02T15:11:02.462Z
8586649 8586649 20251123202559_yUGLL DK000J 2025-11-25T14:13:32.960Z 2025-12-02T15:10:56.742Z
8586287 8586287 20251123191456_SfPkE DK000J 2025-11-25T14:12:26.695Z 2025-12-02T15:10:45.490Z
8586028 8586028 20251123183200_36XTS DK000J 2025-11-25T14:11:38.999Z 2025-12-02T15:10:39.650Z
8580660 8580660 20251123052642_hoIoP DK000J 2025-11-24T14:17:34.109Z 2025-12-01T15:22:21.835Z
8580646 8580646 20251123051303_DTG0e DK000J 2025-11-24T14:17:32.258Z 2025-12-01T15:22:21.075Z
8580567 8580567 20251123044829_2IHuP DK000J 2025-11-24T14:17:21.472Z 2025-12-01T15:22:19.360Z
8580536 8580536 20251123044647_CmIGn DK000J 2025-11-24T14:17:19.450Z 2025-12-01T15:22:19.028Z
8580491 8580491 20251123043434_xF6sC DK000J 2025-11-24T14:17:07.213Z 2025-12-01T15:22:18.241Z
8580445 8580445 20251123042250_a04Yz DK000J 2025-11-24T14:17:01.065Z 2025-12-01T15:22:17.360Z
8580376 8580376 20251123040642_3e38o DK000J 2025-11-24T14:16:52.755Z 2025-12-01T15:22:16.061Z
8580276 8580276 20251123033436_k27uU DK000J 2025-11-24T14:16:40.152Z 2025-12-01T15:22:11.466Z
8580265 8580265 20251123032430_qps9q DK000J 2025-11-24T14:16:33.337Z 2025-12-01T15:22:05.267Z
8580261 8580261 20251123032134_LdbAh DK000J 2025-11-24T14:16:32.503Z 2025-12-01T15:22:05.003Z
8580234 8580234 20251123031222_FYvy9 DK000J 2025-11-24T14:16:27.342Z 2025-12-01T15:22:01.874Z
8580228 8580228 20251123030954_j2lih DK000J 2025-11-24T14:16:26.695Z 2025-12-01T15:22:01.650Z
8580227 8580227 20251123030746_spQW2 DK000J 2025-11-24T14:16:26.315Z 2025-12-01T15:22:01.038Z
8580220 8580220 20251123030145_RZRqZ DK000J 2025-11-24T14:16:23.792Z 2025-12-01T15:21:57.707Z
8580204 8580204 20251123025428_c6P6n DK000J 2025-11-24T14:16:21.965Z 2025-12-01T15:21:52.943Z
8580157 8580157 20251123024229_fol84 DK000J 2025-11-24T14:16:15.829Z 2025-12-01T15:21:43.969Z
8580117 8580117 20251123023406_bYr7d DK000J 2025-11-24T14:16:11.066Z 2025-12-01T15:21:41.905Z
8580066 8580066 20251123022515_L0SPx DK000J 2025-11-24T14:16:03.947Z 2025-12-01T15:21:37.281Z
8580055 8580055 20251123022129_AXftn DK000J 2025-11-24T14:15:55.597Z 2025-12-01T15:21:36.661Z
8580036 8580036 20251123021830_3bYSv DK000J 2025-11-24T14:15:53.874Z 2025-12-01T15:21:34.260Z
8580031 8580031 20251123021829_DhWRO DK000J 2025-11-24T14:15:53.566Z 2025-12-01T15:21:34.242Z
8579991 8579991 20251123021229_wDKsM DK000J 2025-11-24T14:15:46.949Z 2025-12-01T15:21:31.132Z
8579968 8579968 20251123020716_qi3l2 DK000J 2025-11-24T14:15:43.696Z 2025-12-01T15:21:28.369Z
8579953 8579953 20251123015932_dd4VE DK000J 2025-11-24T14:15:42.049Z 2025-12-01T15:21:22.914Z
8579934 8579934 20251123015426_pjh6S DK000J 2025-11-24T14:15:39.546Z 2025-12-01T15:21:20.215Z
8579897 8579897 20251123014531_OJIcn DK000J 2025-11-24T14:15:33.738Z 2025-12-01T15:21:17.540Z
8579865 8579865 20251123013601_wrDd0 DK000J 2025-11-24T14:15:27.388Z 2025-12-01T15:21:11.955Z
8579860 8579860 20251123013203_TXb2y DK000J 2025-11-24T14:15:23.015Z 2025-12-01T15:21:11.699Z
8579827 8579827 20251123012521_Xt0Ou DK000J 2025-11-24T14:15:16.532Z 2025-12-01T15:21:11.112Z
8579751 8579751 20251123010547_qbDTC DK000J 2025-11-24T14:15:05.446Z 2025-12-01T15:21:00.237Z
8579695 8579695 20251123004956_iWb2U DK000J 2025-11-24T14:14:59.294Z 2025-12-01T15:20:55.435Z
8579613 8579613 20251123002626_f8dxR DK000J 2025-11-24T14:14:50.808Z 2025-12-01T15:20:48.169Z
8579575 8579575 20251123001605_mg87D DK000J 2025-11-24T14:14:39.941Z 2025-12-01T15:20:43.443Z
8571471 8571471 20251121205318_xVRyj DK000J 2025-11-23T14:36:33.301Z 2025-11-30T15:05:06.665Z
8571077 8571077 20251121185803_Mez3O DK000J 2025-11-23T14:35:56.933Z 2025-11-30T15:04:25.919Z
8567319 8567319 20251122052918_JyO2t DK000J 2025-11-23T14:19:29.944Z 2025-11-30T15:07:02.635Z
8567290 8567290 20251122051225_EKr9p DK000J 2025-11-23T14:19:25.249Z 2025-11-30T15:06:58.955Z
8567283 8567283 20251122051129_RKaVk DK000J 2025-11-23T14:19:24.681Z 2025-11-30T15:06:58.712Z
8567276 8567276 20251122050557_6NTp9 DK000J 2025-11-23T14:19:24.201Z 2025-11-30T15:06:58.053Z
8567234 8567234 20251122044422_GrFOV DK000J 2025-11-23T14:19:19.334Z 2025-11-30T15:06:51.217Z
8567226 8567226 20251122044121_MuhcB DK000J 2025-11-23T14:19:18.183Z 2025-11-23T14:19:18.183Z
8567222 8567222 20251122044015_V8YFj DK000J 2025-11-23T14:19:17.765Z 2025-11-30T15:06:50.817Z
8567218 8567218 20251122043946_eaYxf DK000J 2025-11-23T14:19:17.017Z 2025-11-30T15:06:49.810Z
8567203 8567203 20251122043720_CQRbC DK000J 2025-11-23T14:19:09.184Z 2025-11-30T15:06:49.380Z
8567188 8567188 20251122043258_3MWHA DK000J 2025-11-23T14:19:06.109Z 2025-11-30T15:06:48.174Z
8567135 8567135 20251122041911_C1Z5V DK000J 2025-11-23T14:18:59.868Z 2025-11-30T15:06:41.515Z
8567082 8567082 20251122040256_L0uok DK000J 2025-11-23T14:18:42.022Z 2025-11-30T15:06:36.724Z
8567066 8567066 20251122035459_7EwR2 DK000J 2025-11-23T14:18:39.961Z 2025-11-30T15:06:35.756Z
8567060 8567060 20251122035228_xzYkg DK000J 2025-11-23T14:18:39.317Z 2025-11-30T15:06:35.295Z
8567031 8567031 20251122034430_WFmAf DK000J 2025-11-23T14:18:33.983Z 2025-11-30T15:06:32.963Z
8567013 8567013 20251122034102_3aBjE DK000J 2025-11-23T14:18:31.300Z 2025-11-30T15:06:32.081Z
8567008 8567008 20251122034038_zBgOy DK000J 2025-11-23T14:18:30.049Z 2025-11-30T15:06:32.042Z
8567002 8567002 20251122033845_lXplP DK000J 2025-11-23T14:18:29.228Z 2025-11-30T15:06:31.989Z
8566946 8566946 20251122031146_M9ZRA DK000J 2025-11-23T14:18:11.282Z 2025-11-30T15:06:24.448Z
8566936 8566936 20251122030839_WojnG DK000J 2025-11-23T14:18:09.252Z 2025-11-30T15:06:22.824Z
8566821 8566821 20251122023046_ZDhfg DK000J 2025-11-23T14:17:37.701Z 2025-11-30T15:06:10.112Z
8566811 8566811 20251122022847_z2lH8 DK000J 2025-11-23T14:17:35.963Z 2025-11-30T15:06:09.683Z
8566689 8566689 20251122015010_QQHX3 DK000J 2025-11-23T14:17:03.854Z 2025-11-30T15:06:04.566Z
8566661 8566661 20251122014203_Z8mMt DK000J 2025-11-23T14:16:59.521Z 2025-11-30T15:06:00.825Z
8566640 8566640 20251122013804_SqpGM DK000J 2025-11-23T14:16:56.479Z 2025-11-30T15:05:57.673Z
8566631 8566631 20251122013536_gkKMI DK000J 2025-11-23T14:16:53.825Z 2025-11-30T15:05:57.332Z
8566611 8566611 20251122012847_CRcDm DK000J 2025-11-23T14:16:41.921Z 2025-11-30T15:05:55.083Z
8566609 8566609 20251122012812_iyfqP DK000J 2025-11-23T14:16:41.499Z 2025-11-30T15:05:54.953Z
8566564 8566564 20251122011430_b3CPh DK000J 2025-11-23T14:16:35.124Z 2025-11-30T15:05:52.387Z
8566482 8566482 20251122004828_TvvwB DK000J 2025-11-23T14:16:23.271Z 2025-11-30T15:05:50.375Z

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