names

68 rows where place_id = 586115

✎ 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
3587970 1863891 1863891 plaintiff Baker John gent 586115 586115 Baker, John, of Lamport, Soms, gent 0
3703675 1927429 1927429 defendant Hewisshe John chapman 586115 586115 Hewisshe, John, of Lamport, Soms, chapman 4
3866661 1979082 1979082 defendant Serrell John chapman 586115 586115 Serrell, John, of Lamport, Soms, chapman 0
4190999 2092415 2092415 defendant Salmon John chapman 586115 586115 Salmon, John, of Lamport, Soms, chapman 0
4323553 2138294 2138294 defendant Wolmyngton William yeoman 586115 586115 Wolmyngton, William, of Lamport, Soms, yeoman 3
4463683 2189335 2189335 defendant Deyer Adam   586115 586115 Deyer, Adam, of Lamport, Soms 1
4463774 2189351 2189351 defendant Deyer Adam   586115 586115 Deyer, Adam, of Lamport, Soms 1
4472932 2192207 2192207 defendant Gbym John   586115 586115 Gbym, John, of Lamport, Soms 1
4558969 2218767 2218767 defendant Bovy Richard   586115 586115 Bovy, Richard, of Lamport, Soms 4
4558985 2218770 2218770 defendant Bony or Bovy Richard   586115 586115 Bony or Bovy, Richard, of Lamport, Soms 3
4558991 2218771 2218771 defendant Bony Richard   586115 586115 Bony, Richard, of Lamport, Soms 3
4621093 2237580 2237580 defendant Wynter Benedict   586115 586115 Wynter, Benedict, of Lamport, Soms 2
4621094 2237580 2237580 defendant Davy John chapman 586115 586115 Davy, John, of Lamport, Soms, chapman 3
4663814 2250166 2250166 defendant Grym John husbandman 586115 586115 Grym, John, of Lamport, Soms, husbandman 1
4665324 2250643 2250643 defendant Plommer Richard dyer 586115 586115 Plommer, Richard, of Lamport, Soms, dyer 2
4666062 2250854 2250854 defendant Betfeld John fisher 586115 586115 Betfeld, John, of Lamport Estover, Soms, fisher 3
4727664 2273894 2273894 defendant Wynter Benedict chapman 586115 586115 Wynter, Benedict, of Lamport, Soms, chapman 1
4751573 2280946 2280946 defendant Bryme John yeoman 586115 586115 Bryme, John, of Lamport, Soms, yeoman 3
4765856 2285317 2285317 defendant Davy John chapman 586115 586115 Davy, John, of Lamport, Soms, chapman 2
4765863 2285318 2285318 defendant Davy John chapman 586115 586115 Davy, John, of Lamport, Soms, chapman 2
4765864 2285318 2285318 defendant Wynter Benedict chapman 586115 586115 Wynter, Benedict, of Lamport, Soms, chapman 3
4814377 2300605 2300605 defendant Grymes John yeoman 586115 586115 Grymes, John, of Lamport, Soms, yeoman 3
4841010 2308723 2308723 defendant Wynte Benedict chapman 586115 586115 Wynte, Benedict, of Lamport, Soms, chapman 1
4861624 2315009 2315009 defendant Gryndale Henry yeoman 586115 586115 Gryndale, Henry, of Lamport, Soms, yeoman 0
4882860 2321557 2321557 defendant Bowes William dyer 586115 586115 Bowes, William, of Lamport, Soms, dyer 1
4886435 2322616 2322616 defendant Briggyngton Richard glover 586115 586115 Briggyngton, Richard, of Lamport, Soms, glover 4
4890285 2323731 2323731 defendant Bowes William dyer 586115 586115 Bowes, William, of Lamport, Soms, dyer 1
4901609 2327105 2327105 defendant Turnoure Richard chapman 586115 586115 Turnoure, Richard, of Lamport, Soms, chapman 4
4901961 2327216 2327216 defendant Briggyngton Richard glover 586115 586115 Briggyngton, Richard, of Lamport, Soms, glover 4
4907522 2328915 2328915 defendant Turnoure Richard chapman 586115 586115 Turnoure, Richard, of Lamport, Soms, chapman 4
4920468 2332917 2332917 defendant Cook Thomas spicer 586115 586115 Cook, Thomas, of Lamport, Soms, spicer 0
4920470 2332917 2332917 defendant Tyler John   586115 586115 Tyler, John, of Lamport, Soms, bottle maker 2
4932119 2336441 2336441 defendant Tourner Richard mercer 586115 586115 Tourner, Richard, of Lamport, Soms, mercer 2
4934679 2337238 2337238 defendant Westmore John mercer 586115 586115 Westmore, John, of Lamport, Soms, mercer 0
4934681 2337239 2337239 defendant Westmore John mercer 586115 586115 Westmore, John, of Lamport, Soms, mercer 0
4937581 2338129 2338129 defendant Holton John esq 586115 586115 Holton, John, of Lamport, Soms, esq 0
4942439 2339621 2339621 defendant Smyth alias Wever Thomas weaver 586115 586115 Smyth alias Wever, Thomas, of Lamport, Soms, weaver 2
4952315 2342656 2342656 defendant Houpere Robert yeoman 586115 586115 Houpere, Robert, of Lamport Estover, Soms, yeoman 0
4954639 2343344 2343344 defendant Baker John dyer 586115 586115 Baker, John, of Lamport, Soms, dyer 3
4963423 2345971 2345971 defendant Awde John chapman 586115 586115 Awde, John, of Lamport, Soms, chapman 2
5019787 2362668 2362668 defendant Holton John esq 586115 586115 Holton, John, of Lamport, Soms, esq 0
5104516 2387749 2387749 defendant Padok John draper 586115 586115 Padok, John, of Lamport, Soms, draper 0
5194251 2414050 2414050 defendant Tailour John   586115 586115 Tailour, John, of Lamport, Soms, bottle maker 2
5208669 2418258 2418258 defendant Taillour John   586115 586115 Taillour, John, of Lamport, Soms, bottle maker 2
5216588 2420581 2420581 defendant Halton John esq 586115 586115 Halton, John, of Lamport, Soms, esq 0
5229545 2424254 2424254 defendant Traynsham Thomas dyer 586115 586115 Traynsham, Thomas, of Lamport Estover, Soms, dyer 2
5232930 2425215 2425215 defendant Rye Simon merchant 586115 586115 Rye, Simon, of Lamport Estover, Soms, merchant 0
5264031 2434509 2434509 defendant Rye Simon husbandman 586115 586115 Rye, Simon, of Lamport, Soms, husbandman 4
5273211 2437234 2437234 defendant Straynsham Thomas dyer 586115 586115 Straynsham, Thomas, of Lamport, Soms, dyer 1
5284210 2440402 2440402 defendant Rye Simon merchant 586115 586115 Rye, Simon, of Lamport Estover, Soms, merchant 1
5364414 2464533 2464533 defendant Longe William chapman 586115 586115 Longe, William, of Lamport, soms, chapman 1
5379952 2469314 2469314 defendant Longe William chapman 586115 586115 Longe, William, of Lamport, Soms, chapman 1
5383513 2470369 2470369 defendant Long William chapman 586115 586115 Long, William, of Lamport, Soms, chapman 0
5424857 2482396 2482396 defendant Baker John gent 586115 586115 Baker, John, of Lamport, Soms, gent 0
5424859 2482397 2482397 defendant Baler John gent 586115 586115 Baler, John, of Lamport, Soms, gent 0
5439872 2486868 2486868 defendant Lynam William baker 586115 586115 Lynam, William, of Lamport Estover, Soms, baker 0
5465654 2494639 2494639 defendant Lynam William baker 586115 586115 Lynam, William, of Lamport Estover, Soms, baker 0
5477164 2498177 2498177 defendant Lynam William baker 586115 586115 Lynam, William, of Lamport Estover, Soms, baker 0
5482688 2499767 2499767 defendant Lynkham William mecer 586115 586115 Lynkham, William, of Lamport, Soms, mecer 0
5494626 2503280 2503280 defendant Byrd John clothmaker 586115 586115 Byrd, John, of Lamport, Soms, clothmaker 0
5505503 2506638 2506638 defendant Baker John gent 586115 586115 Baker, John, of Lamport, Soms, gent 0
5534609 2515366 2515366 plaintiff Baker John   586115 586115 Baker, John, of Lamport, Soms 0
5534613 2515367 2515367 plaintiff Baker John   586115 586115 Baker, John, of Lamport, Soms 0
5556363 2521855 2521855 defendant Ede John baker 586115 586115 Ede, John, of Lamport, Soms, baker 5
5559129 2522631 2522631 defendant Raynold John clothman 586115 586115 Raynold, John, of Lamport, Soms, clothman 2
5568078 2525213 2525213 defendant Whyte John dyer 586115 586115 Whyte, John, of Lamport, Soms, dyer 1
5587530 2531115 2531115 defendant Wyldecombe John gent 586115 586115 Wyldecombe, John, of Lamport, Soms, gent 0
5589257 2531647 2531647 defendant Davy Thomas clothier 586115 586115 Davy, Thomas, of Lamport, Soms, clothier 2

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);