names

46 rows where place_id = 615590

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649849 1910316 1910316 defendant Wattys John   615590 615590 Wattys, John, of Worsted, Norf, worsted weaver 2
3649854 1910317 1910317 defendant Wattys John   615590 615590 Wattys, John, of Worsted, Norf, worsted weaver 2
3665007 1915001 1915001 defendant Auncell John   615590 615590 Auncell, John, of Worsted, Norf, worsted weaver 0
3709652 1929328 1929328 defendant Newman Richard draper 615590 615590 Newman, Richard, of Worsted, Norf, draper 0
3709654 1929329 1929329 defendant Newman Richard draper 615590 615590 Newman, Richard, of Worsted, Norf, draper 0
3836324 1969268 1969268 defendant Newman Richard draper 615590 615590 Newman, Richard, of Worsted, Norf, draper 2
3864581 1978350 1978350 defendant Fawcett Henry husbandman 615590 615590 Fawcett, Henry, of Worsted, Norf, husbandman 1
3983495 2018870 2018870 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 0
4019658 2031758 2031758 defendant Chapman Nicholas mercer 615590 615590 Chapman, Nicholas, of Worsted, Norf, mercer 0
4026428 2034097 2034097 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 1
4026433 2034098 2034098 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 1
4026882 2034265 2034265 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 1
4026886 2034266 2034266 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 1
4038525 2038418 2038418 defendant Leverton or Leverinton Cuthbert gent 615590 615590 Leverton or Leverinton, Cuthbert, of Worsted, Norf, gent 0
4038529 2038419 2038419 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 0
4042774 2039887 2039887 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 0
4042776 2039888 2039888 defendant Leverton Cuthbert gent 615590 615590 Leverton, Cuthbert, of Worsted, Norf, gent 0
4117978 2066715 2066715 defendant Bridge John husbandman 615590 615590 Bridge, John, of Worsted, norf, husbandman 0
4190271 2092101 2092101 defendant Goulde Robert clerk 615590 615590 Goulde, Robert, of Worsted, Norf, clerk 7
4310983 2133987 2133987 defendant Symond John yeoman 615590 615590 Symond, John, of Worsted, Norf, yeoman 0
4325259 2138827 2138827 defendant Evinell Robert chapman 615590 615590 Evinell, Robert, of Worsted, Norf, chapman 2
4367052 2153272 2153272 defendant Guye William shoemaker 615590 615590 Guye, William, of Worsted, Norf, yeoman, shoemaker 0
4862437 2315253 2315253 defendant Bunsted Thomas gent 615590 615590 Bunsted, Thomas, of Worsted, Norf, gent 2
4928922 2335469 2335469 defendant Sparhauke Adam husbandman 615590 615590 Sparhauke, Adam, of Worsted, Norf, husbandman 0
5000072 2356906 2356906 defendant Sprygy Thomas chapman 615590 615590 Sprygy, Thomas, of Worsted, Norf, chapman 1
5002287 2357574 2357574 defendant Gyme Robert chapman 615590 615590 Gyme, Robert, of Worsted, Norf, chapman 1
5002577 2357666 2357666 defendant Grynne Robert chapman 615590 615590 Grynne, Robert, of Worsted, Norf, chapman 3
5012828 2360585 2360585 defendant Sparhawk Robert yeoman 615590 615590 Sparhawk, Robert, of Worsted, Norf, yeoman 2
5038980 2368304 2368304 plaintiff Baret Adam   615590 615590 Baret, Adam, of Worsted, Norf, worsted weaver 0
5108490 2388920 2388920 defendant Burgh Nicholas chapman 615590 615590 Burgh, Nicholas, of Worsted, Norf, chapman 1
5184892 2411331 2411331 defendant Burgh Nicholas chapman 615590 615590 Burgh, Nicholas, of Worsted, Norf, chapman 0
5196671 2414778 2414778 defendant Burgh Nicholas mercer 615590 615590 Burgh, Nicholas, of Worsted, Norf, mercer 0
5202608 2416526 2416526 defendant Ony or Ovy or Quy Walter laborer 615590 615590 Ony or Ovy or Quy, Walter, of Worsted, Norf, laborer 3
5245209 2428753 2428753 defendant Deye Nicholas raffman 615590 615590 Deye, Nicholas, of Worsted, Norf, raffman 1
5262781 2434101 2434101 defendant Heyham Isabel widow 615590 615590 Heyham, Isabel, of Worsted , Norf, widow 1
5294309 2443309 2443309 defendant Clerk Nicholas chapman 615590 615590 Clerk, Nicholas, of Worsted, Norf, chapman 2
5396296 2474031 2474031 defendant Blome John butcher 615590 615590 Blome, John, of Worsted, Norf, butcher 0
5398625 2474669 2474669 defendant Barman John mercer 615590 615590 Barman, John, of Worsted, Norf, mercer 0
5398948 2474769 2474769 defendant Carman John merchant 615590 615590 Carman, John, of Worsted, Norf, merchant 0
5411747 2478465 2478465 defendant Carman John mercer 615590 615590 Carman, John, of Worsted, Norf, mercer 0
5537424 2516199 2516199 defendant Jane William husbandman 615590 615590 Jane, William, of Worsted, Norf, husbandman 0
5542516 2517782 2517782 defendant Carman Robert chapman 615590 615590 Carman, Robert, of Worsted, Norf, chapman 1
5587238 2531033 2531033 defendant Carman Robert chapman 615590 615590 Carman, Robert, of Worsted, Norf, chapman 0
5603016 2535829 2535829 defendant Hochyns Edward   615590 615590 Hochyns, Edward, of Worsted, Norf, worsted weaver 2
5603021 2535830 2535830 defendant Hochyns Edward   615590 615590 Hochyns, Edward, of Worsted, Norf, worsted weaver 2
5604346 2536223 2536223 defendant Gamon Robert chapman 615590 615590 Gamon, Robert, of Worsted, Norf, chapman 1

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