names

49 rows where place_id = 593085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610369 1870902 1870902 defendant Williams John tailor 593085 593085 Williams, John, of Alveston, tailor 0
3610370 1870902 1870902 defendant Roche John husbandman 593085 593085 Roche, John, of Alveston, husbandman 1
3770282 1948375 1948375 defendant Spencer George husbandman 593085 593085 Spencer, George, of Alveston, husbandman 0
4136432 2073371 2073371 defendant Vyall alias Harrys John husbandman 593085 593085 Vyall alias Harrys, John, of Alveston, husbandman 2
4160749 2081837 2081837 defendant Vyall alias Harris John husbandman 593085 593085 Vyall alias Harris, John, of Alveston, husbandman 2
4319248 2136843 2136843 defendant Haynes Thomas yeoman 593085 593085 Haynes, Thomas, of Alveston, yeoman 1
4403417 2165711 2165711 defendant Pearse William gent 593085 593085 Pearse, William, of Alveston, gent 0
4439866 2181747 2181747 defendant Brouneman John   593085 593085 Brouneman, John, of Alveston 0
4453344 2186052 2186052 defendant Compton John   593085 593085 Compton, John, of Alveston, vicar 0
4501403 2201042 2201042 defendant Shepherd John   593085 593085 Shepherd, John, of Alveston 2
4501404 2201042 2201042 defendant Clerk John   593085 593085 Clerk, John, of Alveston 3
4562553 2219846 2219846 defendant Williams David   593085 593085 Williams, David, of Alveston 0
4578503 2224767 2224767 defendant Jowkyns John   593085 593085 Jowkyns, John, of Alveston, vicar 1
4633141 2241232 2241232 defendant Cook David   593085 593085 Cook, David, of Alveston, park man 0
4646252 2244976 2244976 defendant Hobbes Thomas   593085 593085 Hobbes, Thomas, of Alveston 0
4668824 2255956 2255956 defendant Shepherd Henry laborer 593085 593085 Shepherd, Henry, of Alveston, laborer 0
4691772 2262958 2262958 defendant Veel Nicholas husbandman 593085 593085 Veel, Nicholas, of Alveston, husbandman 3
4711055 2268810 2268810 defendant del More Richard yeoman 593085 593085 del More, Richard, of Alveston, yeoman 0
4717586 2270835 2270835 defendant Howes Thomas   593085 593085 Howes, Thomas, of Alveston, plough man 3
4726635 2273602 2273602 defendant Westlove William husbandman 593085 593085 Westlove, William, of Alveston, husbandman 0
4764105 2284762 2284762 defendant Jowekyn John clerk 593085 593085 Jowekyn, John, of Alveston, clerk 0
4771279 2286998 2286998 defendant Jowekyn John   593085 593085 Jowekyn, John, of Alveston, vicar 0
4784577 2291181 2291181 defendant Okelegh John   593085 593085 Okelegh, John, of Alveston, servant 1
4787674 2292215 2292215 defendant Westlane William husbandman 593085 593085 Westlane, William, of Alveston, husbandman 0
4802566 2296990 2296990 defendant Hore John husbandman 593085 593085 Hore, John, of Alveston, husbandman 0
4805666 2297981 2297981 defendant Lawe John husbandman 593085 593085 Lawe, John, of Alveston, husbandman 1
4833269 2306415 2306415 defendant Harwell Thomas esq 593085 593085 Harwell, Thomas, of Alveston, esq 0
4845337 2310054 2310054 defendant Man Richard husbandman 593085 593085 Man, Richard, of Alveston, husbandman 0
4856559 2313434 2313434 defendant Harewell Thomas esq 593085 593085 Harewell, Thomas, of Alveston, esq 0
4878568 2320241 2320241 defendant Couwerd John   593085 593085 Couwerd, John, of Alveston, shepherd 3
4896605 2325601 2325601 defendant Westlonde William husbandman 593085 593085 Westlonde, William, of Alveston, husbandman 2
4906733 2328691 2328691 defendant Westlonde William husbandman 593085 593085 Westlonde, William, of Alveston, husbandman 2
4908603 2329244 2329244 defendant Mersshe Roger barber 593085 593085 Mersshe, Roger, of Alveston, barber 2
5008325 2359323 2359323 defendant Hews William laborer 593085 593085 Hews, William, of Alveston, laborer 0
5012970 2360628 2360628 defendant Westlond William husbandman 593085 593085 Westlond, William, of Alveston, husbandman 0
5063746 2375690 2375690 defendant Cokfeld William weaver 593085 593085 Cokfeld, William, of Alveston, weaver 1
5063747 2375690 2375690 defendant Taylour Thomas tailor 593085 593085 Taylour, Thomas, of Alveston, tailor 2
5063752 2375691 2375691 defendant Cokfeld William weaver 593085 593085 Cokfeld, William, of Alveston, weaver 1
5063753 2375691 2375691 defendant Taylour Thomas tailor 593085 593085 Taylour, Thomas, of Alveston, tailor 2
5232181 2424987 2424987 defendant Denys Maurice esq 593085 593085 Denys, Maurice, of Alveston, esq 0
5360594 2463344 2463344 defendant Hilbrond Richard, senior butcher 593085 593085 Hilbrond, Richard, senior, of Alveston, butcher 3
5369471 2466044 2466044 defendant Hillebronde Richard, senior butcher 593085 593085 Hillebronde, Richard, senior, of Alveston, butcher 0
5374876 2467737 2467737 defendant Broke Richard smith 593085 593085 Broke, Richard, of Alveston, smith 0
5493841 2503064 2503064 defendant Hilbron Richard butcher 593085 593085 Hilbron, Richard, of Alveston, butcher 0
5495403 2503527 2503527 defendant Grenested William husbandman 593085 593085 Grenested, William, of Alveston, husbandman 0
5495404 2503527 2503527 defendant Pers Giles tailor 593085 593085 Pers, Giles, of Alveston, tailor 1
5495405 2503527 2503527 defendant Hycches Thomas smith 593085 593085 Hycches, Thomas, of Alveston, smith 2
5619665 2550009 2550009 defendant Grannse William   593085 593085 Grannse, William, of Alveston 0
5628572 2552905 2552905 defendant Hubert Thomas husbandman 593085 593085 Hubert, Thomas, of Alveston, 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);