participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,211 rows where station_code = "DE0007" 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 |
---|---|---|---|---|---|
5484413 | 5484413 | 20241105024745_aA6VJ | DE0007 | 2024-11-06T14:16:53.285Z | 2024-11-08T14:18:42.864Z |
5483881 | 5483881 | 20241105014024_lpnKX | DE0007 | 2024-11-06T14:15:49.573Z | 2024-11-08T14:18:39.900Z |
5483062 | 5483062 | 20241104235249_StyUM | DE0007 | 2024-11-06T14:14:37.418Z | 2024-11-08T14:18:32.640Z |
5482195 | 5482195 | 20241104212405_iFRp3 | DE0007 | 2024-11-06T14:12:34.870Z | 2024-11-08T14:18:18.419Z |
5482068 | 5482068 | 20241104210003_lyxNY | DE0007 | 2024-11-06T14:12:20.152Z | 2024-11-08T14:18:16.602Z |
5482041 | 5482041 | 20241104205617_EpJ9T | DE0007 | 2024-11-06T14:12:17.256Z | 2024-11-08T14:18:16.167Z |
5478670 | 5478670 | 20241104045745_yl0gC | DE0007 | 2024-11-05T14:18:39.732Z | 2024-11-08T14:20:16.142Z |
5478496 | 5478496 | 20241104041818_pDJi3 | DE0007 | 2024-11-05T14:18:25.852Z | 2024-11-08T14:20:13.905Z |
5477145 | 5477145 | 20241104010816_czJ17 | DE0007 | 2024-11-05T14:16:26.901Z | 2024-11-08T14:20:01.082Z |
5476618 | 5476618 | 20241103235439_ntUAd | DE0007 | 2024-11-05T14:15:45.431Z | 2024-11-08T14:19:54.364Z |
5476442 | 5476442 | 20241103232720_vBK4F | DE0007 | 2024-11-05T14:15:24.290Z | 2024-11-08T14:19:52.742Z |
5476002 | 5476002 | 20241103220618_hN5mx | DE0007 | 2024-11-05T14:14:38.599Z | 2024-11-08T14:19:47.830Z |
5475922 | 5475922 | 20241103215146_3JHvb | DE0007 | 2024-11-05T14:14:33.557Z | 2024-11-08T14:19:46.584Z |
5475609 | 5475609 | 20241103204947_KVweC | DE0007 | 2024-11-05T14:13:52.927Z | 2024-11-08T14:19:42.134Z |
5475341 | 5475341 | 20241103195033_wnC0u | DE0007 | 2024-11-05T14:13:12.751Z | 2024-11-08T14:19:38.832Z |
5474478 | 5474478 | 20241103172755_KHEHP | DE0007 | 2024-11-05T14:11:08.254Z | 2024-11-08T14:19:26.377Z |
5433778 | 5433778 | 20241024230720_M3viD | DE0007 | 2024-10-31T12:28:26.256Z | 2024-11-02T12:28:29.978Z |
5433776 | 5433776 | 20241024221202_IGvzq | DE0007 | 2024-10-31T12:28:23.345Z | 2024-11-02T12:28:29.355Z |
5433773 | 5433773 | 20241024205758_vOwZd | DE0007 | 2024-10-31T12:28:20.483Z | 2024-11-02T12:28:27.747Z |
5433771 | 5433771 | 20241024203231_AR9gK | DE0007 | 2024-10-31T12:28:19.340Z | 2024-11-02T12:28:27.535Z |
5433753 | 5433753 | 20241027222600_ou85T | DE0007 | 2024-10-31T12:24:19.784Z | 2024-11-05T14:27:11.757Z |
5433577 | 5433577 | 20241029202508_7fVO0 | DE0007 | 2024-10-31T12:22:22.772Z | 2024-11-07T14:26:40.227Z |
5432390 | 5432390 | 20241029032540_QddIc | DE0007 | 2024-10-31T12:21:20.562Z | 2024-11-06T14:27:26.801Z |
5431858 | 5431858 | 20241029020717_bX9Le | DE0007 | 2024-10-31T12:20:44.956Z | 2024-11-06T14:27:25.122Z |
5431588 | 5431588 | 20241029013621_4NRXG | DE0007 | 2024-10-31T12:20:23.441Z | 2024-11-06T14:27:24.111Z |
5420107 | 5420107 | 20241028015856_Hx1l0 | DE0007 | 2024-10-30T12:18:20.784Z | 2024-11-05T14:27:14.502Z |
5419148 | 5419148 | 20241027230736_2oSyP | DE0007 | 2024-10-30T12:17:11.890Z | 2024-11-05T14:27:12.436Z |
5419081 | 5419081 | 20241027225727_w9KTL | DE0007 | 2024-10-30T12:17:07.988Z | 2024-11-05T14:27:12.337Z |
5418551 | 5418551 | 20241027211010_SN1As | DE0007 | 2024-10-30T12:15:49.489Z | 2024-11-05T14:27:10.553Z |
5402976 | 5402976 | 20241026205535_70xca | DE0007 | 2024-10-29T12:08:41.541Z | 2024-11-04T14:28:47.225Z |
5401902 | 5401902 | 20241026180314_tLaMV | DE0007 | 2024-10-29T12:05:46.897Z | 2024-11-04T14:28:40.853Z |
5397340 | 5397340 | 20241026011944_3KthT | DE0007 | 2024-10-28T12:18:17.419Z | 2024-11-03T14:27:32.711Z |
5397134 | 5397134 | 20241026010405_YwGnL | DE0007 | 2024-10-28T12:18:08.927Z | 2024-11-03T14:27:32.066Z |
5397101 | 5397101 | 20241026010204_6oTC7 | DE0007 | 2024-10-28T12:18:08.108Z | 2024-11-03T14:27:32.026Z |
5395171 | 5395171 | 20241025221724_lMr2K | DE0007 | 2024-10-28T12:15:59.997Z | 2024-11-03T14:27:24.156Z |
5394376 | 5394376 | 20241025202347_kZ90t | DE0007 | 2024-10-28T12:14:31.990Z | 2024-11-03T14:27:21.046Z |
5388354 | 5388354 | 20241025043758_aqaCU | DE0007 | 2024-10-27T12:22:10.637Z | 2024-11-02T12:28:33.974Z |
5386206 | 5386206 | 20241025001356_2cZ19 | DE0007 | 2024-10-27T12:19:54.893Z | 2024-11-02T12:28:30.839Z |
5385779 | 5385779 | 20241024232939_OzPSy | DE0007 | 2024-10-27T12:19:22.904Z | 2024-10-30T12:25:08.089Z |
5378479 | 5378479 | 20241022230655_kzL2r | DE0007 | 2024-10-26T12:24:49.623Z | 2024-10-31T12:29:59.608Z |
5366731 | 5366731 | 20241023035331_RAFhh | DE0007 | 2024-10-25T12:21:28.574Z | 2024-10-31T12:30:08.085Z |
5364627 | 5364627 | 20241023224338_5B7nZ | DE0007 | 2024-10-25T12:17:26.982Z | 2024-11-01T12:26:55.252Z |
5364373 | 5364373 | 20241023222356_KW4Rb | DE0007 | 2024-10-25T12:17:18.841Z | 2024-11-01T12:26:55.023Z |
5363885 | 5363885 | 20241023215518_OQ6C4 | DE0007 | 2024-10-25T12:16:58.251Z | 2024-11-01T12:26:54.023Z |
5363667 | 5363667 | 20241023213445_jqufm | DE0007 | 2024-10-25T12:16:34.165Z | 2024-11-01T12:26:53.489Z |
5363492 | 5363492 | 20241023211244_cM0sH | DE0007 | 2024-10-25T12:16:16.165Z | 2024-11-01T12:26:53.323Z |
5363255 | 5363255 | 20241023204014_Yr4Z8 | DE0007 | 2024-10-25T12:15:47.179Z | 2024-11-01T12:26:53.003Z |
5361023 | 5361023 | 20241023174158_JzUKm | DE0007 | 2024-10-25T12:12:09.693Z | 2024-11-01T12:26:48.675Z |
5356057 | 5356057 | 20241023045308_DHcEr | DE0007 | 2024-10-24T12:21:49.084Z | 2024-10-31T12:30:09.734Z |
5355812 | 5355812 | 20241023042143_MUJxC | DE0007 | 2024-10-24T12:21:37.671Z | 2024-10-31T12:30:08.929Z |
5354068 | 5354068 | 20241023020207_8tS7O | DE0007 | 2024-10-24T12:20:13.118Z | 2024-10-31T12:30:05.312Z |
5353814 | 5353814 | 20241023014941_wqjO1 | DE0007 | 2024-10-24T12:19:57.252Z | 2024-10-31T12:30:04.848Z |
5353557 | 5353557 | 20241023013105_AAyYB | DE0007 | 2024-10-24T12:19:46.548Z | 2024-10-31T12:30:04.365Z |
5352940 | 5352940 | 20241023005737_3rTfc | DE0007 | 2024-10-24T12:19:27.082Z | 2024-10-31T12:30:03.555Z |
5352450 | 5352450 | 20241023003311_qjdZG | DE0007 | 2024-10-24T12:18:48.637Z | 2024-10-31T12:30:02.647Z |
5350504 | 5350504 | 20241022215702_RCfc3 | DE0007 | 2024-10-24T12:15:51.205Z | 2024-10-31T12:29:58.358Z |
5349927 | 5349927 | 20241022204932_KywuB | DE0007 | 2024-10-24T12:14:49.052Z | 2024-10-31T12:29:56.971Z |
5348483 | 5348483 | 20241022182206_ZmvrI | DE0007 | 2024-10-24T12:11:30.211Z | 2024-10-31T12:29:52.777Z |
5327831 | 5327831 | 20241020041137_KxWNG | DE0007 | 2024-10-21T12:13:12.516Z | 2024-10-28T12:26:46.884Z |
5327781 | 5327781 | 20241020034947_LoNlo | DE0007 | 2024-10-21T12:13:07.543Z | 2024-10-28T12:26:46.744Z |
5318123 | 5318123 | 20241016213135_KCcI7 | DE0007 | 2024-10-18T12:02:57.161Z | 2024-10-25T12:24:33.355Z |
5318047 | 5318047 | 20241016181427_vX8U4 | DE0007 | 2024-10-18T12:02:37.478Z | 2024-10-25T12:24:32.869Z |
5303439 | 5303439 | 20241013030010_Prwe4 | DE0007 | 2024-10-14T12:17:24.667Z | 2024-10-21T12:24:17.979Z |
5294449 | 5294449 | 20241012041222_xCEwP | DE0007 | 2024-10-13T12:18:37.618Z | 2024-10-20T12:25:13.155Z |
5294183 | 5294183 | 20241012031926_ZwlFF | DE0007 | 2024-10-13T12:18:22.788Z | 2024-10-20T12:25:08.869Z |
5294070 | 5294070 | 20241012025622_AO4lH | DE0007 | 2024-10-13T12:18:13.873Z | 2024-10-20T12:25:06.901Z |
5293997 | 5293997 | 20241012024725_Wm3mK | DE0007 | 2024-10-13T12:18:06.829Z | 2024-10-20T12:25:05.966Z |
5293219 | 5293219 | 20241012010622_cBb79 | DE0007 | 2024-10-13T12:17:12.474Z | 2024-10-20T12:24:56.699Z |
5290710 | 5290710 | 20241011184253_EwY0A | DE0007 | 2024-10-13T12:13:09.535Z | 2024-10-20T12:24:19.204Z |
5285679 | 5285679 | 20241012043540_i3dMy | DE0007 | 2024-10-13T12:00:18.458Z | 2024-10-21T12:22:40.601Z |
5247426 | 5247426 | 20241005020447_zymLR | DE0007 | 2024-10-07T12:18:55.016Z | 2024-10-13T12:26:26.265Z |
5246761 | 5246761 | 20241006022735_fUHsg | DE0007 | 2024-10-07T12:16:38.802Z | 2024-10-14T12:24:38.906Z |
5246465 | 5246465 | 20241006014850_bgMJN | DE0007 | 2024-10-07T12:16:27.227Z | 2024-10-14T12:24:37.976Z |
5246342 | 5246342 | 20241006013542_DC3ms | DE0007 | 2024-10-07T12:16:23.688Z | 2024-10-14T12:24:37.808Z |
5246226 | 5246226 | 20241006011855_7uAWQ | DE0007 | 2024-10-07T12:16:18.789Z | 2024-10-14T12:24:37.470Z |
5246071 | 5246071 | 20241006005332_po7gC | DE0007 | 2024-10-07T12:16:11.148Z | 2024-10-14T12:24:37.133Z |
5245977 | 5245977 | 20241006003900_HxT9F | DE0007 | 2024-10-07T12:16:06.791Z | 2024-10-14T12:24:36.982Z |
5244667 | 5244667 | 20241005204345_3U1Az | DE0007 | 2024-10-07T12:15:07.380Z | 2024-10-14T12:24:34.127Z |
5244552 | 5244552 | 20241005202203_Du5Xv | DE0007 | 2024-10-07T12:15:00.836Z | 2024-10-14T12:24:33.806Z |
5244228 | 5244228 | 20241005193337_z2Lc2 | DE0007 | 2024-10-07T12:14:37.826Z | 2024-10-14T12:24:33.072Z |
5239160 | 5239160 | 20241005033445_EC31D | DE0007 | 2024-10-07T12:06:01.141Z | 2024-10-14T12:24:18.479Z |
5238939 | 5238939 | 20241005031419_p8Nak | DE0007 | 2024-10-07T12:05:29.589Z | 2024-10-14T12:24:17.682Z |
5238614 | 5238614 | 20241005024605_Ka1cJ | DE0007 | 2024-10-07T12:04:44.799Z | 2024-10-14T12:24:16.880Z |
5237283 | 5237283 | 20241006033826_3f7ce | DE0007 | 2024-10-07T12:01:07.062Z | 2024-10-15T12:28:41.145Z |
5235689 | 5235689 | 20241004235539_zF2PI | DE0007 | 2024-10-06T12:16:22.715Z | 2024-10-13T12:26:24.446Z |
5235524 | 5235524 | 20241004234109_aM52s | DE0007 | 2024-10-06T12:16:09.021Z | 2024-10-13T12:26:24.313Z |
5235236 | 5235236 | 20241004230932_ZdM6n | DE0007 | 2024-10-06T12:15:56.427Z | 2024-10-13T12:26:24.066Z |
5234811 | 5234811 | 20241004221617_AqPSN | DE0007 | 2024-10-06T12:15:22.682Z | 2024-10-13T12:26:22.833Z |
5209956 | 5209956 | 20241001180913_efxgl | DE0007 | 2024-10-03T12:14:05.905Z | 2024-10-10T12:24:44.465Z |
5194838 | 5194838 | 20240930030912_3g3xy | DE0007 | 2024-10-01T12:02:21.434Z | 2024-10-09T12:29:01.109Z |
5192931 | 5192931 | 20240928233534_E2vV8 | DE0007 | 2024-09-30T12:19:00.064Z | 2024-10-06T12:28:26.609Z |
5192416 | 5192416 | 20240928223626_cJIEE | DE0007 | 2024-09-30T12:18:40.484Z | 2024-10-06T12:28:25.692Z |
5191948 | 5191948 | 20240928211455_FYfDb | DE0007 | 2024-09-30T12:18:17.418Z | 2024-10-06T12:28:24.582Z |
5186393 | 5186393 | 20240929035610_RttHE | DE0007 | 2024-09-30T12:06:44.750Z | 2024-10-07T12:21:20.483Z |
5186304 | 5186304 | 20240929034620_HpZht | DE0007 | 2024-09-30T12:06:34.642Z | 2024-10-07T12:21:20.171Z |
5185768 | 5185768 | 20240929025230_fRlaK | DE0007 | 2024-09-30T12:05:02.847Z | 2024-10-07T12:21:18.810Z |
5185585 | 5185585 | 20240929023706_lKrrm | DE0007 | 2024-09-30T12:04:37.135Z | 2024-10-07T12:21:18.505Z |
5185513 | 5185513 | 20240929022935_Moe7u | DE0007 | 2024-09-30T12:04:24.135Z | 2024-10-07T12:21:18.287Z |
5185315 | 5185315 | 20240929021550_7EsyU | DE0007 | 2024-09-30T12:04:02.385Z | 2024-10-07T12:21:17.582Z |
5181287 | 5181287 | 20240927203033_E3H87 | DE0007 | 2024-09-29T12:14:53.548Z | 2024-10-05T12:29:05.297Z |
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);