participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,478 rows where station_code = "AU001B" 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 |
---|---|---|---|---|---|
5097059 | 5097059 | 20240912141013_9fIQt | AU001B | 2024-09-16T12:16:43.829Z | 2024-09-16T12:17:32.016Z |
5097050 | 5097050 | 20240912140533_ajyeC | AU001B | 2024-09-16T12:16:43.589Z | 2024-09-16T12:17:32.014Z |
5096961 | 5096961 | 20240912130152_Ww6wQ | AU001B | 2024-09-16T12:16:40.728Z | 2024-09-16T12:17:31.980Z |
5096948 | 5096948 | 20240912124409_BTrft | AU001B | 2024-09-16T12:16:39.974Z | 2024-09-16T12:17:31.973Z |
5085307 | 5085307 | 20240912210727_Y0VLC | AU001B | 2024-09-16T12:03:55.452Z | 2024-09-16T12:17:04.681Z |
5085245 | 5085245 | 20240912210333_r14mY | AU001B | 2024-09-16T12:03:47.618Z | 2024-09-16T12:17:04.665Z |
5085093 | 5085093 | 20240912204501_KNXl3 | AU001B | 2024-09-16T12:03:31.013Z | 2024-09-16T12:17:04.580Z |
5085084 | 5085084 | 20240912204445_e8xA4 | AU001B | 2024-09-16T12:03:29.817Z | 2024-09-16T12:17:04.576Z |
5084674 | 5084674 | 20240912200401_dwp2d | AU001B | 2024-09-16T12:02:45.720Z | 2024-09-16T12:17:04.415Z |
5084626 | 5084626 | 20240912195821_9AFWD | AU001B | 2024-09-16T12:02:40.506Z | 2024-09-16T12:17:04.395Z |
5084368 | 5084368 | 20240912193012_g3F8k | AU001B | 2024-09-16T12:01:58.348Z | 2024-09-16T12:17:04.271Z |
5084328 | 5084328 | 20240912192213_bCIgA | AU001B | 2024-09-16T12:01:53.017Z | 2024-09-16T12:17:04.250Z |
5084300 | 5084300 | 20240912191257_c3nql | AU001B | 2024-09-16T12:01:49.994Z | 2024-09-16T12:17:04.237Z |
5084259 | 5084259 | 20240912190339_EBSqQ | AU001B | 2024-09-16T12:01:42.871Z | 2024-09-16T12:17:04.207Z |
5084164 | 5084164 | 20240912184113_dhr17 | AU001B | 2024-09-16T12:01:21.913Z | 2024-09-16T12:17:04.148Z |
5084156 | 5084156 | 20240912183433_2F425 | AU001B | 2024-09-16T12:01:17.330Z | 2024-09-16T12:17:04.142Z |
5084146 | 5084146 | 20240912183046_cB83S | AU001B | 2024-09-16T12:01:15.911Z | 2024-09-16T12:17:04.137Z |
5084125 | 5084125 | 20240912182026_qxoOd | AU001B | 2024-09-16T12:01:13.008Z | 2024-09-16T12:17:04.109Z |
5084118 | 5084118 | 20240912181832_ynXGE | AU001B | 2024-09-16T12:01:11.798Z | 2024-09-16T12:17:04.104Z |
5084068 | 5084068 | 20240912175934_DtPef | AU001B | 2024-09-16T12:01:04.160Z | 2024-09-16T12:17:04.074Z |
5084010 | 5084010 | 20240912173702_dp4Rf | AU001B | 2024-09-16T12:00:55.183Z | 2024-09-16T12:17:04.034Z |
5083943 | 5083943 | 20240912170234_jgVWW | AU001B | 2024-09-16T12:00:42.309Z | 2024-09-16T12:17:03.994Z |
5083901 | 5083901 | 20240912163924_V4IdR | AU001B | 2024-09-16T12:00:37.237Z | 2024-09-16T12:17:03.969Z |
5083881 | 5083881 | 20240912163212_wq7wq | AU001B | 2024-09-16T12:00:35.187Z | 2024-09-16T12:17:03.961Z |
5083856 | 5083856 | 20240912162001_i8vIP | AU001B | 2024-09-16T12:00:32.310Z | 2024-09-16T12:17:03.950Z |
5083839 | 5083839 | 20240912161058_mX9oq | AU001B | 2024-09-16T12:00:29.595Z | 2024-09-16T12:17:03.936Z |
5083818 | 5083818 | 20240912155534_MqqkB | AU001B | 2024-09-16T12:00:26.631Z | 2024-09-16T12:17:03.925Z |
5083807 | 5083807 | 20240912154703_1Q4Yh | AU001B | 2024-09-16T12:00:25.109Z | 2024-09-16T12:17:03.919Z |
5083767 | 5083767 | 20240912151732_afq2b | AU001B | 2024-09-16T12:00:17.895Z | 2024-09-16T12:17:03.890Z |
5083766 | 5083766 | 20240912151606_4DaaD | AU001B | 2024-09-16T12:00:17.426Z | 2024-09-16T12:17:03.889Z |
5083745 | 5083745 | 20240911141908_6Us4N | AU001B | 2024-09-15T12:18:45.869Z | 2024-09-16T12:19:20.414Z |
5083677 | 5083677 | 20240911141034_bxU4l | AU001B | 2024-09-15T12:18:45.468Z | 2024-09-16T12:19:20.124Z |
5083539 | 5083539 | 20240911134528_w1ZWs | AU001B | 2024-09-15T12:18:43.480Z | 2024-09-16T12:19:19.412Z |
5083361 | 5083361 | 20240911130136_SZfvp | AU001B | 2024-09-15T12:18:40.133Z | 2024-09-16T12:19:18.110Z |
5083313 | 5083313 | 20240911125405_9G6vg | AU001B | 2024-09-15T12:18:38.794Z | 2024-09-16T12:19:17.944Z |
5083267 | 5083267 | 20240911124021_iB6D6 | AU001B | 2024-09-15T12:18:37.920Z | 2024-09-16T12:19:17.660Z |
5083197 | 5083197 | 20240911122504_e3Smm | AU001B | 2024-09-15T12:18:36.781Z | 2024-09-16T12:19:17.194Z |
5082827 | 5082827 | 20240911110605_NOZUl | AU001B | 2024-09-15T12:18:26.645Z | 2024-09-16T12:19:14.774Z |
5072283 | 5072283 | 20240911195355_0pLsz | AU001B | 2024-09-15T12:05:05.880Z | 2024-09-16T12:17:29.058Z |
5072103 | 5072103 | 20240911193404_g03A9 | AU001B | 2024-09-15T12:04:39.767Z | 2024-09-16T12:17:29.025Z |
5072057 | 5072057 | 20240911192716_h032W | AU001B | 2024-09-15T12:04:33.709Z | 2024-09-16T12:17:29.014Z |
5072034 | 5072034 | 20240911192506_FWBIm | AU001B | 2024-09-15T12:04:29.497Z | 2024-09-16T12:17:29.009Z |
5071938 | 5071938 | 20240911190748_VS4nD | AU001B | 2024-09-15T12:04:04.762Z | 2024-09-16T12:17:28.984Z |
5071925 | 5071925 | 20240911190419_cTkPd | AU001B | 2024-09-15T12:04:02.471Z | 2024-09-16T12:17:28.981Z |
5071909 | 5071909 | 20240911185656_xzs50 | AU001B | 2024-09-15T12:03:59.988Z | 2024-09-16T12:17:28.976Z |
5071866 | 5071866 | 20240911184228_0oEyt | AU001B | 2024-09-15T12:03:52.871Z | 2024-09-16T12:17:28.963Z |
5071857 | 5071857 | 20240911183650_tFaFu | AU001B | 2024-09-15T12:03:51.368Z | 2024-09-16T12:17:28.960Z |
5071849 | 5071849 | 20240911183443_qkZ1L | AU001B | 2024-09-15T12:03:50.095Z | 2024-09-16T12:17:28.957Z |
5071833 | 5071833 | 20240911183328_xsn6D | AU001B | 2024-09-15T12:03:48.255Z | 2024-09-16T12:17:28.954Z |
5071810 | 5071810 | 20240911182545_La8da | AU001B | 2024-09-15T12:03:43.475Z | 2024-09-16T12:17:28.948Z |
5071790 | 5071790 | 20240911181955_1CDaT | AU001B | 2024-09-15T12:03:33.888Z | 2024-09-16T12:17:28.942Z |
5071786 | 5071786 | 20240911181925_5SpY0 | AU001B | 2024-09-15T12:03:32.980Z | 2024-09-16T12:17:28.941Z |
5071740 | 5071740 | 20240911180533_B2U37 | AU001B | 2024-09-15T12:03:22.723Z | 2024-09-16T12:17:28.917Z |
5071734 | 5071734 | 20240911180439_1DJjl | AU001B | 2024-09-15T12:03:21.829Z | 2024-09-16T12:17:28.916Z |
5071691 | 5071691 | 20240911175049_wvMFS | AU001B | 2024-09-15T12:03:15.955Z | 2024-09-16T12:17:28.897Z |
5071647 | 5071647 | 20240911173528_HYN7D | AU001B | 2024-09-15T12:03:10.035Z | 2024-09-16T12:17:28.887Z |
5071621 | 5071621 | 20240911173024_vzevG | AU001B | 2024-09-15T12:03:05.743Z | 2024-09-16T12:17:28.878Z |
5071589 | 5071589 | 20240911172303_WlNp0 | AU001B | 2024-09-15T12:03:01.751Z | 2024-09-16T12:17:28.870Z |
5071569 | 5071569 | 20240911171823_MO3ks | AU001B | 2024-09-15T12:02:59.474Z | 2024-09-16T12:17:28.866Z |
5071493 | 5071493 | 20240911170546_CpZML | AU001B | 2024-09-15T12:02:41.148Z | 2024-09-16T12:17:28.845Z |
5071488 | 5071488 | 20240911170219_oYtUM | AU001B | 2024-09-15T12:02:39.761Z | 2024-09-16T12:17:28.843Z |
5071453 | 5071453 | 20240911165721_i7Mzw | AU001B | 2024-09-15T12:02:35.504Z | 2024-09-16T12:17:28.833Z |
5071433 | 5071433 | 20240911165226_DdGr7 | AU001B | 2024-09-15T12:02:32.005Z | 2024-09-16T12:17:28.809Z |
5071375 | 5071375 | 20240911164318_cZr4N | AU001B | 2024-09-15T12:02:23.986Z | 2024-09-16T12:17:28.795Z |
5071328 | 5071328 | 20240911163420_9LkCL | AU001B | 2024-09-15T12:02:18.561Z | 2024-09-16T12:17:28.785Z |
5071210 | 5071210 | 20240911161541_2Jhwb | AU001B | 2024-09-15T12:01:54.438Z | 2024-09-16T12:17:28.759Z |
5071112 | 5071112 | 20240911160116_mChoq | AU001B | 2024-09-15T12:01:43.366Z | 2024-09-16T12:17:28.739Z |
5071091 | 5071091 | 20240911155946_1Bp2U | AU001B | 2024-09-15T12:01:38.189Z | 2024-09-16T12:17:28.731Z |
5070956 | 5070956 | 20240911153502_4UXjB | AU001B | 2024-09-15T12:01:14.436Z | 2024-09-16T12:17:28.700Z |
5070934 | 5070934 | 20240911153030_VbZhE | AU001B | 2024-09-15T12:01:11.318Z | 2024-09-16T12:17:28.694Z |
5070834 | 5070834 | 20240911151500_U5dvy | AU001B | 2024-09-15T12:00:58.606Z | 2024-09-16T12:17:28.673Z |
5070723 | 5070723 | 20240911150056_rFFp4 | AU001B | 2024-09-15T12:00:42.291Z | 2024-09-16T12:17:28.654Z |
5070690 | 5070690 | 20240911145533_jerJR | AU001B | 2024-09-15T12:00:35.653Z | 2024-09-16T12:17:28.645Z |
5070513 | 5070513 | 20240911142625_HOhq7 | AU001B | 2024-09-15T12:00:11.774Z | 2024-09-16T12:17:28.609Z |
5069073 | 5069073 | 20240910134008_joohS | AU001B | 2024-09-14T12:19:25.193Z | 2024-09-16T12:20:16.381Z |
5069039 | 5069039 | 20240910132852_9lxMX | AU001B | 2024-09-14T12:19:24.456Z | 2024-09-16T12:20:16.221Z |
5068743 | 5068743 | 20240910121645_yBoqW | AU001B | 2024-09-14T12:19:20.988Z | 2024-09-16T12:20:14.956Z |
5068402 | 5068402 | 20240910112712_Dpnmo | AU001B | 2024-09-14T12:19:14.095Z | 2024-09-16T12:20:13.811Z |
5060928 | 5060928 | 20240909132748_lnzxV | AU001B | 2024-09-14T12:09:56.326Z | 2024-09-16T12:19:28.284Z |
5060860 | 5060860 | 20240909130714_tMLpL | AU001B | 2024-09-14T12:09:50.319Z | 2024-09-16T12:19:27.776Z |
5059682 | 5059682 | 20240910183121_b5T5A | AU001B | 2024-09-14T12:06:45.176Z | 2024-09-16T12:18:07.499Z |
5059215 | 5059215 | 20240910172356_23rTz | AU001B | 2024-09-14T12:05:27.066Z | 2024-09-16T12:18:02.786Z |
5058607 | 5058607 | 20240910163100_H14Gc | AU001B | 2024-09-14T12:04:08.021Z | 2024-09-16T12:17:56.444Z |
5058493 | 5058493 | 20240910161630_s27Q2 | AU001B | 2024-09-14T12:03:47.364Z | 2024-09-16T12:17:55.314Z |
5057489 | 5057489 | 20240910143523_eatxB | AU001B | 2024-09-14T12:01:12.761Z | 2024-09-16T12:17:44.514Z |
5057483 | 5057483 | 20240910143359_KIizN | AU001B | 2024-09-14T12:01:11.300Z | 2024-09-16T12:17:44.451Z |
5057471 | 5057471 | 20240910143257_uC2EK | AU001B | 2024-09-14T12:01:08.363Z | 2024-09-16T12:17:44.260Z |
5057383 | 5057383 | 20240910141922_kWzES | AU001B | 2024-09-14T12:00:58.170Z | 2024-09-16T12:17:43.462Z |
5057148 | 5057148 | 20240910134814_N21eO | AU001B | 2024-09-14T12:00:20.492Z | 2024-09-16T12:17:39.288Z |
5056785 | 5056785 | 20240908112708_h7kez | AU001B | 2024-09-13T12:17:39.378Z | 2024-09-16T12:21:27.299Z |
5050069 | 5050069 | 20240909123852_SRFfo | AU001B | 2024-09-13T12:12:38.689Z | 2024-09-16T12:20:45.363Z |
5049996 | 5049996 | 20240909121653_D8cCC | AU001B | 2024-09-13T12:12:35.452Z | 2024-09-16T12:20:45.049Z |
5049943 | 5049943 | 20240909120209_ZVzXh | AU001B | 2024-09-13T12:12:32.973Z | 2024-09-16T12:20:44.886Z |
5049797 | 5049797 | 20240909114149_d5RFN | AU001B | 2024-09-13T12:12:26.883Z | 2024-09-16T12:20:44.191Z |
5045950 | 5045950 | 20240908201647_aS39G | AU001B | 2024-09-13T12:05:26.565Z | 2024-09-16T12:20:28.140Z |
5045941 | 5045941 | 20240908201530_oATPm | AU001B | 2024-09-13T12:05:25.375Z | 2024-09-16T12:20:28.121Z |
5044875 | 5044875 | 20240908155215_JYH6R | AU001B | 2024-09-13T12:03:05.634Z | 2024-09-16T12:20:23.748Z |
5044612 | 5044612 | 20240908152154_BjVjU | AU001B | 2024-09-13T12:02:33.011Z | 2024-09-16T12:20:22.826Z |
5044483 | 5044483 | 20240908150535_CU3Rc | AU001B | 2024-09-13T12:02:15.505Z | 2024-09-16T12:20:22.319Z |
5044390 | 5044390 | 20240908145517_d1AAG | AU001B | 2024-09-13T12:02:06.255Z | 2024-09-16T12:20:21.834Z |
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);