participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,399 rows where station_code = "CA000Y" 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 |
---|---|---|---|---|---|
5122447 | 5122447 | 20240914062606_lQ3Dc | CA000Y | 2024-09-18T12:11:19.344Z | 2024-09-19T12:20:04.396Z |
5122401 | 5122401 | 20240914060834_1D5a3 | CA000Y | 2024-09-18T12:11:17.394Z | 2024-09-19T12:20:04.184Z |
5122335 | 5122335 | 20240914054202_dywR9 | CA000Y | 2024-09-18T12:11:14.742Z | 2024-09-19T12:20:03.947Z |
5122269 | 5122269 | 20240914051744_cwbDm | CA000Y | 2024-09-18T12:11:12.102Z | 2024-09-19T12:20:03.562Z |
5122185 | 5122185 | 20240914044654_TWOxB | CA000Y | 2024-09-18T12:11:08.865Z | 2024-09-19T12:20:02.948Z |
5122093 | 5122093 | 20240914043223_nQ7VJ | CA000Y | 2024-09-18T12:11:06.805Z | 2024-09-19T12:20:02.757Z |
5121712 | 5121712 | 20240914041226_XPUKP | CA000Y | 2024-09-18T12:10:59.915Z | 2024-09-19T12:20:02.266Z |
5097767 | 5097767 | 20240913010223_FPni1 | CA000Y | 2024-09-16T12:17:14.869Z | 2024-09-19T12:20:38.975Z |
5093908 | 5093908 | 20240912034023_lFJ4T | CA000Y | 2024-09-16T12:14:27.502Z | 2024-09-19T12:21:15.735Z |
5081273 | 5081273 | 20240911070958_8Ib7Y | CA000Y | 2024-09-15T12:17:28.916Z | 2024-09-19T12:21:44.976Z |
5081162 | 5081162 | 20240911064324_L96T6 | CA000Y | 2024-09-15T12:17:25.316Z | 2024-09-19T12:21:44.685Z |
5080946 | 5080946 | 20240911053140_a0r6J | CA000Y | 2024-09-15T12:17:18.006Z | 2024-09-19T12:21:44.106Z |
5080843 | 5080843 | 20240911050412_ULSNu | CA000Y | 2024-09-15T12:17:15.543Z | 2024-09-19T12:21:43.876Z |
5078179 | 5078179 | 20240911014228_FRl4A | CA000Y | 2024-09-15T12:15:22.679Z | 2024-09-19T12:21:40.048Z |
5041647 | 5041647 | 20240906084428_vcWXT | CA000Y | 2024-09-12T12:16:46.216Z | 2024-09-14T12:23:14.265Z |
5041642 | 5041642 | 20240906084340_iHDh2 | CA000Y | 2024-09-12T12:16:46.135Z | 2024-09-14T12:23:14.262Z |
5041313 | 5041313 | 20240906075430_zFyCD | CA000Y | 2024-09-12T12:16:38.552Z | 2024-09-14T12:23:12.626Z |
5041193 | 5041193 | 20240906073348_q71LK | CA000Y | 2024-09-12T12:16:35.398Z | 2024-09-14T12:23:11.968Z |
5040978 | 5040978 | 20240906065030_ETaCP | CA000Y | 2024-09-12T12:16:30.966Z | 2024-09-14T12:23:11.136Z |
5040941 | 5040941 | 20240906063453_PePpZ | CA000Y | 2024-09-12T12:16:28.947Z | 2024-09-14T12:23:11.057Z |
5040897 | 5040897 | 20240906062442_a2vUB | CA000Y | 2024-09-12T12:16:28.038Z | 2024-09-14T12:23:10.954Z |
5040877 | 5040877 | 20240906061758_HwwWR | CA000Y | 2024-09-12T12:16:27.381Z | 2024-09-14T12:23:10.801Z |
5040634 | 5040634 | 20240906051307_relAB | CA000Y | 2024-09-12T12:16:18.198Z | 2024-09-14T12:23:10.135Z |
5040623 | 5040623 | 20240906050721_wmDF9 | CA000Y | 2024-09-12T12:16:17.764Z | 2024-09-14T12:23:10.127Z |
5040544 | 5040544 | 20240906044433_c79Ci | CA000Y | 2024-09-12T12:16:15.658Z | 2024-09-14T12:23:09.879Z |
5040494 | 5040494 | 20240906042935_f29hu | CA000Y | 2024-09-12T12:16:13.194Z | 2024-09-14T12:23:09.557Z |
5040490 | 5040490 | 20240906042836_AHfgo | CA000Y | 2024-09-12T12:16:13.034Z | 2024-09-14T12:23:09.554Z |
5040450 | 5040450 | 20240906041635_jIZeW | CA000Y | 2024-09-12T12:16:11.733Z | 2024-09-14T12:23:09.271Z |
5040417 | 5040417 | 20240906040712_gPMSF | CA000Y | 2024-09-12T12:16:10.589Z | 2024-09-14T12:23:09.112Z |
5040330 | 5040330 | 20240906034441_3CBrx | CA000Y | 2024-09-12T12:16:06.711Z | 2024-09-14T12:23:08.756Z |
5040305 | 5040305 | 20240906033853_DsbPM | CA000Y | 2024-09-12T12:16:06.119Z | 2024-09-14T12:23:08.675Z |
5040248 | 5040248 | 20240906032144_0Sk6z | CA000Y | 2024-09-12T12:16:04.198Z | 2024-09-14T12:23:08.476Z |
5039884 | 5039884 | 20240906021838_ujnDB | CA000Y | 2024-09-12T12:15:48.661Z | 2024-09-14T12:23:05.743Z |
5039853 | 5039853 | 20240906021016_vc24w | CA000Y | 2024-09-12T12:15:47.690Z | 2024-09-14T12:23:05.392Z |
5039840 | 5039840 | 20240906020735_a3Qxe | CA000Y | 2024-09-12T12:15:47.226Z | 2024-09-14T12:23:05.317Z |
5039657 | 5039657 | 20240906014637_RKog8 | CA000Y | 2024-09-12T12:15:41.393Z | 2024-09-14T12:23:03.903Z |
5039638 | 5039638 | 20240906014137_nU9uO | CA000Y | 2024-09-12T12:15:40.944Z | 2024-09-14T12:23:03.871Z |
5039611 | 5039611 | 20240906013409_XtCyE | CA000Y | 2024-09-12T12:15:38.801Z | 2024-09-14T12:23:03.726Z |
5039389 | 5039389 | 20240906004119_FgDHV | CA000Y | 2024-09-12T12:15:29.001Z | 2024-09-14T12:23:01.797Z |
5035056 | 5035056 | 20240907083831_YH6uj | CA000Y | 2024-09-12T12:11:50.725Z | 2024-09-15T12:21:38.023Z |
5034553 | 5034553 | 20240907071844_prkmn | CA000Y | 2024-09-12T12:11:02.927Z | 2024-09-15T12:21:35.218Z |
5034545 | 5034545 | 20240907071648_KEDg3 | CA000Y | 2024-09-12T12:11:01.841Z | 2024-09-15T12:21:35.181Z |
5034297 | 5034297 | 20240907062532_GM42Q | CA000Y | 2024-09-12T12:10:49.534Z | 2024-09-15T12:21:33.574Z |
5034195 | 5034195 | 20240907060116_a2z5x | CA000Y | 2024-09-12T12:10:44.466Z | 2024-09-15T12:21:33.063Z |
5034162 | 5034162 | 20240907054715_8Kq2u | CA000Y | 2024-09-12T12:10:41.707Z | 2024-09-15T12:21:32.970Z |
5034144 | 5034144 | 20240907054422_gBgJM | CA000Y | 2024-09-12T12:10:39.976Z | 2024-09-15T12:21:32.909Z |
5034027 | 5034027 | 20240907050008_A8B5P | CA000Y | 2024-09-12T12:10:24.445Z | 2024-09-15T12:21:32.616Z |
5033982 | 5033982 | 20240907044932_3YzHH | CA000Y | 2024-09-12T12:10:17.304Z | 2024-09-15T12:21:32.525Z |
5033805 | 5033805 | 20240907035502_dhTi9 | CA000Y | 2024-09-12T12:09:59.117Z | 2024-09-15T12:21:31.822Z |
5033757 | 5033757 | 20240907034305_bqmrU | CA000Y | 2024-09-12T12:09:55.665Z | 2024-09-15T12:21:31.692Z |
5033582 | 5033582 | 20240907031353_H32c6 | CA000Y | 2024-09-12T12:09:42.179Z | 2024-09-15T12:21:30.551Z |
5033396 | 5033396 | 20240907025502_4aJNr | CA000Y | 2024-09-12T12:09:26.706Z | 2024-09-15T12:21:29.995Z |
5032810 | 5032810 | 20240907015049_RhTNj | CA000Y | 2024-09-12T12:08:06.015Z | 2024-09-15T12:21:27.972Z |
5032681 | 5032681 | 20240907012925_FsUfu | CA000Y | 2024-09-12T12:07:51.214Z | 2024-09-15T12:21:27.419Z |
5032648 | 5032648 | 20240907012540_oIXOV | CA000Y | 2024-09-12T12:07:48.164Z | 2024-09-15T12:21:27.283Z |
5032598 | 5032598 | 20240907011912_jYdhv | CA000Y | 2024-09-12T12:07:43.822Z | 2024-09-15T12:21:27.010Z |
5027399 | 5027399 | 20240905073322_Qq5jq | CA000Y | 2024-09-11T12:14:08.508Z | 2024-09-13T12:20:02.500Z |
5027120 | 5027120 | 20240905064825_wWG74 | CA000Y | 2024-09-11T12:13:42.791Z | 2024-09-13T12:20:01.447Z |
5027107 | 5027107 | 20240905064507_8fDQy | CA000Y | 2024-09-11T12:13:41.110Z | 2024-09-13T12:20:01.416Z |
5027009 | 5027009 | 20240905061807_xa3pd | CA000Y | 2024-09-11T12:13:31.922Z | 2024-09-13T12:20:00.946Z |
5026980 | 5026980 | 20240905061141_Q3cgF | CA000Y | 2024-09-11T12:13:27.447Z | 2024-09-13T12:20:00.673Z |
5026859 | 5026859 | 20240905054341_47bA2 | CA000Y | 2024-09-11T12:13:15.421Z | 2024-09-13T12:20:00.089Z |
5026802 | 5026802 | 20240905052652_Qy38Z | CA000Y | 2024-09-11T12:13:09.391Z | 2024-09-13T12:19:59.786Z |
5026738 | 5026738 | 20240905050324_gSuTT | CA000Y | 2024-09-11T12:13:02.513Z | 2024-09-13T12:19:59.591Z |
5026646 | 5026646 | 20240905043911_tEAsQ | CA000Y | 2024-09-11T12:12:51.495Z | 2024-09-13T12:19:59.124Z |
5026589 | 5026589 | 20240905042426_zSan2 | CA000Y | 2024-09-11T12:12:46.713Z | 2024-09-13T12:19:58.985Z |
5026393 | 5026393 | 20240905031906_7opD6 | CA000Y | 2024-09-11T12:12:25.259Z | 2024-09-13T12:19:57.996Z |
5026353 | 5026353 | 20240905030953_7Ic06 | CA000Y | 2024-09-11T12:12:20.249Z | 2024-09-13T12:19:57.782Z |
5025771 | 5025771 | 20240905011248_Bu2k6 | CA000Y | 2024-09-11T12:10:59.392Z | 2024-09-13T12:19:55.573Z |
5025767 | 5025767 | 20240905011220_boBUT | CA000Y | 2024-09-11T12:10:58.539Z | 2024-09-13T12:19:55.558Z |
5025560 | 5025560 | 20240906021838_0uggN | CA000Y | 2024-09-11T12:06:50.596Z | 2024-09-11T12:16:32.688Z |
5025525 | 5025525 | 20240906021016_7H5mg | CA000Y | 2024-09-11T12:06:46.864Z | 2024-09-11T12:16:32.671Z |
5025510 | 5025510 | 20240906020735_2e3v8 | CA000Y | 2024-09-11T12:06:44.267Z | 2024-09-14T12:23:05.316Z |
5025318 | 5025318 | 20240906014637_69u3g | CA000Y | 2024-09-11T12:06:13.127Z | 2024-09-11T12:16:32.576Z |
5025302 | 5025302 | 20240906014137_fzX9w | CA000Y | 2024-09-11T12:06:11.223Z | 2024-09-11T12:16:32.569Z |
5025270 | 5025270 | 20240906013409_90i2V | CA000Y | 2024-09-11T12:06:06.861Z | 2024-09-11T12:16:32.551Z |
5025022 | 5025022 | 20240906004119_65tM8 | CA000Y | 2024-09-11T12:05:26.755Z | 2024-09-11T12:16:32.435Z |
5021853 | 5021853 | 20240905073322_3yU3t | CA000Y | 2024-09-10T12:15:54.077Z | 2024-09-10T12:16:55.449Z |
5021576 | 5021576 | 20240905064825_b3KR1 | CA000Y | 2024-09-10T12:15:41.725Z | 2024-09-10T12:16:55.401Z |
5021563 | 5021563 | 20240905064507_CsEU8 | CA000Y | 2024-09-10T12:15:41.085Z | 2024-09-10T12:16:55.398Z |
5021465 | 5021465 | 20240905061807_0qYWW | CA000Y | 2024-09-10T12:15:34.858Z | 2024-09-10T12:16:55.380Z |
5021438 | 5021438 | 20240905061141_G4ii4 | CA000Y | 2024-09-10T12:15:33.142Z | 2024-09-10T12:16:55.373Z |
5021321 | 5021321 | 20240905054341_RGYLc | CA000Y | 2024-09-10T12:15:24.686Z | 2024-09-10T12:16:55.352Z |
5021264 | 5021264 | 20240905052652_nFgSR | CA000Y | 2024-09-10T12:15:22.691Z | 2024-09-10T12:16:55.340Z |
5021198 | 5021198 | 20240905050324_s0qE6 | CA000Y | 2024-09-10T12:15:20.767Z | 2024-09-10T12:16:55.329Z |
5021104 | 5021104 | 20240905043911_zRVC2 | CA000Y | 2024-09-10T12:15:14.810Z | 2024-09-10T12:16:55.311Z |
5021049 | 5021049 | 20240905042426_6Xwkh | CA000Y | 2024-09-10T12:15:12.740Z | 2024-09-10T12:16:55.300Z |
5020849 | 5020849 | 20240905031906_q9Rt9 | CA000Y | 2024-09-10T12:15:04.582Z | 2024-09-10T12:16:55.256Z |
5020807 | 5020807 | 20240905030953_Dperp | CA000Y | 2024-09-10T12:15:02.481Z | 2024-09-10T12:16:55.246Z |
5020190 | 5020190 | 20240905011248_IeB3O | CA000Y | 2024-09-10T12:14:03.160Z | 2024-09-10T12:16:55.093Z |
5020186 | 5020186 | 20240905011220_c0KgE | CA000Y | 2024-09-10T12:14:02.792Z | 2024-09-10T12:16:55.092Z |
5013214 | 5013214 | 20240903083520_tSHEe | CA000Y | 2024-09-09T12:18:30.219Z | 2024-09-11T12:21:20.217Z |
5013190 | 5013190 | 20240903083226_j7Ta0 | CA000Y | 2024-09-09T12:18:29.568Z | 2024-09-11T12:21:20.144Z |
5013075 | 5013075 | 20240903081859_PZw2z | CA000Y | 2024-09-09T12:18:26.426Z | 2024-09-11T12:21:19.767Z |
5012932 | 5012932 | 20240903075850_1EK84 | CA000Y | 2024-09-09T12:18:21.625Z | 2024-09-11T12:21:19.366Z |
5012781 | 5012781 | 20240903073208_Z3BLX | CA000Y | 2024-09-09T12:18:16.308Z | 2024-09-11T12:21:18.765Z |
5001600 | 5001600 | 20240902055152_PYwje | CA000Y | 2024-09-08T12:16:41.257Z | 2024-09-10T12:19:33.703Z |
5001598 | 5001598 | 20240902055101_BosiA | CA000Y | 2024-09-08T12:16:40.845Z | 2024-09-10T12:19:33.702Z |
5001246 | 5001246 | 20240902040016_XPCN0 | CA000Y | 2024-09-08T12:16:16.476Z | 2024-09-10T12:19:32.511Z |
5001063 | 5001063 | 20240902032810_pH4Vh | CA000Y | 2024-09-08T12:16:08.176Z | 2024-09-10T12:19:31.405Z |
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);