participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,019 rows where station_code = "NZ002Q" 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 |
---|---|---|---|---|---|
5135214 | 5135214 | 20240916170528_nsJQv | NZ002Q | 2024-09-19T12:18:16.724Z | 2024-09-19T12:18:16.724Z |
5135135 | 5135135 | 20240916163721_eoNN2 | NZ002Q | 2024-09-19T12:18:15.516Z | 2024-09-19T12:18:15.516Z |
5135065 | 5135065 | 20240916155658_iZpyW | NZ002Q | 2024-09-19T12:18:13.853Z | 2024-09-19T12:18:13.853Z |
5126330 | 5126330 | 20240918105822_pSZ14 | NZ002Q | 2024-09-19T12:05:46.014Z | 2024-09-19T12:06:42.182Z |
5108835 | 5108835 | 20240913074223_EyIGi | NZ002Q | 2024-09-17T12:14:09.329Z | 2024-09-19T12:20:50.912Z |
5096484 | 5096484 | 20240912105718_eFcfx | NZ002Q | 2024-09-16T12:16:24.506Z | 2024-09-19T12:21:22.382Z |
5096396 | 5096396 | 20240912104401_hW8Nw | NZ002Q | 2024-09-16T12:16:22.564Z | 2024-09-19T12:21:22.244Z |
5096340 | 5096340 | 20240912103601_RRmZd | NZ002Q | 2024-09-16T12:16:20.967Z | 2024-09-19T12:21:22.143Z |
5095546 | 5095546 | 20240912080200_rJn2s | NZ002Q | 2024-09-16T12:15:48.067Z | 2024-09-19T12:21:18.991Z |
5083615 | 5083615 | 20240911135800_LulOC | NZ002Q | 2024-09-15T12:18:44.619Z | 2024-09-19T12:21:49.725Z |
5083532 | 5083532 | 20240911134311_bhbEM | NZ002Q | 2024-09-15T12:18:43.432Z | 2024-09-19T12:21:49.637Z |
5083487 | 5083487 | 20240911133150_AB6vw | NZ002Q | 2024-09-15T12:18:42.563Z | 2024-09-19T12:21:49.597Z |
5083471 | 5083471 | 20240911132834_MzsC2 | NZ002Q | 2024-09-15T12:18:42.462Z | 2024-09-19T12:21:49.595Z |
5083442 | 5083442 | 20240911131929_twtrW | NZ002Q | 2024-09-15T12:18:42.165Z | 2024-09-19T12:21:49.586Z |
5083423 | 5083423 | 20240911131644_LHqmp | NZ002Q | 2024-09-15T12:18:41.904Z | 2024-09-19T12:21:49.578Z |
5083328 | 5083328 | 20240911125646_nf3u8 | NZ002Q | 2024-09-15T12:18:39.415Z | 2024-09-19T12:21:49.484Z |
5083294 | 5083294 | 20240911124926_UU3vg | NZ002Q | 2024-09-15T12:18:38.582Z | 2024-09-19T12:21:49.470Z |
5083256 | 5083256 | 20240911123835_Nvknj | NZ002Q | 2024-09-15T12:18:37.694Z | 2024-09-19T12:21:49.438Z |
5083241 | 5083241 | 20240911123731_LlP9K | NZ002Q | 2024-09-15T12:18:37.552Z | 2024-09-19T12:21:49.432Z |
5083231 | 5083231 | 20240911123346_MDwJO | NZ002Q | 2024-09-15T12:18:37.264Z | 2024-09-19T12:21:49.419Z |
5083207 | 5083207 | 20240911122909_KZgZn | NZ002Q | 2024-09-15T12:18:37.018Z | 2024-09-19T12:21:49.376Z |
5083146 | 5083146 | 20240911121503_QuIx2 | NZ002Q | 2024-09-15T12:18:36.206Z | 2024-09-19T12:21:49.359Z |
5082569 | 5082569 | 20240911102824_eOVIu | NZ002Q | 2024-09-15T12:18:20.317Z | 2024-09-19T12:21:48.118Z |
5082513 | 5082513 | 20240911101928_I7fqR | NZ002Q | 2024-09-15T12:18:16.988Z | 2024-09-19T12:21:48.032Z |
5082479 | 5082479 | 20240911101449_NQ26a | NZ002Q | 2024-09-15T12:18:16.108Z | 2024-09-19T12:21:47.987Z |
5082458 | 5082458 | 20240911101110_dcnsN | NZ002Q | 2024-09-15T12:18:15.494Z | 2024-09-19T12:21:47.978Z |
5082370 | 5082370 | 20240911100027_Rmjco | NZ002Q | 2024-09-15T12:18:12.930Z | 2024-09-19T12:21:47.887Z |
5082297 | 5082297 | 20240911095040_Io9xi | NZ002Q | 2024-09-15T12:18:10.476Z | 2024-09-19T12:21:47.701Z |
5081375 | 5081375 | 20240911073223_oix7j | NZ002Q | 2024-09-15T12:17:31.764Z | 2024-09-19T12:21:45.212Z |
5071378 | 5071378 | 20240911164428_6G5Og | NZ002Q | 2024-09-15T12:02:24.523Z | 2024-09-19T12:21:01.784Z |
5071323 | 5071323 | 20240911163420_hWphc | NZ002Q | 2024-09-15T12:02:18.161Z | 2024-09-19T12:21:01.420Z |
5071226 | 5071226 | 20240911161842_A9FKb | NZ002Q | 2024-09-15T12:01:58.005Z | 2024-09-19T12:21:01.263Z |
5071026 | 5071026 | 20240911154501_KjXGk | NZ002Q | 2024-09-15T12:01:26.378Z | 2024-09-19T12:21:00.762Z |
5070959 | 5070959 | 20240911153513_p2nA9 | NZ002Q | 2024-09-15T12:01:14.847Z | 2024-09-19T12:21:00.637Z |
5070945 | 5070945 | 20240911153213_mAO58 | NZ002Q | 2024-09-15T12:01:12.434Z | 2024-09-19T12:21:00.613Z |
5070906 | 5070906 | 20240911152746_nohQ3 | NZ002Q | 2024-09-15T12:01:07.842Z | 2024-09-19T12:21:00.560Z |
5070823 | 5070823 | 20240911151413_8QFC6 | NZ002Q | 2024-09-15T12:00:57.699Z | 2024-09-19T12:21:00.366Z |
5070596 | 5070596 | 20240911143723_PBWSR | NZ002Q | 2024-09-15T12:00:22.912Z | 2024-09-19T12:20:59.355Z |
5070551 | 5070551 | 20240911143102_c3Yn2 | NZ002Q | 2024-09-15T12:00:17.833Z | 2024-09-19T12:20:59.248Z |
5070544 | 5070544 | 20240911143057_Rnhrh | NZ002Q | 2024-09-15T12:00:17.121Z | 2024-09-19T12:20:59.227Z |
5068944 | 5068944 | 20240910131020_VgqoI | NZ002Q | 2024-09-14T12:19:23.158Z | 2024-09-18T12:15:26.881Z |
5068911 | 5068911 | 20240910125824_YoSKl | NZ002Q | 2024-09-14T12:19:22.813Z | 2024-09-18T12:15:26.815Z |
5068890 | 5068890 | 20240910125516_SFKTr | NZ002Q | 2024-09-14T12:19:22.599Z | 2024-09-18T12:15:26.785Z |
5068589 | 5068589 | 20240910115235_3VDJx | NZ002Q | 2024-09-14T12:19:18.905Z | 2024-09-18T12:15:26.348Z |
5068448 | 5068448 | 20240910113341_LJpYJ | NZ002Q | 2024-09-14T12:19:15.693Z | 2024-09-18T12:15:26.159Z |
5068445 | 5068445 | 20240910113325_9SWJk | NZ002Q | 2024-09-14T12:19:15.678Z | 2024-09-18T12:15:26.158Z |
5068231 | 5068231 | 20240910111329_5lwcs | NZ002Q | 2024-09-14T12:19:11.131Z | 2024-09-18T12:15:25.786Z |
5067550 | 5067550 | 20240910094326_dMqSw | NZ002Q | 2024-09-14T12:18:48.340Z | 2024-09-18T12:15:24.365Z |
5066949 | 5066949 | 20240910083411_mqSNJ | NZ002Q | 2024-09-14T12:18:22.835Z | 2024-09-18T12:15:23.015Z |
5059037 | 5059037 | 20240910170834_ZULkp | NZ002Q | 2024-09-14T12:05:08.077Z | 2024-09-19T12:21:30.321Z |
5059030 | 5059030 | 20240910170831_PdgP7 | NZ002Q | 2024-09-14T12:05:07.424Z | 2024-09-19T12:21:30.312Z |
5058469 | 5058469 | 20240910161435_EZjSy | NZ002Q | 2024-09-14T12:03:45.296Z | 2024-09-19T12:21:29.638Z |
5058414 | 5058414 | 20240910161127_Ry7Wu | NZ002Q | 2024-09-14T12:03:40.065Z | 2024-09-19T12:21:29.594Z |
5058167 | 5058167 | 20240910154906_2nfhj | NZ002Q | 2024-09-14T12:03:04.340Z | 2024-09-19T12:21:29.246Z |
5058008 | 5058008 | 20240910153511_WZXdx | NZ002Q | 2024-09-14T12:02:36.313Z | 2024-09-19T12:21:28.998Z |
5058003 | 5058003 | 20240910153511_BSIjA | NZ002Q | 2024-09-14T12:02:36.113Z | 2024-09-19T12:21:28.998Z |
5057948 | 5057948 | 20240910152903_9tFoQ | NZ002Q | 2024-09-14T12:02:27.963Z | 2024-09-19T12:21:28.962Z |
5057866 | 5057866 | 20240910152041_353ru | NZ002Q | 2024-09-14T12:02:16.963Z | 2024-09-19T12:21:28.874Z |
5057819 | 5057819 | 20240910151640_9xMEZ | NZ002Q | 2024-09-14T12:02:10.843Z | 2024-09-19T12:21:28.832Z |
5057686 | 5057686 | 20240910150430_r4edx | NZ002Q | 2024-09-14T12:01:44.277Z | 2024-09-19T12:21:28.581Z |
5057664 | 5057664 | 20240910150205_oND23 | NZ002Q | 2024-09-14T12:01:41.400Z | 2024-09-19T12:21:28.557Z |
5057217 | 5057217 | 20240910140005_7Js9N | NZ002Q | 2024-09-14T12:00:33.205Z | 2024-09-19T12:21:27.316Z |
5057179 | 5057179 | 20240910135350_LQVBb | NZ002Q | 2024-09-14T12:00:26.496Z | 2024-09-19T12:21:27.231Z |
5057069 | 5057069 | 20240908120641_2pQRR | NZ002Q | 2024-09-13T12:17:44.425Z | 2024-09-16T12:21:28.733Z |
5056892 | 5056892 | 20240908113712_bs7pg | NZ002Q | 2024-09-13T12:17:40.755Z | 2024-09-16T12:21:27.681Z |
5055887 | 5055887 | 20240908091406_a2u7e | NZ002Q | 2024-09-13T12:17:24.889Z | 2024-09-16T12:21:22.485Z |
5055828 | 5055828 | 20240908090809_WK0Zg | NZ002Q | 2024-09-13T12:17:23.683Z | 2024-09-16T12:21:22.159Z |
5044634 | 5044634 | 20240908152539_RvnCu | NZ002Q | 2024-09-13T12:02:37.623Z | 2024-09-17T12:18:54.772Z |
5043706 | 5043706 | 20240908124706_2HtbU | NZ002Q | 2024-09-13T12:00:28.128Z | 2024-09-17T12:18:52.714Z |
5043687 | 5043687 | 20240908124028_I4QT3 | NZ002Q | 2024-09-13T12:00:24.409Z | 2024-09-17T12:18:52.649Z |
5042187 | 5042187 | 20240906100850_gOwTC | NZ002Q | 2024-09-12T12:16:56.828Z | 2024-09-14T12:23:16.405Z |
5041755 | 5041755 | 20240906085840_UW3vd | NZ002Q | 2024-09-12T12:16:48.064Z | 2024-09-14T12:23:14.475Z |
5041591 | 5041591 | 20240906083512_JFUN6 | NZ002Q | 2024-09-12T12:16:44.819Z | 2024-09-14T12:23:14.004Z |
5041490 | 5041490 | 20240906082440_25fFz | NZ002Q | 2024-09-12T12:16:43.062Z | 2024-09-14T12:23:13.752Z |
5041041 | 5041041 | 20240906070741_vU3LM | NZ002Q | 2024-09-12T12:16:32.252Z | 2024-09-14T12:23:11.446Z |
5037855 | 5037855 | 20240905165721_20ZSV | NZ002Q | 2024-09-12T12:14:16.256Z | 2024-09-14T12:22:54.743Z |
5037662 | 5037662 | 20240905163031_mpbiG | NZ002Q | 2024-09-12T12:14:13.513Z | 2024-09-14T12:22:54.487Z |
5037343 | 5037343 | 20240905154002_f8BiJ | NZ002Q | 2024-09-12T12:14:05.337Z | 2024-09-14T12:22:54.125Z |
5037243 | 5037243 | 20240905152814_5AHZc | NZ002Q | 2024-09-12T12:14:03.697Z | 2024-09-14T12:22:54.015Z |
5037102 | 5037102 | 20240905150753_uuJP1 | NZ002Q | 2024-09-12T12:14:01.065Z | 2024-09-14T12:22:53.708Z |
5036855 | 5036855 | 20240905143549_6W2qY | NZ002Q | 2024-09-12T12:13:56.139Z | 2024-09-14T12:22:53.302Z |
5036360 | 5036360 | 20240905132036_4KuDS | NZ002Q | 2024-09-12T12:13:37.631Z | 2024-09-14T12:22:52.355Z |
5036132 | 5036132 | 20240905124849_14TLr | NZ002Q | 2024-09-12T12:13:26.498Z | 2024-09-14T12:22:51.924Z |
5034973 | 5034973 | 20240907082546_kkN3T | NZ002Q | 2024-09-12T12:11:47.484Z | 2024-09-15T12:21:37.813Z |
5028740 | 5028740 | 20240905104445_e3fgC | NZ002Q | 2024-09-11T12:15:47.213Z | 2024-09-14T12:22:49.283Z |
5028325 | 5028325 | 20240905092757_z9O03 | NZ002Q | 2024-09-11T12:15:09.862Z | 2024-09-13T12:20:05.973Z |
5028134 | 5028134 | 20240905090648_aN602 | NZ002Q | 2024-09-11T12:14:53.831Z | 2024-09-13T12:20:05.435Z |
5027375 | 5027375 | 20240905073110_Ym8zA | NZ002Q | 2024-09-11T12:14:07.529Z | 2024-09-13T12:20:02.459Z |
5027294 | 5027294 | 20240905071851_92U6e | NZ002Q | 2024-09-11T12:14:04.419Z | 2024-09-13T12:20:02.266Z |
5023700 | 5023700 | 20240905165721_D2CqD | NZ002Q | 2024-09-10T12:16:49.333Z | 2024-09-11T12:16:31.749Z |
5023520 | 5023520 | 20240905163031_2gf5K | NZ002Q | 2024-09-10T12:16:47.021Z | 2024-09-11T12:16:31.689Z |
5023460 | 5023460 | 20240905161607_SJ1qt | NZ002Q | 2024-09-10T12:16:45.613Z | 2024-09-14T12:22:54.427Z |
5023222 | 5023222 | 20240905154002_8ZYZW | NZ002Q | 2024-09-10T12:16:40.884Z | 2024-09-11T12:16:31.587Z |
5023128 | 5023128 | 20240905152814_dz1mY | NZ002Q | 2024-09-10T12:16:39.399Z | 2024-09-11T12:16:31.544Z |
5022760 | 5022760 | 20240905092757_JVCK1 | NZ002Q | 2024-09-10T12:16:29.363Z | 2024-09-10T12:16:55.610Z |
5021828 | 5021828 | 20240905073110_T2PMa | NZ002Q | 2024-09-10T12:15:52.585Z | 2024-09-10T12:16:55.444Z |
5021747 | 5021747 | 20240905071851_3nW48 | NZ002Q | 2024-09-10T12:15:50.383Z | 2024-09-10T12:16:55.431Z |
5018302 | 5018302 | 20240904173820_gpBp3 | NZ002Q | 2024-09-10T12:10:22.210Z | 2024-09-13T12:19:47.517Z |
5018021 | 5018021 | 20240904170552_ZJF0g | NZ002Q | 2024-09-10T12:09:53.822Z | 2024-09-13T12:19:47.163Z |
5018009 | 5018009 | 20240904170537_8V4k1 | NZ002Q | 2024-09-10T12:09:53.050Z | 2024-09-13T12:19:47.160Z |
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);