participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,946 rows where station_code = "NZ001N" 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 |
---|---|---|---|---|---|
5083344 | 5083344 | 20240911130012_RnmXq | NZ001N | 2024-09-15T12:18:39.965Z | 2024-09-19T12:21:49.491Z |
5071259 | 5071259 | 20240911162327_Bcrsb | NZ001N | 2024-09-15T12:02:04.173Z | 2024-09-19T12:21:01.327Z |
5071202 | 5071202 | 20240911161528_V6WcU | NZ001N | 2024-09-15T12:01:53.450Z | 2024-09-19T12:21:01.209Z |
5071065 | 5071065 | 20240911155501_sJyc0 | NZ001N | 2024-09-15T12:01:34.962Z | 2024-09-19T12:21:00.851Z |
5070795 | 5070795 | 20240911151111_i28M5 | NZ001N | 2024-09-15T12:00:52.208Z | 2024-09-19T12:21:00.308Z |
5070782 | 5070782 | 20240911151059_cZbZH | NZ001N | 2024-09-15T12:00:49.758Z | 2024-09-19T12:21:00.273Z |
5070755 | 5070755 | 20240911150641_bNUZm | NZ001N | 2024-09-15T12:00:46.363Z | 2024-09-19T12:21:00.209Z |
5070749 | 5070749 | 20240911150603_c8UZj | NZ001N | 2024-09-15T12:00:45.542Z | 2024-09-19T12:21:00.194Z |
5070736 | 5070736 | 20240911150149_bIID2 | NZ001N | 2024-09-15T12:00:43.772Z | 2024-09-19T12:21:00.162Z |
5070629 | 5070629 | 20240911144254_4tP2V | NZ001N | 2024-09-15T12:00:26.465Z | 2024-09-19T12:20:59.555Z |
5068773 | 5068773 | 20240910122250_6DSF9 | NZ001N | 2024-09-14T12:19:21.271Z | 2024-09-18T12:15:26.622Z |
5068763 | 5068763 | 20240910121921_vx88Z | NZ001N | 2024-09-14T12:19:21.104Z | 2024-09-18T12:15:26.605Z |
5067434 | 5067434 | 20240910093048_0Ccij | NZ001N | 2024-09-14T12:18:43.645Z | 2024-09-18T12:15:24.105Z |
5062261 | 5062261 | 20240909170439_430TV | NZ001N | 2024-09-14T12:12:02.248Z | 2024-09-18T12:15:10.823Z |
5062120 | 5062120 | 20240909164539_Ua3Dy | NZ001N | 2024-09-14T12:11:50.202Z | 2024-09-18T12:15:10.412Z |
5062029 | 5062029 | 20240909163440_fZ1K2 | NZ001N | 2024-09-14T12:11:45.726Z | 2024-09-18T12:15:10.328Z |
5061737 | 5061737 | 20240909154935_j8TLz | NZ001N | 2024-09-14T12:11:17.908Z | 2024-09-18T12:15:09.938Z |
5061439 | 5061439 | 20240909150620_owkwO | NZ001N | 2024-09-14T12:10:50.084Z | 2024-09-18T12:15:09.229Z |
5061269 | 5061269 | 20240909143830_IRfGY | NZ001N | 2024-09-14T12:10:39.363Z | 2024-09-18T12:15:08.818Z |
5061218 | 5061218 | 20240909143353_F013J | NZ001N | 2024-09-14T12:10:35.435Z | 2024-09-18T12:15:08.623Z |
5061178 | 5061178 | 20240909142728_9fr2J | NZ001N | 2024-09-14T12:10:27.356Z | 2024-09-18T12:15:08.532Z |
5061142 | 5061142 | 20240909142227_mJwrI | NZ001N | 2024-09-14T12:10:22.356Z | 2024-09-18T12:15:08.307Z |
5060969 | 5060969 | 20240909133831_UmKuL | NZ001N | 2024-09-14T12:10:00.415Z | 2024-09-18T12:15:07.568Z |
5060955 | 5060955 | 20240909133708_xvK8r | NZ001N | 2024-09-14T12:09:59.217Z | 2024-09-18T12:15:07.516Z |
5060913 | 5060913 | 20240909132101_PUYRG | NZ001N | 2024-09-14T12:09:55.325Z | 2024-09-18T12:15:07.285Z |
5060877 | 5060877 | 20240909130958_ABKrH | NZ001N | 2024-09-14T12:09:51.498Z | 2024-09-18T12:15:07.171Z |
5059266 | 5059266 | 20240910172715_YABlp | NZ001N | 2024-09-14T12:05:34.970Z | 2024-09-19T12:21:30.482Z |
5059238 | 5059238 | 20240910172509_RCSac | NZ001N | 2024-09-14T12:05:29.750Z | 2024-09-19T12:21:30.467Z |
5059021 | 5059021 | 20240910170810_6x9Sx | NZ001N | 2024-09-14T12:05:06.687Z | 2024-09-19T12:21:30.306Z |
5058681 | 5058681 | 20240910163546_6ax34 | NZ001N | 2024-09-14T12:04:18.728Z | 2024-09-19T12:21:29.827Z |
5058619 | 5058619 | 20240910163153_AZVaE | NZ001N | 2024-09-14T12:04:09.831Z | 2024-09-19T12:21:29.794Z |
5058441 | 5058441 | 20240910161221_EMs8u | NZ001N | 2024-09-14T12:03:42.568Z | 2024-09-19T12:21:29.611Z |
5058132 | 5058132 | 20240910154715_RV5pR | NZ001N | 2024-09-14T12:03:00.896Z | 2024-09-19T12:21:29.171Z |
5058113 | 5058113 | 20240910154544_7Sq1T | NZ001N | 2024-09-14T12:02:58.781Z | 2024-09-19T12:21:29.145Z |
5057925 | 5057925 | 20240910152728_zNOl8 | NZ001N | 2024-09-14T12:02:26.089Z | 2024-09-19T12:21:28.951Z |
5057110 | 5057110 | 20240908121628_HLyR3 | NZ001N | 2024-09-13T12:17:44.920Z | 2024-09-16T12:21:28.799Z |
5057033 | 5057033 | 20240908115611_VNzP2 | NZ001N | 2024-09-13T12:17:43.897Z | 2024-09-16T12:21:28.511Z |
5056558 | 5056558 | 20240908104112_d2HQh | NZ001N | 2024-09-13T12:17:34.958Z | 2024-09-16T12:21:25.884Z |
5056508 | 5056508 | 20240908103717_FyeRI | NZ001N | 2024-09-13T12:17:34.255Z | 2024-09-16T12:21:25.711Z |
5056320 | 5056320 | 20240908101147_RKwOo | NZ001N | 2024-09-13T12:17:30.302Z | 2024-09-16T12:21:24.431Z |
5051270 | 5051270 | 20240907171041_QRCiK | NZ001N | 2024-09-13T12:14:08.286Z | 2024-09-16T12:21:00.000Z |
5051163 | 5051163 | 20240907165648_D8zvQ | NZ001N | 2024-09-13T12:14:04.832Z | 2024-09-16T12:20:59.760Z |
5051088 | 5051088 | 20240907164738_nFFx5 | NZ001N | 2024-09-13T12:14:01.430Z | 2024-09-16T12:20:59.578Z |
5050490 | 5050490 | 20240907152540_UGc6u | NZ001N | 2024-09-13T12:13:33.661Z | 2024-09-16T12:20:57.830Z |
5050441 | 5050441 | 20240907152115_y0Tg2 | NZ001N | 2024-09-13T12:13:32.173Z | 2024-09-16T12:20:57.698Z |
5044369 | 5044369 | 20240908145156_ojocX | NZ001N | 2024-09-13T12:02:04.334Z | 2024-09-17T12:18:54.238Z |
5044363 | 5044363 | 20240908145130_uz8QT | NZ001N | 2024-09-13T12:02:03.388Z | 2024-09-17T12:18:54.144Z |
5044312 | 5044312 | 20240908144540_B7nw8 | NZ001N | 2024-09-13T12:01:54.813Z | 2024-09-17T12:18:54.039Z |
5044289 | 5044289 | 20240908144114_Hf4wo | NZ001N | 2024-09-13T12:01:52.365Z | 2024-09-17T12:18:54.009Z |
5044209 | 5044209 | 20240908142914_GF8yK | NZ001N | 2024-09-13T12:01:40.944Z | 2024-09-17T12:18:53.684Z |
5043847 | 5043847 | 20240908132102_3YYWo | NZ001N | 2024-09-13T12:00:48.597Z | 2024-09-17T12:18:52.940Z |
5043801 | 5043801 | 20240908131350_0wi4Z | NZ001N | 2024-09-13T12:00:42.614Z | 2024-09-17T12:18:52.874Z |
5043791 | 5043791 | 20240908130740_X3L1z | NZ001N | 2024-09-13T12:00:40.847Z | 2024-09-17T12:18:52.835Z |
5043681 | 5043681 | 20240908123817_F8KxO | NZ001N | 2024-09-13T12:00:23.557Z | 2024-09-17T12:18:52.635Z |
5043230 | 5043230 | 20240907141014_3V1ZM | NZ001N | 2024-09-12T12:17:25.448Z | 2024-09-16T12:20:55.936Z |
5043193 | 5043193 | 20240907140458_IB7Bz | NZ001N | 2024-09-12T12:17:24.984Z | 2024-09-16T12:20:55.799Z |
5038121 | 5038121 | 20240905172709_khs9Y | NZ001N | 2024-09-12T12:14:23.281Z | 2024-09-14T12:22:55.089Z |
5037977 | 5037977 | 20240905170942_O07za | NZ001N | 2024-09-12T12:14:18.294Z | 2024-09-14T12:22:54.862Z |
5037963 | 5037963 | 20240905170850_UfoDU | NZ001N | 2024-09-12T12:14:18.051Z | 2024-09-14T12:22:54.844Z |
5037918 | 5037918 | 20240905170441_aGPJB | NZ001N | 2024-09-12T12:14:17.427Z | 2024-09-14T12:22:54.799Z |
5037864 | 5037864 | 20240905165750_IB34g | NZ001N | 2024-09-12T12:14:16.323Z | 2024-09-14T12:22:54.746Z |
5037747 | 5037747 | 20240905164500_QkLxV | NZ001N | 2024-09-12T12:14:14.855Z | 2024-09-14T12:22:54.561Z |
5037740 | 5037740 | 20240905164310_IqYX3 | NZ001N | 2024-09-12T12:14:14.692Z | 2024-09-14T12:22:54.545Z |
5037730 | 5037730 | 20240905164310_0UWHv | NZ001N | 2024-09-12T12:14:14.661Z | 2024-09-14T12:22:54.542Z |
5037715 | 5037715 | 20240905164156_NHs8I | NZ001N | 2024-09-12T12:14:14.506Z | 2024-09-14T12:22:54.536Z |
5037646 | 5037646 | 20240905162844_vzskN | NZ001N | 2024-09-12T12:14:13.334Z | 2024-09-14T12:22:54.481Z |
5037628 | 5037628 | 20240905162606_O0cso | NZ001N | 2024-09-12T12:14:13.037Z | 2024-09-14T12:22:54.475Z |
5037306 | 5037306 | 20240905153517_uqS7I | NZ001N | 2024-09-12T12:14:04.645Z | 2024-09-14T12:22:54.088Z |
5037196 | 5037196 | 20240905152038_OpV92 | NZ001N | 2024-09-12T12:14:02.908Z | 2024-09-14T12:22:53.952Z |
5037176 | 5037176 | 20240905151840_oNnHl | NZ001N | 2024-09-12T12:14:02.550Z | 2024-09-14T12:22:53.852Z |
5036974 | 5036974 | 20240905145009_b7pk8 | NZ001N | 2024-09-12T12:13:58.419Z | 2024-09-14T12:22:53.594Z |
5036744 | 5036744 | 20240905142311_Xf8Wi | NZ001N | 2024-09-12T12:13:53.695Z | 2024-09-14T12:22:53.178Z |
5036687 | 5036687 | 20240905141423_6Lep3 | NZ001N | 2024-09-12T12:13:52.084Z | 2024-09-14T12:22:53.094Z |
5036656 | 5036656 | 20240905141303_2lMj3 | NZ001N | 2024-09-12T12:13:51.709Z | 2024-09-14T12:22:53.081Z |
5036376 | 5036376 | 20240905132132_LeQvI | NZ001N | 2024-09-12T12:13:38.294Z | 2024-09-14T12:22:52.381Z |
5035966 | 5035966 | 20240905121945_B39Um | NZ001N | 2024-09-12T12:13:13.499Z | 2024-09-14T12:22:51.680Z |
5028586 | 5028586 | 20240905102421_qgNVd | NZ001N | 2024-09-11T12:15:36.138Z | 2024-09-14T12:22:48.400Z |
5023949 | 5023949 | 20240905172709_ZEKa3 | NZ001N | 2024-09-11T12:02:11.530Z | 2024-09-14T12:22:55.087Z |
5023822 | 5023822 | 20240905170942_KqTdz | NZ001N | 2024-09-10T12:16:50.481Z | 2024-09-11T12:16:31.800Z |
5023808 | 5023808 | 20240905170850_aBcH6 | NZ001N | 2024-09-10T12:16:50.333Z | 2024-09-14T12:22:54.842Z |
5023759 | 5023759 | 20240905170441_vXzlk | NZ001N | 2024-09-10T12:16:50.073Z | 2024-09-11T12:16:31.774Z |
5023709 | 5023709 | 20240905165750_lXEIy | NZ001N | 2024-09-10T12:16:49.387Z | 2024-09-11T12:16:31.751Z |
5023605 | 5023605 | 20240905164500_aXmQO | NZ001N | 2024-09-10T12:16:48.231Z | 2024-09-11T12:16:31.719Z |
5023598 | 5023598 | 20240905164310_vRX3F | NZ001N | 2024-09-10T12:16:48.035Z | 2024-09-14T12:22:54.543Z |
5023588 | 5023588 | 20240905164310_ajBTm | NZ001N | 2024-09-10T12:16:48.010Z | 2024-09-11T12:16:31.714Z |
5023573 | 5023573 | 20240905164156_ZhW2m | NZ001N | 2024-09-10T12:16:47.832Z | 2024-09-11T12:16:31.710Z |
5023504 | 5023504 | 20240905162844_fLcB6 | NZ001N | 2024-09-10T12:16:46.842Z | 2024-09-11T12:16:31.684Z |
5023187 | 5023187 | 20240905153517_uR6pr | NZ001N | 2024-09-10T12:16:40.465Z | 2024-09-11T12:16:31.571Z |
5023082 | 5023082 | 20240905152038_bIF4y | NZ001N | 2024-09-10T12:16:38.877Z | 2024-09-11T12:16:31.525Z |
5023064 | 5023064 | 20240905151840_3CRAt | NZ001N | 2024-09-10T12:16:38.549Z | 2024-09-11T12:16:31.520Z |
5018204 | 5018204 | 20240904172545_GpfvA | NZ001N | 2024-09-10T12:10:10.251Z | 2024-09-13T12:19:47.439Z |
5017992 | 5017992 | 20240904170411_si3c1 | NZ001N | 2024-09-10T12:09:50.409Z | 2024-09-13T12:19:47.154Z |
5017732 | 5017732 | 20240904163700_B9lu8 | NZ001N | 2024-09-10T12:09:27.951Z | 2024-09-13T12:19:47.067Z |
5017646 | 5017646 | 20240904162820_nBYu7 | NZ001N | 2024-09-10T12:09:21.429Z | 2024-09-13T12:19:47.032Z |
5017639 | 5017639 | 20240904162750_I0hUe | NZ001N | 2024-09-10T12:09:21.240Z | 2024-09-13T12:19:47.030Z |
5017451 | 5017451 | 20240904160944_3znJr | NZ001N | 2024-09-10T12:09:11.267Z | 2024-09-13T12:19:46.887Z |
5017260 | 5017260 | 20240904154926_jpRKW | NZ001N | 2024-09-10T12:09:00.038Z | 2024-09-13T12:19:46.737Z |
5017002 | 5017002 | 20240904152048_7AavE | NZ001N | 2024-09-10T12:08:38.346Z | 2024-09-13T12:19:46.491Z |
5016916 | 5016916 | 20240904151104_9d22M | NZ001N | 2024-09-10T12:08:30.974Z | 2024-09-13T12:19:46.446Z |
5016701 | 5016701 | 20240904144236_15OpJ | NZ001N | 2024-09-10T12:08:09.673Z | 2024-09-13T12:19:46.161Z |
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);