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

988 rows where station_code = "TJ0002" 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
8680316 8680316 20251202231612_nZtR2 TJ0002 2025-12-04T14:11:41.268Z 2025-12-06T14:27:02.075Z
8680294 8680294 20251202230303_mHfuZ TJ0002 2025-12-04T14:11:37.823Z 2025-12-06T14:27:00.949Z
8680251 8680251 20251202224651_Kr1zW TJ0002 2025-12-04T14:11:29.610Z 2025-12-06T14:26:59.142Z
8680216 8680216 20251202223300_pVmdN TJ0002 2025-12-04T14:11:25.908Z 2025-12-06T14:26:56.679Z
8680184 8680184 20251202221614_dtY1V TJ0002 2025-12-04T14:11:22.664Z 2025-12-06T14:26:54.665Z
8680046 8680046 20251202212538_b6R5J TJ0002 2025-12-04T14:10:58.618Z 2025-12-06T14:26:48.758Z
8679823 8679823 20251202205540_bD7By TJ0002 2025-12-04T14:10:28.532Z 2025-12-06T14:26:40.509Z
8679767 8679767 20251202204839_fALOv TJ0002 2025-12-04T14:10:24.241Z 2025-12-06T14:26:39.255Z
8673813 8673813 20251201234050_BFYjw TJ0002 2025-12-03T14:20:06.043Z 2025-12-06T14:33:35.765Z
8673800 8673800 20251201233426_YMmZ2 TJ0002 2025-12-03T14:20:04.980Z 2025-12-06T14:33:35.535Z
8673798 8673798 20251201233321_HkTO7 TJ0002 2025-12-03T14:20:04.714Z 2025-12-06T14:33:35.466Z
8673784 8673784 20251201230356_2riKT TJ0002 2025-12-03T14:20:02.205Z 2025-12-06T14:33:34.170Z
8673749 8673749 20251201222017_rn3q0 TJ0002 2025-12-03T14:19:56.971Z 2025-12-06T14:33:31.619Z
8673747 8673747 20251201221129_O4qia TJ0002 2025-12-03T14:19:52.452Z 2025-12-06T14:33:31.468Z
8673745 8673745 20251201221003_JRr6X TJ0002 2025-12-03T14:19:49.631Z 2025-12-06T14:33:31.216Z
8673601 8673601 20251201203323_DoasL TJ0002 2025-12-03T14:19:25.992Z 2025-12-06T14:33:24.778Z
8673558 8673558 20251201200350_zHlg4 TJ0002 2025-12-03T14:19:17.725Z 2025-12-06T14:33:22.704Z
8666752 8666752 20251201005049_c2j2d TJ0002 2025-12-02T14:27:21.104Z 2025-12-06T14:40:49.516Z
8666750 8666750 20251201000123_IE3K3 TJ0002 2025-12-02T14:27:20.445Z 2025-12-06T14:40:43.871Z
8666745 8666745 20251130220414_XRGSG TJ0002 2025-12-02T14:27:19.065Z 2025-12-06T14:40:11.257Z
8666741 8666741 20251130200120_o3Ap8 TJ0002 2025-12-02T14:27:17.206Z 2025-12-06T14:39:46.168Z
8651429 8651429 20251129234142_AmBh7 TJ0002 2025-12-01T14:19:06.445Z 2025-12-06T14:46:46.076Z
8651280 8651280 20251129232100_E9OTh TJ0002 2025-12-01T14:18:32.853Z 2025-12-06T14:46:43.120Z
8650735 8650735 20251129211738_3ppsy TJ0002 2025-12-01T14:17:03.784Z 2025-12-06T14:46:32.853Z
8650733 8650733 20251129211618_AP3G5 TJ0002 2025-12-01T14:17:03.251Z 2025-12-06T14:46:32.814Z
8650397 8650397 20251129200719_dN6Tv TJ0002 2025-12-01T14:16:00.688Z 2025-12-06T14:45:55.503Z
8649307 8649307 20251129170118_Isxbh TJ0002 2025-12-01T14:11:57.495Z 2025-12-06T14:44:55.177Z
8645878 8645878 20251129001153_Kc5qg TJ0002 2025-11-30T14:24:38.986Z 2025-12-06T14:55:13.088Z
8645736 8645736 20251128234143_O3qA6 TJ0002 2025-11-30T14:24:27.908Z 2025-12-06T14:55:03.914Z
8645494 8645494 20251128222525_ULbqz TJ0002 2025-11-30T14:23:48.730Z 2025-12-06T14:54:59.016Z
8645430 8645430 20251128220745_sw7Tw TJ0002 2025-11-30T14:23:43.067Z 2025-12-06T14:54:57.577Z
8644974 8644974 20251128202020_3V2Mn TJ0002 2025-11-30T14:22:55.273Z 2025-12-06T14:54:49.524Z
8644929 8644929 20251128201524_lhnEE TJ0002 2025-11-30T14:22:53.036Z 2025-12-06T14:54:49.139Z
8644102 8644102 20251128185718_0vxbT TJ0002 2025-11-30T14:21:20.376Z 2025-12-06T14:54:38.103Z
8634680 8634680 20251128010954_foyGQ TJ0002 2025-11-29T14:21:55.204Z 2025-12-06T15:02:29.401Z
8634441 8634441 20251128005105_eYz7R TJ0002 2025-11-29T14:21:21.968Z 2025-12-06T15:02:04.749Z
8623541 8623541 20251127010225_iksEl TJ0002 2025-11-28T14:22:08.092Z 2025-12-05T15:03:58.973Z
8623506 8623506 20251127005544_iYO4E TJ0002 2025-11-28T14:22:03.820Z 2025-12-05T15:03:58.060Z
8623424 8623424 20251127002905_XLDA4 TJ0002 2025-11-28T14:21:42.607Z 2025-12-05T15:03:49.891Z
8598388 8598388 20251125005312_w9ADn TJ0002 2025-11-26T14:18:43.814Z 2025-12-02T15:07:53.448Z
8597746 8597746 20251125000653_udVos TJ0002 2025-11-26T14:17:37.833Z 2025-12-02T15:07:40.499Z
8597744 8597744 20251125000624_3zRCi TJ0002 2025-11-26T14:17:37.431Z 2025-12-02T15:07:40.482Z
8597726 8597726 20251125000453_kb9jj TJ0002 2025-11-26T14:17:27.087Z 2025-12-02T15:07:40.257Z
8597640 8597640 20251124235519_YP3TR TJ0002 2025-11-26T14:17:15.185Z 2025-12-02T15:07:38.617Z
8597510 8597510 20251124233948_mtdwt TJ0002 2025-11-26T14:16:53.939Z 2025-12-02T15:07:36.826Z
8596878 8596878 20251124222052_olnX4 TJ0002 2025-11-26T14:15:40.312Z 2025-12-02T15:07:15.481Z
8596846 8596846 20251124221905_82u9H TJ0002 2025-11-26T14:15:37.845Z 2025-12-02T15:07:15.222Z
8596283 8596283 20251124203834_mjyzS TJ0002 2025-11-26T14:14:07.097Z 2025-12-02T15:06:52.643Z
8595812 8595812 20251124183330_J0F65 TJ0002 2025-11-26T14:12:32.731Z 2025-12-02T15:06:12.776Z
8595791 8595791 20251124182644_PPYKh TJ0002 2025-11-26T14:12:29.522Z 2025-12-02T15:06:10.988Z
8595620 8595620 20251124171527_n3AXm TJ0002 2025-11-26T14:11:46.960Z 2025-12-02T15:06:02.402Z
8595579 8595579 20251124170502_Tq4cv TJ0002 2025-11-26T14:11:41.211Z 2025-12-02T15:06:01.899Z
8588579 8588579 20251124001201_tl25r TJ0002 2025-11-25T14:17:49.225Z 2025-12-02T15:11:49.330Z
8588057 8588057 20251123231740_cCCb3 TJ0002 2025-11-25T14:16:48.413Z 2025-12-02T15:11:24.453Z
8587670 8587670 20251123222951_LFoEU TJ0002 2025-11-25T14:15:52.800Z 2025-12-02T15:11:18.917Z
8587439 8587439 20251123220422_r8Xcb TJ0002 2025-11-25T14:15:20.197Z 2025-12-02T15:11:13.365Z
8585801 8585801 20251123174432_9Ds6o TJ0002 2025-11-25T14:10:59.152Z 2025-12-02T15:10:20.683Z
8579636 8579636 20251123003409_gYENY TJ0002 2025-11-24T14:14:53.436Z 2025-12-01T15:20:50.380Z
8579232 8579232 20251122224857_UjShi TJ0002 2025-11-24T14:13:49.526Z 2025-12-01T15:20:07.970Z
8579120 8579120 20251122222433_O0lu8 TJ0002 2025-11-24T14:13:38.874Z 2025-12-01T15:20:03.831Z
8578353 8578353 20251122203017_rJs63 TJ0002 2025-11-24T14:11:36.241Z 2025-12-01T15:19:33.373Z
8577816 8577816 20251122185728_7wefI TJ0002 2025-11-24T14:09:44.754Z 2025-12-01T15:18:59.056Z
8577125 8577125 20251122172318_hOu28 TJ0002 2025-11-24T14:07:38.595Z 2025-12-01T15:18:43.798Z
8566456 8566456 20251122004110_VWlqo TJ0002 2025-11-23T14:16:12.801Z 2025-11-30T15:05:49.341Z
8566428 8566428 20251122003419_4E3lQ TJ0002 2025-11-23T14:16:08.401Z 2025-11-30T15:05:47.881Z
8566287 8566287 20251121235630_pLpEs TJ0002 2025-11-23T14:15:40.849Z 2025-11-30T15:05:41.067Z
8566124 8566124 20251121225822_Jh95R TJ0002 2025-11-23T14:15:06.489Z 2025-11-30T15:05:26.227Z
8566112 8566112 20251121225514_WwrNy TJ0002 2025-11-23T14:15:05.020Z 2025-11-30T15:05:25.864Z
8566013 8566013 20251121222501_PzguJ TJ0002 2025-11-23T14:14:52.044Z 2025-11-30T15:05:20.166Z
8565945 8565945 20251121220923_RnYGm TJ0002 2025-11-23T14:14:35.778Z 2025-11-30T15:05:19.077Z
8565752 8565752 20251121210837_z39To TJ0002 2025-11-23T14:14:00.067Z 2025-11-30T15:05:08.294Z
8565639 8565639 20251121205548_WGKd4 TJ0002 2025-11-23T14:13:47.973Z 2025-11-30T15:05:06.894Z
8565151 8565151 20251121195629_HRcsO TJ0002 2025-11-23T14:12:39.414Z 2025-11-30T15:04:43.659Z
8555084 8555084 20251121005531_sChr2 TJ0002 2025-11-22T14:37:55.964Z 2025-11-29T14:54:29.948Z
8550057 8550057 20251120231520_evUg1 TJ0002 2025-11-22T14:20:11.278Z 2025-11-29T14:54:26.131Z
8549431 8549431 20251120222956_eeOCH TJ0002 2025-11-22T14:18:57.226Z 2025-11-29T14:54:24.744Z
8549056 8549056 20251120214458_WK2tz TJ0002 2025-11-22T14:18:10.616Z 2025-11-29T14:54:23.890Z
8548879 8548879 20251120212705_u5qcx TJ0002 2025-11-22T14:17:53.044Z 2025-11-29T14:54:23.522Z
8548333 8548333 20251120204933_NDd7S TJ0002 2025-11-22T14:16:45.355Z 2025-11-29T14:54:22.393Z
8548212 8548212 20251120204220_oiL83 TJ0002 2025-11-22T14:16:35.865Z 2025-11-29T14:54:22.204Z
8547793 8547793 20251120201455_suq06 TJ0002 2025-11-22T14:15:43.367Z 2025-11-29T14:54:20.990Z
8547662 8547662 20251120200538_M1JEr TJ0002 2025-11-22T14:15:26.403Z 2025-11-29T14:54:20.734Z
8547615 8547615 20251120200330_N4xfH TJ0002 2025-11-22T14:15:22.005Z 2025-11-29T14:54:20.590Z
8546493 8546493 20251120183501_K4qLY TJ0002 2025-11-22T14:12:52.394Z 2025-11-29T14:54:15.606Z
8534891 8534891 20251120003725_3azBB TJ0002 2025-11-21T14:14:47.633Z 2025-11-28T14:56:04.259Z
8534523 8534523 20251119233353_dlzXU TJ0002 2025-11-21T14:14:00.439Z 2025-11-28T14:55:47.918Z
8534376 8534376 20251119231214_oTOJ2 TJ0002 2025-11-21T14:13:45.242Z 2025-11-28T14:55:45.117Z
8534324 8534324 20251119230119_sH8ef TJ0002 2025-11-21T14:13:36.873Z 2025-11-28T14:55:41.586Z
8534250 8534250 20251119224257_3ST3x TJ0002 2025-11-21T14:13:24.016Z 2025-11-28T14:55:39.721Z
8534193 8534193 20251119223447_VQTx7 TJ0002 2025-11-21T14:13:16.311Z 2025-11-28T14:55:38.024Z
8534096 8534096 20251119220208_JHEyA TJ0002 2025-11-21T14:13:05.680Z 2025-11-28T14:55:35.809Z
8533850 8533850 20251119203936_1kCOR TJ0002 2025-11-21T14:12:12.446Z 2025-11-28T14:55:18.681Z
8533726 8533726 20251119200016_xH7oP TJ0002 2025-11-21T14:11:49.720Z 2025-11-28T14:55:03.682Z
8522957 8522957 20251119011218_V4q2F TJ0002 2025-11-20T14:17:01.857Z 2025-11-27T15:12:08.143Z
8522693 8522693 20251119004535_y8twM TJ0002 2025-11-20T14:16:16.168Z 2025-11-27T15:12:05.865Z
8522610 8522610 20251119003743_1RTDG TJ0002 2025-11-20T14:16:06.771Z 2025-11-27T15:12:05.294Z
8522482 8522482 20251119001757_s07it TJ0002 2025-11-20T14:15:32.085Z 2025-11-27T15:12:02.945Z
8522412 8522412 20251119000640_egabA TJ0002 2025-11-20T14:15:21.544Z 2025-11-27T15:12:01.300Z
8522220 8522220 20251118233550_WVLMD TJ0002 2025-11-20T14:14:49.697Z 2025-11-27T15:11:57.261Z
8522164 8522164 20251118232954_3u5R0 TJ0002 2025-11-20T14:14:42.731Z 2025-11-27T15:11:55.940Z

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