names

78 rows where place_id = 590974

✎ 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
3602871 1868565 1868565 defendant Baysbull John chaplain 590974 590974 (Baysbull, John, of Gosberkyrk, chaplain 1
3602872 1868565 1868565 defendant Baysbull Robert yeoman 590974 590974 Baysbull, Robert, of Gosberkyrk, yeoman 2
3657856 1912706 1912706 defendant Floter John gent 590974 590974 Floter, John, of Gosberkyrk, gent 0
3660621 1913584 1913584 defendant Sparke Thomas husbandman 590974 590974 Sparke, Thomas, of Gosberkyrk, husbandman 0
3660622 1913584 1913584 defendant Teryngton Thomas husbandman 590974 590974 Teryngton, Thomas, of Gosberkyrk, husbandman 1
3660623 1913584 1913584 defendant Pott John husbandman 590974 590974 Pott, John, of Gosberkyrk, husbandman 2
3664307 1914788 1914788 defendant Garner John husbandman 590974 590974 Garner, John, of Gosberkyrk, husbandman 2
3736303 1937595 1937595 defendant Coke John yeoman 590974 590974 Coke, John, of Gosberkyrk, or of Wryghtbold, yeoman 0
3759630 1944999 1944999 defendant Clevelond William yeoman 590974 590974 Clevelond, William, of Gosberkyrk, yeoman 0
3851052 1973921 1973921 defendant Hump John yeoman 590974 590974 Hump, John, of Gosberkyrk, yeoman 0
4427623 2173475 2173475 defendant Cokerell Richard   590974 590974 Cokerell, Richard, of Gosberkyrk 3
4682754 2260224 2260224 plaintiff Obrey Robert   590974 590974 Obrey, Robert, of Gosberkyrk 0
4782972 2290694 2290694 defendant Payntour William painter 590974 590974 Payntour, William, of Gosberkyrk, painter 2
4793594 2294107 2294107 defendant Stronge Thomas husbandman 590974 590974 Stronge, Thomas, of Gosberkyrk, husbandman 1
4869207 2317342 2317342 defendant Roberd John yeoman 590974 590974 Roberd, John, of Gosberkyrk, yeoman 1
4929278 2335575 2335575 defendant Lepar Simon husbandman 590974 590974 Lepar, Simon, of Gosberkyrk, husbandman 1
4931386 2336196 2336196 defendant Laund Richard esq 590974 590974 Laund, Richard, of Gosberkyrk, esq 0
4944338 2340204 2340204 defendant Verdon Thomas husbandman 590974 590974 Verdon, Thomas, of Gosberkyrk, husbandman 0
4956724 2343964 2343964 defendant Whitebredde Joan widow 590974 590974 (Whitebredde, Joan, of Gosberkyrk, widow 3
4956725 2343964 2343964 defendant Sprot Gilbert clerk 590974 590974 Sprot, Gilbert, of Gosberkyrk, clerk 4
4956726 2343964 2343964 defendant Edmond Thomas draper 590974 590974 Edmond, Thomas, of Gosberkyrk, draper 5
5020470 2362875 2362875 defendant Smyth John butcher 590974 590974 Smyth, John, of Gosberkyrk, butcher 0
5035977 2367378 2367378 defendant de la Laund Anne gentlewoman 590974 590974 de la Laund, Anne, of Gosberkyrk, gentlewoman 0
5072545 2378275 2378275 plaintiff Thakar John   590974 590974 Thakar, John, of Gosberkyrk 0
5102807 2387239 2387239 plaintiff Bolles John gent 590974 590974 Bolles, John, of Gosberkyrk, gent 0
5102808 2387239 2387239 defendant Belman William (legal representative) 590974 590974 Belman, William, of Gosberkyrk, executors of 0
5102809 2387239 2387239 defendant Salter Edmund chaplain 590974 590974 (Salter, Edmund, of Gosberkyrk, chaplain 1
5204142 2416965 2416965 defendant Waryn Richard husbandman 590974 590974 Waryn, Richard, of Gosberkyrk, husbandman 0
5245089 2428730 2428730 defendant Peny Thomas husbandman 590974 590974 Peny, Thomas, of Gosberkyrk, husbandman 0
5245098 2428733 2428733 defendant Flouter John husbandman 590974 590974 Flouter, John, of Gosberkyrk, husbandman 3
5245155 2428744 2428744 defendant Beysboll Robert husbandman 590974 590974 Beysboll, Robert, of Gosberkyrk, husbandman 3
5314805 2449472 2449472 defendant Thakker Robert husbandman 590974 590974 Thakker, Robert, of Gosberkyrk, husbandman 1
5314806 2449472 2449472 defendant Thakker John husbandman 590974 590974 Thakker, John, of Gosberkyrk, husbandman 2
5314807 2449472 2449472 defendant Menwet Richard husbandman 590974 590974 Menwet, Richard, of Gosberkyrk, husbandman 3
5314808 2449472 2449472 defendant Menwet William husbandman 590974 590974 Menwet, William, of Gosberkyrk, husbandman 4
5330697 2454259 2454259 plaintiff Boll John esq 590974 590974 Boll, John, of Gosberkyrk, esq 0
5332752 2454865 2454865 defendant Saverey or Sawerey Robert husbandman 590974 590974 Saverey or Sawerey, Robert, of Gosberkyrk, husbandman 1
5332753 2454865 2454865 defendant Thakker Robert husbandman 590974 590974 Thakker, Robert, of Gosberkyrk, husbandman 2
5332754 2454865 2454865 defendant Saverey or Sawerey Richard husbandman 590974 590974 Saverey or Sawerey, Richard, of Gosberkyrk, husbandman 3
5337507 2456291 2456291 defendant Teryngton Thomas tinker 590974 590974 Teryngton, Thomas, of Gosberkyrk, tinker 6
5343822 2458250 2458250 defendant Stybard John husbandman 590974 590974 Stybard, John, of Gosberkyrk, husbandman 0
5343823 2458250 2458250 defendant Spark Robert husbandman 590974 590974 Spark, Robert, of Gosberkyrk, husbandman 1
5349762 2460064 2460064 plaintiff Cheyll William (legal representative) 590974 590974 Cheyll, William, of Gosberkyrk, executors of 0
5349764 2460064 2460064 plaintiff Cheyll Thomas   590974 590974 Cheyll, Thomas, of Gosberkyrk 2
5358608 2462754 2462754 defendant Beysboll John chaplain 590974 590974 Beysboll, John, of Gosberkyrk, chaplain 0
5361078 2463491 2463491 defendant Dyconson Lawrence husbandman 590974 590974 Dyconson, Lawrence, of Gosberkyrk, husbandman 0
5363749 2464313 2464313 defendant Yongwyn Robert   590974 590974 Yongwyn, Robert, of Gosberkyrk, cartwright 0
5363750 2464313 2464313 defendant Yongwyn Robert carpenter or housewright 590974 590974 Yongwyn, Robert, of Gosberkyrk, carpenter or housewright 1
5364846 2464670 2464670 defendant Reme William laborer 590974 590974 Reme, William, of Gosberkyrk, laborer 0
5384531 2470660 2470660 defendant Thorp Adam yeoman 590974 590974 Thorp, Adam, of Gosberkyrk, yeoman 0
5384535 2470662 2470662 plaintiff Bolle John, senior   590974 590974 Bolle, John, senior, of Gosberkyrk 0
5386889 2471313 2471313 defendant Bowesyng John husbandman 590974 590974 Bowesyng, John, of Gosberkyrk, husbandman 1
5396376 2474056 2474056 defendant Thorp Adam yeoman 590974 590974 Thorp, Adam, of Gosberkyrk, yeoman 0
5396380 2474058 2474058 plaintiff Bolle John, senior   590974 590974 Bolle, John, senior, of Gosberkyrk 0
5409343 2477765 2477765 plaintiff Belle John, sen   590974 590974 Belle, John, sen, of Gosberkyrk 0
5409687 2477872 2477872 defendant Thorp Adam yeoman 590974 590974 Thorp, Adam, of Gosberkyrk, yeoman 0
5423323 2481936 2481936 defendant Thorp Adam yeoman 590974 590974 Thorp, Adam, of Gosberkyrk, yeoman 0
5443965 2488115 2488115 defendant Frauncy William laborer 590974 590974 Frauncy, William, of Gosberkyrk, laborer 0
5460033 2492933 2492933 plaintiff Hunyngham Richard   590974 590974 Hunyngham, Richard, of Gosberkyrk, administrators of 0
5468575 2495543 2495543 defendant Baseball John clerk 590974 590974 Baseball, John, of Gosberkyrk, clerk 0
5471648 2496470 2496470 plaintiff Hunnyngham Richard   590974 590974 Hunnyngham, Richard, of Gosberkyrk, administrators of 0
5479796 2498967 2498967 defendant Remey William husbandman 590974 590974 Remey, William, of Gosberkyrk, husbandman 0
5490477 2502046 2502046 defendant Philip John yeoman 590974 590974 Philip, John, of Gosberkyrk, yeoman 0
5490478 2502046 2502046 defendant Nevale Robert tailor 590974 590974 Nevale, Robert, of Gosberkyrk, tailor 1
5490479 2502046 2502046 defendant Warde Thomas shoemaker 590974 590974 Warde, Thomas, of Gosberkyrk, shoemaker 2
5490480 2502046 2502046 defendant Rymy Thomas husbandman 590974 590974 Rymy, Thomas, of Gosberkyrk, husbandman 3
5490481 2502046 2502046 defendant Bele Katherine widow 590974 590974 Bele, Katherine, of Gosberkyrk, widow 4
5490482 2502047 2502047 plaintiff Bolles Thomas gent 590974 590974 Bolles, Thomas, of Gosberkyrk, gent 0
5490483 2502047 2502047 defendant Edmunde Thomas, senior (legal representative) 590974 590974 Edmunde, Thomas, senior, of Gosberkyrk, executors of 0
5505394 2506602 2506602 defendant Philip John yeoman 590974 590974 Philip, John, of Gosberkyrk, yeoman 0
5505395 2506602 2506602 defendant Nevale Robert tailor 590974 590974 Nevale, Robert, of Gosberkyrk, tailor 1
5505396 2506602 2506602 defendant Warde Thomas shoemaker 590974 590974 Warde, Thomas, of Gosberkyrk, shoemaker 2
5505397 2506602 2506602 defendant Rymy Thomas husbandman 590974 590974 Rymy, Thomas, of Gosberkyrk, husbandman 3
5505398 2506602 2506602 defendant Bele Katherine widow 590974 590974 Bele, Katherine, of Gosberkyrk, widow 4
5505400 2506603 2506603 defendant Edmunde Thomas, senior (legal representative) 590974 590974 Edmunde, Thomas, senior, of Gosberkyrk, executors of 0
5544539 2518401 2518401 defendant Reme William husbandman 590974 590974 Reme, William, of Gosberkyrk, husbandman 0
5569442 2525626 2525626 defendant Blakwell Thomas herdman 590974 590974 Blakwell, Thomas, of Gosberkyrk, herdman 3
5569444 2525627 2525627 defendant Reme William husbandman 590974 590974 Reme, William, of Gosberkyrk, 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);