names

63 rows where place_id = 627139

✎ 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
3774373 1949708 1949708 defendant Walton John, senior husbandman 627139 627139 Walton, John, senior, of Byfeld, husbandman 2
4413496 2169106 2169106 defendant Willes John   627139 627139 Willes, John, of Byfeld 0
4413498 2169107 2169107 defendant Willes John   627139 627139 Willes, John, of Byfeld 0
4416208 2169955 2169955 defendant Basset Roger   627139 627139 Basset, Roger, of Byfeld 0
4421247 2171541 2171541 defendant Willes John   627139 627139 Willes, John, of Byfeld 0
4421249 2171542 2171542 defendant Willes John   627139 627139 Willes, John, of Byfeld 0
4429368 2173991 2173991 plaintiff Verny Helen le   627139 627139 Verny, Helen le, of Byfeld, formerly wife of William, son of John 0
4553908 2217141 2217141 defendant Malyns Alexancer   627139 627139 Malyns, Alexancer, of Byfeld 0
4713572 2269565 2269565 defendant Sale John husbandman 627139 627139 Sale, John, of Byfeld, husbandman 0
4750613 2280666 2280666 plaintiff Robyns Hugh   627139 627139 Robyns, Hugh, of Byfeld 0
4776435 2288623 2288623 defendant Sale John yeoman 627139 627139 Sale, John, of Byfeld, yeoman 3
4811679 2299763 2299763 defendant Umfrey Richard husbandman 627139 627139 Umfrey, Richard, of Byfeld, husbandman 0
4844485 2309790 2309790 defendant Sale William husbandman 627139 627139 Sale, William, of Byfeld, husbandman 2
4849925 2311448 2311448 defendant Wakelayn Nicholas gent 627139 627139 Wakelayn, Nicholas, of Byfeld, gent 0
4849927 2311449 2311449 defendant Wakelayn Nicholas gent 627139 627139 Wakelayn, Nicholas, of Byfeld, gent 0
4861697 2315032 2315032 defendant Sale John husbandman 627139 627139 Sale, John, of Byfeld, husbandman 3
4863442 2315536 2315536 defendant Fauconer Nicholas gent 627139 627139 Fauconer, Nicholas, of Byfeld, gent 0
4877988 2320069 2320069 defendant Wakelayn Nicholas gent 627139 627139 Wakelayn, Nicholas, of Byfeld, gent 0
4902759 2327482 2327482 defendant Sale John butcher 627139 627139 Sale, John, of Byfeld, butcher 3
4915924 2331476 2331476 defendant Fauconer Nicholas gent 627139 627139 Fauconer, Nicholas, of Byfeld, gent 0
4941129 2339248 2339248 defendant Fauconer Nicholas gent 627139 627139 Fauconer, Nicholas, of Byfeld, gent 0
4944285 2340188 2340188 defendant Fauconer Nicholas gent 627139 627139 Fauconer, Nicholas, of Byfeld, gent 0
4969620 2347861 2347861 defendant Everdon Nicholas gent 627139 627139 Everdon, Nicholas, of Byfeld, gent 0
4990258 2353993 2353993 defendant Rivell Richard husbandman 627139 627139 Rivell, Richard, of Byfeld, husbandman 5
5054502 2372923 2372923 defendant Heynes John yeoman 627139 627139 Heynes, John, of Byfeld, yeoman 4
5054510 2372924 2372924 defendant Heynes John yeoman 627139 627139 Heynes, John, of Byfeld, yeoman 0
5077175 2379677 2379677 plaintiff Berughby Richard (legal representative) 627139 627139 Berughby, Richard, of Byfeld, husbandman, executor of 0
5077180 2379678 2379678 plaintiff Berughby Richard (legal representative) 627139 627139 Berughby, Richard, of Byfeld, husbandman, executor of 0
5077182 2379678 2379678 defendant Everdon Nicholas gent 627139 627139 Everdon, Nicholas, of Byfeld, gent 0
5102733 2387212 2387212 defendant Haynes William gent 627139 627139 Haynes, William, of Byfeld, gent 1
5113563 2390357 2390357 defendant Heynes William gent 627139 627139 Heynes, William, of Byfeld, gent 0
5129005 2394966 2394966 defendant Frenshe John husbandman 627139 627139 Frenshe, John, of Byfeld, husbandman 2
5138012 2397624 2397624 defendant Woffe William husbandman 627139 627139 Woffe, William, of Byfeld, husbandman 0
5138013 2397624 2397624 defendant Kyng William husbandman 627139 627139 Kyng, William, of Byfeld, husbandman 1
5147832 2400508 2400508 defendant Frenshe John husbandman 627139 627139 Frenshe, John, of Byfeld, husbandman 2
5148184 2400614 2400614 defendant Frenshe John husbandman 627139 627139 Frenshe, John, of Byfeld, husbandman 2
5163197 2404967 2404967 defendant Heynes William yeoman 627139 627139 Heynes, William, of Byfeld, yeoman 2
5167359 2406189 2406189 defendant Frenshe John husbandman 627139 627139 Frenshe, John, of Byfeld, husbandman 2
5182818 2410727 2410727 defendant Frenshe John husbandman 627139 627139 Frenshe, John, of Byfeld, husbandman 2
5187202 2411985 2411985 defendant Wolf William   627139 627139 Wolf, William, of Byfeld 0
5195430 2414413 2414413 defendant Freman Thomas husbandman 627139 627139 Freman, Thomas, of Byfeld, husbandman 0
5205526 2417362 2417362 defendant Wolf William   627139 627139 Wolf, William, of Byfeld 0
5285346 2440735 2440735 defendant Heynes William yeoman 627139 627139 Heynes, William, of Byfeld, yeoman 0
5285347 2440735 2440735 defendant Clerk John husbandman 627139 627139 Clerk, John, of Byfeld, husbandman 1
5285348 2440735 2440735 defendant Grenelef John husbandman 627139 627139 Grenelef, John, of Byfeld, husbandman 2
5285349 2440735 2440735 defendant Hony John husbandman 627139 627139 Hony, John, of Byfeld, husbandman 3
5285351 2440736 2440736 defendant Heynes William yeoman 627139 627139 Heynes, William, of Byfeld, yeoman 0
5285352 2440736 2440736 defendant Clerk John husbandman 627139 627139 Clerk, John, of Byfeld, husbandman 1
5285353 2440736 2440736 defendant Grenelef John husbandman 627139 627139 Grenelef, John, of Byfeld, husbandman 2
5285354 2440736 2440736 defendant Hony John husbandman 627139 627139 Hony, John, of Byfeld, husbandman 3
5294179 2443270 2443270 defendant Lynam Nicholas husbandman 627139 627139 Lynam, Nicholas, of Byfeld, husbandman 0
5386140 2471103 2471103 defendant Fyff_ William husbandman 627139 627139 Fyff_, William, of Byfeld, husbandman 2
5389626 2472095 2472095 defendant Waldren Richard   627139 627139 Waldren, Richard, of Byfeld 0
5402407 2475760 2475760 defendant Waldren Richard butcher 627139 627139 Waldren, Richard, of Byfeld, butcher 0
5415344 2479524 2479524 defendant Waldren Richard butcher 627139 627139 Waldren, Richard, of Byfeld, butcher 0
5415347 2479525 2479525 defendant Waldren Richard butcher 627139 627139 Waldren, Richard, of Byfeld, butcher 0
5478056 2498460 2498460 defendant Waldron Richard butcher 627139 627139 Waldron, Richard, of Byfeld, butcher 1
5504309 2506262 2506262 defendant Albon John husbandman 627139 627139 Albon, John, of Byfeld, husbandman 0
5560496 2523029 2523029 defendant Malbusshe Edmund husbandman 627139 627139 Malbusshe, Edmund, of Byfeld, husbandman 0
5607360 2537196 2537196 defendant Malbusshe alias Corryer Edmund husbandman 627139 627139 Malbusshe alias Corryer, Edmund, of Byfeld, husbandman 0
5626436 2552240 2552240 plaintiff Molynton Hugh   627139 627139 Molynton, Hugh, of Byfeld 0
5626438 2552241 2552241 plaintiff Molynton Hugh   627139 627139 Molynton, Hugh, of Byfeld 0
5626440 2552242 2552242 plaintiff Molynton Hugh   627139 627139 Molynton, Hugh, of Byfeld 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);