participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,244 rows where station_code = "AU0030" sorted by created_at descending
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 |
---|---|---|---|---|---|
5450343 | 5450343 | 20241031185041_19G68 | AU0030 | 2024-11-02T12:15:00.051Z | 2024-11-03T14:21:11.801Z |
5450263 | 5450263 | 20241031182820_YCFIc | AU0030 | 2024-11-02T12:14:52.155Z | 2024-11-03T14:21:09.847Z |
5449992 | 5449992 | 20241031173212_2gZiI | AU0030 | 2024-11-02T12:14:05.023Z | 2024-11-03T14:21:02.649Z |
5449935 | 5449935 | 20241031171943_GVLBZ | AU0030 | 2024-11-02T12:13:58.915Z | 2024-11-03T14:21:01.607Z |
5449847 | 5449847 | 20241031165706_OPZdo | AU0030 | 2024-11-02T12:13:50.825Z | 2024-11-03T14:20:59.884Z |
5449806 | 5449806 | 20241031164444_x2X1n | AU0030 | 2024-11-02T12:13:47.415Z | 2024-11-03T14:20:59.032Z |
5449794 | 5449794 | 20241031164238_0lYtX | AU0030 | 2024-11-02T12:13:46.737Z | 2024-11-03T14:20:58.977Z |
5449734 | 5449734 | 20241031162405_wOc2R | AU0030 | 2024-11-02T12:13:38.653Z | 2024-11-03T14:20:58.204Z |
5449688 | 5449688 | 20241031160806_y4rOX | AU0030 | 2024-11-02T12:13:21.820Z | 2024-11-03T14:20:57.615Z |
5449547 | 5449547 | 20241031155023_8PEij | AU0030 | 2024-11-02T12:13:05.125Z | 2024-11-03T14:20:54.567Z |
5449332 | 5449332 | 20241031152059_2bsAe | AU0030 | 2024-11-02T12:12:33.480Z | 2024-11-03T14:20:51.699Z |
5448834 | 5448834 | 20241031142208_yPLcB | AU0030 | 2024-11-02T12:11:32.109Z | 2024-11-03T14:20:43.088Z |
5448343 | 5448343 | 20241031131753_3IVv7 | AU0030 | 2024-11-02T12:10:34.498Z | 2024-11-03T14:20:36.132Z |
5447529 | 5447529 | 20241031114923_I1nH3 | AU0030 | 2024-11-02T12:08:23.023Z | 2024-11-03T14:20:23.666Z |
5444797 | 5444797 | 20241027170157_1QgHm | AU0030 | 2024-11-01T12:23:41.641Z | 2024-11-03T14:25:43.223Z |
5438837 | 5438837 | 20241030181412_vX7Jk | AU0030 | 2024-11-01T12:12:31.067Z | 2024-11-03T14:22:44.559Z |
5438703 | 5438703 | 20241030175146_C13H8 | AU0030 | 2024-11-01T12:12:18.228Z | 2024-11-03T14:22:43.851Z |
5438505 | 5438505 | 20241030172657_4Sotd | AU0030 | 2024-11-01T12:11:48.197Z | 2024-11-03T14:22:43.115Z |
5438393 | 5438393 | 20241030171206_Y57Qn | AU0030 | 2024-11-01T12:11:38.768Z | 2024-11-03T14:22:42.620Z |
5438228 | 5438228 | 20241030164254_Bziaj | AU0030 | 2024-11-01T12:11:22.608Z | 2024-11-03T14:22:41.988Z |
5438096 | 5438096 | 20241030162041_m4Dde | AU0030 | 2024-11-01T12:10:57.794Z | 2024-11-03T14:22:41.550Z |
5437979 | 5437979 | 20241030160929_Anh33 | AU0030 | 2024-11-01T12:10:48.230Z | 2024-11-03T14:22:41.112Z |
5437735 | 5437735 | 20241030153748_FVzZG | AU0030 | 2024-11-01T12:10:15.779Z | 2024-11-03T14:22:40.430Z |
5437450 | 5437450 | 20241030150910_bs9Ow | AU0030 | 2024-11-01T12:09:40.233Z | 2024-11-03T14:22:39.626Z |
5437157 | 5437157 | 20241030143507_BumNO | AU0030 | 2024-11-01T12:09:10.274Z | 2024-11-03T14:22:38.766Z |
5436768 | 5436768 | 20241030134525_h4Wmf | AU0030 | 2024-11-01T12:08:13.241Z | 2024-11-03T14:22:37.663Z |
5436516 | 5436516 | 20241030131605_Q958h | AU0030 | 2024-11-01T12:07:47.556Z | 2024-11-03T14:22:36.926Z |
5436041 | 5436041 | 20241030122248_HmJ4J | AU0030 | 2024-11-01T12:06:37.085Z | 2024-11-03T14:22:35.143Z |
5433735 | 5433735 | 20241027170154_8pBA6 | AU0030 | 2024-10-31T12:23:51.360Z | 2024-11-03T14:25:43.217Z |
5433491 | 5433491 | 20241029200807_W9Cp7 | AU0030 | 2024-10-31T12:22:18.191Z | 2024-11-03T14:23:55.912Z |
5429897 | 5429897 | 20241028202002_gMSrY | AU0030 | 2024-10-31T12:17:11.914Z | 2024-11-03T14:24:59.275Z |
5429680 | 5429680 | 20241028194930_97lsf | AU0030 | 2024-10-31T12:16:53.396Z | 2024-11-03T14:24:58.421Z |
5429643 | 5429643 | 20241028194413_n1dAy | AU0030 | 2024-10-31T12:16:50.714Z | 2024-11-03T14:24:58.308Z |
5429639 | 5429639 | 20241028194336_9qdhV | AU0030 | 2024-10-31T12:16:50.661Z | 2024-11-03T14:24:58.242Z |
5429603 | 5429603 | 20241028193945_ZCCpK | AU0030 | 2024-10-31T12:16:48.458Z | 2024-11-03T14:24:58.041Z |
5429470 | 5429470 | 20241028192649_IWcgJ | AU0030 | 2024-10-31T12:16:36.693Z | 2024-11-03T14:24:57.428Z |
5429433 | 5429433 | 20241028192321_jHPnG | AU0030 | 2024-10-31T12:16:32.746Z | 2024-11-03T14:24:57.375Z |
5429376 | 5429376 | 20241028191709_NiVRm | AU0030 | 2024-10-31T12:16:28.394Z | 2024-11-03T14:24:57.284Z |
5429296 | 5429296 | 20241028190824_Juo1i | AU0030 | 2024-10-31T12:16:19.754Z | 2024-11-03T14:24:56.630Z |
5429238 | 5429238 | 20241028190334_MEZLl | AU0030 | 2024-10-31T12:16:16.075Z | 2024-11-03T14:24:56.450Z |
5429178 | 5429178 | 20241028185612_MvhFn | AU0030 | 2024-10-31T12:16:08.445Z | 2024-11-03T14:24:56.145Z |
5429164 | 5429164 | 20241028185430_bDSZl | AU0030 | 2024-10-31T12:16:06.758Z | 2024-11-03T14:24:56.081Z |
5429144 | 5429144 | 20241028185343_2v1oN | AU0030 | 2024-10-31T12:16:04.807Z | 2024-11-03T14:24:55.911Z |
5429077 | 5429077 | 20241028184326_3npZQ | AU0030 | 2024-10-31T12:15:57.761Z | 2024-11-03T14:24:55.504Z |
5428858 | 5428858 | 20241028181525_jAS3l | AU0030 | 2024-10-31T12:15:36.279Z | 2024-11-03T14:24:54.074Z |
5428765 | 5428765 | 20241028180413_fwNo6 | AU0030 | 2024-10-31T12:15:29.665Z | 2024-11-03T14:24:53.805Z |
5428429 | 5428429 | 20241028171316_40f0k | AU0030 | 2024-10-31T12:15:08.815Z | 2024-11-03T14:24:51.702Z |
5428402 | 5428402 | 20241028170701_vTyfP | AU0030 | 2024-10-31T12:15:07.213Z | 2024-11-03T14:24:51.637Z |
5428278 | 5428278 | 20241028164425_SqP6O | AU0030 | 2024-10-31T12:14:54.562Z | 2024-11-03T14:24:51.264Z |
5427979 | 5427979 | 20241028160828_kky7I | AU0030 | 2024-10-31T12:14:21.407Z | 2024-11-03T14:24:49.415Z |
5427924 | 5427924 | 20241028160102_iLbIH | AU0030 | 2024-10-31T12:14:14.233Z | 2024-11-03T14:24:49.319Z |
5427812 | 5427812 | 20241028154716_NOUHq | AU0030 | 2024-10-31T12:14:01.424Z | 2024-11-03T14:24:48.917Z |
5427642 | 5427642 | 20241028152552_ePjZO | AU0030 | 2024-10-31T12:13:42.111Z | 2024-11-03T14:24:48.150Z |
5427639 | 5427639 | 20241028152534_VtKts | AU0030 | 2024-10-31T12:13:41.860Z | 2024-11-03T14:24:48.130Z |
5427254 | 5427254 | 20241028145141_yaKjc | AU0030 | 2024-10-31T12:13:22.665Z | 2024-11-03T14:24:46.402Z |
5426874 | 5426874 | 20241028140449_VQTgm | AU0030 | 2024-10-31T12:12:35.358Z | 2024-11-03T14:24:45.353Z |
5426619 | 5426619 | 20241028133345_IOWDR | AU0030 | 2024-10-31T12:12:16.685Z | 2024-11-03T14:24:44.123Z |
5426485 | 5426485 | 20241029195440_wPxps | AU0030 | 2024-10-31T12:10:03.993Z | 2024-11-03T14:23:54.720Z |
5426455 | 5426455 | 20241029195017_eFmVx | AU0030 | 2024-10-31T12:10:01.488Z | 2024-11-03T14:23:54.507Z |
5426433 | 5426433 | 20241029194739_0lAQY | AU0030 | 2024-10-31T12:09:59.828Z | 2024-11-03T14:23:54.426Z |
5426398 | 5426398 | 20241029194432_nkCXZ | AU0030 | 2024-10-31T12:09:56.532Z | 2024-11-03T14:23:54.105Z |
5426375 | 5426375 | 20241029194123_3uylN | AU0030 | 2024-10-31T12:09:54.587Z | 2024-11-03T14:23:53.935Z |
5426312 | 5426312 | 20241029193051_2Ep8T | AU0030 | 2024-10-31T12:09:49.389Z | 2024-11-03T14:23:53.636Z |
5426294 | 5426294 | 20241029192635_l5Yqo | AU0030 | 2024-10-31T12:09:47.538Z | 2024-11-03T14:23:53.471Z |
5426273 | 5426273 | 20241029192252_xvJ8m | AU0030 | 2024-10-31T12:09:45.945Z | 2024-11-03T14:23:53.379Z |
5426265 | 5426265 | 20241029192146_FRwpq | AU0030 | 2024-10-31T12:09:45.391Z | 2024-11-03T14:23:53.360Z |
5426123 | 5426123 | 20241029185414_0YVP9 | AU0030 | 2024-10-31T12:09:23.744Z | 2024-11-03T14:23:50.779Z |
5426071 | 5426071 | 20241029183834_lK9pP | AU0030 | 2024-10-31T12:09:12.460Z | 2024-11-03T14:23:49.528Z |
5426062 | 5426062 | 20241029183805_r5215 | AU0030 | 2024-10-31T12:09:11.991Z | 2024-11-03T14:23:49.519Z |
5425858 | 5425858 | 20241029180312_68hDN | AU0030 | 2024-10-31T12:08:50.921Z | 2024-11-03T14:23:46.870Z |
5425761 | 5425761 | 20241029175145_CS302 | AU0030 | 2024-10-31T12:08:33.100Z | 2024-11-03T14:23:46.286Z |
5425284 | 5425284 | 20241029161830_oy1Ri | AU0030 | 2024-10-31T12:07:24.113Z | 2024-11-03T14:23:41.721Z |
5425258 | 5425258 | 20241029161529_rUMak | AU0030 | 2024-10-31T12:07:21.431Z | 2024-11-03T14:23:41.531Z |
5425208 | 5425208 | 20241029160949_ckunY | AU0030 | 2024-10-31T12:07:15.455Z | 2024-11-03T14:23:41.396Z |
5425078 | 5425078 | 20241029154935_eTzrY | AU0030 | 2024-10-31T12:06:47.245Z | 2024-11-03T14:23:40.799Z |
5424906 | 5424906 | 20241029153151_AGVJH | AU0030 | 2024-10-31T12:06:28.941Z | 2024-11-03T14:23:39.751Z |
5424659 | 5424659 | 20241029145647_Lf5Fn | AU0030 | 2024-10-31T12:05:47.743Z | 2024-11-03T14:23:38.447Z |
5424467 | 5424467 | 20241029143137_bK0QB | AU0030 | 2024-10-31T12:05:08.370Z | 2024-11-03T14:23:36.762Z |
5422913 | 5422913 | 20241026200102_nDqW3 | AU0030 | 2024-10-30T12:21:56.041Z | 2024-11-03T14:26:26.530Z |
5422871 | 5422871 | 20241026192010_bh915 | AU0030 | 2024-10-30T12:21:49.570Z | 2024-11-03T14:26:24.679Z |
5422835 | 5422835 | 20241026181950_J5otT | AU0030 | 2024-10-30T12:21:37.933Z | 2024-11-03T14:26:20.708Z |
5422726 | 5422726 | 20241026140318_raW6O | AU0030 | 2024-10-30T12:21:21.918Z | 2024-11-03T14:26:16.081Z |
5422694 | 5422694 | 20241026131826_MxClD | AU0030 | 2024-10-30T12:21:19.788Z | 2024-11-03T14:26:15.577Z |
5422680 | 5422680 | 20241026123346_MIEmF | AU0030 | 2024-10-30T12:21:17.640Z | 2024-11-03T14:26:15.061Z |
5422675 | 5422675 | 20241026123110_Vf2hr | AU0030 | 2024-10-30T12:21:17.528Z | 2024-11-03T14:26:14.975Z |
5422389 | 5422389 | 20241028125829_OmYQr | AU0030 | 2024-10-30T12:20:26.266Z | 2024-11-03T14:24:42.043Z |
5422318 | 5422318 | 20241028124820_I88Tj | AU0030 | 2024-10-30T12:20:25.412Z | 2024-11-03T14:24:41.873Z |
5422311 | 5422311 | 20241028124729_xT3Q0 | AU0030 | 2024-10-30T12:20:25.349Z | 2024-11-03T14:24:41.865Z |
5422216 | 5422216 | 20241028123147_FY2o8 | AU0030 | 2024-10-30T12:20:23.909Z | 2024-11-03T14:24:41.313Z |
5421931 | 5421931 | 20241028120115_0BbIS | AU0030 | 2024-10-30T12:20:18.613Z | 2024-11-03T14:24:39.799Z |
5418282 | 5418282 | 20241027201626_IsUdu | AU0030 | 2024-10-30T12:15:19.345Z | 2024-11-03T14:25:50.723Z |
5418271 | 5418271 | 20241027201515_mKpHW | AU0030 | 2024-10-30T12:15:16.981Z | 2024-11-03T14:25:50.712Z |
5418250 | 5418250 | 20241027201240_3tccP | AU0030 | 2024-10-30T12:15:13.081Z | 2024-11-03T14:25:50.687Z |
5418242 | 5418242 | 20241027201221_1CY0c | AU0030 | 2024-10-30T12:15:12.245Z | 2024-11-03T14:25:50.654Z |
5418073 | 5418073 | 20241027195041_izwZm | AU0030 | 2024-10-30T12:14:51.006Z | 2024-11-03T14:25:48.965Z |
5418033 | 5418033 | 20241027194226_f08Hm | AU0030 | 2024-10-30T12:14:46.566Z | 2024-11-03T14:25:48.494Z |
5418019 | 5418019 | 20241027194126_HysL9 | AU0030 | 2024-10-30T12:14:45.263Z | 2024-11-03T14:25:48.473Z |
5417997 | 5417997 | 20241027193826_4OJEb | AU0030 | 2024-10-30T12:14:43.497Z | 2024-11-03T14:25:48.342Z |
5417948 | 5417948 | 20241027193428_F1X2i | AU0030 | 2024-10-30T12:14:39.497Z | 2024-11-03T14:25:48.187Z |
5417933 | 5417933 | 20241027193236_JXbFc | AU0030 | 2024-10-30T12:14:38.789Z | 2024-11-03T14:25:48.169Z |
Advanced export
JSON shape: default, array, newline-delimited
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);