names

87 rows where place_id = 589453

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597688 1866903 1866903 defendant Coterell Richard butcher 589453 589453 Coterell, Richard, of Abyngdon, butcher 1
3597689 1866903 1866903 defendant Neweman William yeoman or mercer 589453 589453 Neweman, William, of Abyngdon, yeoman or mercer 2
3623619 1874920 1874920 defendant Wryght John innholder 589453 589453 Wryght, John, of Abyngdon, innholder 1
3633670 1905341 1905341 defendant Boylond Richard tanner 589453 589453 Boylond, Richard, of Abyngdon, tanner 0
3637391 1906502 1906502 defendant Wilson Derick cordwainer 589453 589453 Wilson, Derick, of Abyngdon, cordwainer 1
3639284 1907099 1907099 plaintiff Warylton John (legal representative) 589453 589453 Warylton, John, of Abyngdon, draper, executors of 0
3677060 1918864 1918864 defendant Bocher Robert butcher 589453 589453 Bocher, Robert, of Abyngdon, butcher 1
3812953 1961949 1961949 defendant Cradok Thomas innholder 589453 589453 Cradok, Thomas, of Abyngdon, innholder 0
3860151 1976892 1976892 defendant Heth Henry husbandman 589453 589453 Heth, Henry, of Abyngdon, husbandman 1
3873039 1981197 1981197 defendant More Humphrey dyer 589453 589453 More, Humphrey, of Abyngdon, dyer 0
3940073 2003696 2003696 defendant Sayter Robert husbandman 589453 589453 Sayter, Robert, of Abyngdon, husbandman 0
3963701 2011913 2011913 defendant Cordewell Edmund yeoman 589453 589453 Cordewell, Edmund, of Abyngdon, yeoman 0
3963702 2011913 2011913 defendant Barrett William   589453 589453 Barrett, William, of Abyngdon, tallow chandler 1
3986382 2019873 2019873 defendant Brookes Thomas butcher 589453 589453 Brookes, Thomas, of Abyngdon, butcher 0
3990979 2021537 2021537 plaintiff Bostocke Lionel draper 589453 589453 Bostocke, Lionel, of Abyngdon, draper 0
3990980 2021537 2021537 defendant Pudsey John gent 589453 589453 Pudsey, John, of Abyngdon, gent 0
4024423 2033413 2033413 defendant Teysedale Richard miller or saddler 589453 589453 Teysedale, Richard, of Abyngdon, miller or saddler 0
4024435 2033419 2033419 defendant Teysedale Richard miller 589453 589453 Teysedale, Richard, of Abyngdon, miller 0
4024437 2033420 2033420 defendant Teysedale Richard miller or saddler 589453 589453 Teysedale, Richard, of Abyngdon, miller or saddler 0
4386694 2160227 2160227 defendant Fysher John, junior innholder 589453 589453 Fysher, John, junior, of Abyngdon, innholder 0
4392548 2162128 2162128 defendant Northe Thomas yeoman 589453 589453 Northe, Thomas, of Abyngdon, yeoman 0
4396786 2163492 2163492 defendant Harper Thomas glasier 589453 589453 Harper, Thomas, of Abyngdon, glasier 0
4416057 2169908 2169908 plaintiff Leyghton Thomas de merchant 589453 589453 Leyghton, Thomas de, of Abyngdon, merchant 0
4416059 2169909 2169909 plaintiff Leyghton Thomas de merchant 589453 589453 Leyghton, Thomas de, of Abyngdon, merchant 0
4490225 2197645 2197645 defendant Gollasfre William   589453 589453 Gollasfre, William, of Abyngdon 7
4490253 2197650 2197650 defendant Gollafre William   589453 589453 Gollafre, William, of Abyngdon 7
4579503 2225070 2225070 defendant Asshperton John chapman 589453 589453 Asshperton, John, of Abyngdon, chapman 0
4603060 2232169 2232169 defendant Asperton John   589453 589453 Asperton, John, of Abyngdon 0
4622226 2237931 2237931 plaintiff London John   589453 589453 London, John, of Abyngdon 0
4652882 2246837 2246837 defendant Fissher William fisher 589453 589453 Fissher, William, of Abyngdon, fisher 2
4693340 2263421 2263421 defendant Croweley John chapman 589453 589453 Croweley, John, of Abyngdon, chapman 0
4708941 2268165 2268165 defendant Taillour Richard tailor 589453 589453 Taillour, Richard, of Abyngdon, tailor 0
4724100 2272832 2272832 defendant Fuller William fuller 589453 589453 Fuller, William, of Abyngdon, fuller 0
4724101 2272832 2272832 defendant Parche Robert fuller 589453 589453 Parche, Robert, of Abyngdon, fuller 1
4725882 2273383 2273383 defendant Hordewell Simon chapman 589453 589453 Hordewell, Simon, of Abyngdon, chapman 0
4828252 2304879 2304879 defendant Chapman Thomas husbandman 589453 589453 Chapman, Thomas, of Abyngdon, husbandman 0
4829853 2305382 2305382 defendant Stokys John draper 589453 589453 Stokys, John, of Abyngdon, draper 2
4829854 2305382 2305382 defendant Shipton Thomas draper 589453 589453 Shipton, Thomas, of Abyngdon, draper 3
4829855 2305382 2305382 defendant Apule William draper 589453 589453 Apule, William, of Abyngdon, draper 4
4847354 2310677 2310677 defendant Seman John   589453 589453 Seman, John, of Abyngdon, glove maker 0
4934743 2337263 2337263 defendant Stodale John skinner 589453 589453 Stodale, John, of Abyngdon, skinner 0
4950867 2342241 2342241 plaintiff Pert Thomas courser 589453 589453 Pert, Thomas, of Abyngdon, courser 0
4950868 2342241 2342241 defendant Gaunt Henry butcher 589453 589453 Gaunt, Henry, of Abyngdon, butcher 0
4961140 2345294 2345294 defendant Boughton Richard husbandman 589453 589453 Boughton, Richard, of Abyngdon, husbandman 1
4974640 2349382 2349382 defendant Freman Robert yeoman 589453 589453 Freman, Robert, of Abyngdon, yeoman 0
5076254 2379400 2379400 defendant Bagge John merchant 589453 589453 Bagge, John, of Abyngdon, merchant 1
5133280 2396220 2396220 defendant Chippon Walter skinner 589453 589453 Chippon, Walter, of Abyngdon, skinner 0
5161741 2404537 2404537 plaintiff Tanner Nicholas yeoman 589453 589453 Tanner, Nicholas, of Abyngdon, yeoman 0
5227253 2423601 2423601 plaintiff Tanner Nicholas yeoman 589453 589453 Tanner, Nicholas, of Abyngdon, yeoman 0
5244380 2428538 2428538 defendant Bray Robert yeoman 589453 589453 Bray, Robert, of Abyngdon, yeoman 2
5249204 2429890 2429890 defendant Ford Roger chapman 589453 589453 Ford, Roger, of Abyngdon, chapman 1
5262975 2434164 2434164 plaintiff Plesaunce Thomas   589453 589453 Plesaunce, Thomas, of Abyngdon 0
5312485 2448769 2448769 defendant Bygneld Henry smith 589453 589453 Bygneld, Henry, of Abyngdon, smith 0
5324044 2452280 2452280 plaintiff Pomeray William gent 589453 589453 Pomeray, William, of Abyngdon, gent 0
5343183 2458059 2458059 defendant Hevy Thomas chapman 589453 589453 Hevy, Thomas, of Abyngdon, chapman 0
5347292 2459320 2459320 defendant Pape Richard chapman 589453 589453 Pape, Richard, of Abyngdon, chapman 0
5358590 2462747 2462747 plaintiff Pettewyn Stephen fishmonger 589453 589453 Pettewyn, Stephen, of Abyngdon, fishmonger 0
5358591 2462747 2462747 defendant Benet Thomas chapman 589453 589453 Benet, Thomas, of Abyngdon, chapman 0
5369296 2465999 2465999 defendant Bage Richard chapman 589453 589453 Bage, Richard, of Abyngdon, chapman 2
5372415 2466969 2466969 defendant Batte Edmund husbandman 589453 589453 Batte, Edmund, of Abyngdon, husbandman 0
5389757 2472135 2472135 defendant Glover Andrew glover 589453 589453 Glover, Andrew, of Abyngdon, glover 1
5392299 2472886 2472886 defendant Pape Richard   589453 589453 Pape, Richard, of Abyngdon 2
5402591 2475814 2475814 defendant Blover Andrew glover 589453 589453 Blover, Andrew, of Abyngdon, glover 1
5402594 2475815 2475815 defendant Blover Andrew glover 589453 589453 Blover, Andrew, of Abyngdon, glover 1
5415494 2479575 2479575 defendant Glover Andrew   589453 589453 Glover, Andrew, of Abyngdon 1
5415497 2479576 2479576 defendant Glover Andrew glover 589453 589453 Glover, Andrew, of Abyngdon, glover 1
5422803 2481772 2481772 defendant Love Alice widow 589453 589453 Love, Alice, of Abyngdon, widow 1
5422806 2481773 2481773 defendant Love Alice widow 589453 589453 Love, Alice, of Abyngdon, widow 1
5422809 2481774 2481774 defendant Love Alice widow 589453 589453 Love, Alice, of Abyngdon, widow 1
5422812 2481775 2481775 defendant Love Alice widow 589453 589453 Love, Alice, of Abyngdon, widow 1
5428509 2483455 2483455 defendant Galaunton John Berks, free mason 589453 589453 Galaunton John, of Abyngdon, Berks, free mason 0
5445828 2488642 2488642 defendant Balaunton (illegible)   589453 589453 Balaunton, _, of Abyngdon, free mason 0
5495488 2503551 2503551 defendant Mayne John yeoman 589453 589453 Mayne, John, of Abyngdon, yeoman 0
5500635 2505125 2505125 plaintiff Say Thomas gent 589453 589453 Say, Thomas, of Abyngdon, gent 0
5514232 2509298 2509298 defendant Boner Thomas mercer 589453 589453 Boner, Thomas, of Abyngdon, mercer 0
5514233 2509298 2509298 defendant Rumsey William fuller 589453 589453 Rumsey, William, of Abyngdon, fuller 1
5514234 2509298 2509298 defendant Coterell Richard butcher 589453 589453 Coterell, Richard, of Abyngdon, butcher 2
5521926 2511673 2511673 defendant Dyner or Dyver Thomas mercer 589453 589453 Dyner or Dyver, Thomas, of Abyngdon, mercer 2
5545044 2518556 2518556 defendant Cullarn Richard brewer 589453 589453 Cullarn, Richard, of Abyngdon, brewer 1
5545046 2518556 2518556 defendant Hewet Reginald carpenter 589453 589453 Hewet, Reginald, of Abyngdon, carpenter 3
5574432 2527087 2527087 defendant Smyth John butcher 589453 589453 Smyth, John, of Abyngdon, butcher 4
5579511 2528672 2528672 defendant Skarlet Augustine dyer 589453 589453 Skarlet, Augustine, of Abyngdon, dyer 0
5580064 2528845 2528845 defendant Wode Lionel gent 589453 589453 (Wode, Lionel, of Abyngdon, gent 1
5596043 2533675 2533675 defendant Skydmore Edward carpenter 589453 589453 Skydmore, Edward, of Abyngdon, carpenter 0
5607724 2537319 2537319 defendant Braybroke Margery widow 589453 589453 Braybroke, Margery, of Abyngdon, widow 0
5607757 2537332 2537332 defendant Braybroke Margery widow 589453 589453 Braybroke, Margery, of Abyngdon, widow 0
5609067 2537740 2537740 defendant Bate Edmund husbandman 589453 589453 Bate, Edmund, of Abyngdon, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);