names

43 rows where place_id = 588921

✎ 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
3596003 1866379 1866379 defendant Warner Thomas husbandman 588921 588921 Warner, Thomas, of Flamstede, husbandman 2
3596004 1866379 1866379 defendant Chalfount John husbandman 588921 588921 Chalfount, John, of Flamstede, husbandman 3
3596005 1866379 1866379 defendant Brygge Agnes widow 588921 588921 Brygge, Agnes, of Flamstede, widow 4
3618735 1873481 1873481 defendant Williams John smith 588921 588921 Williams, John, of Flamstede, smith 1
3704347 1927662 1927662 defendant Grigge Robert husbandman 588921 588921 Grigge, Robert, of Flamstede, husbandman 0
3754774 1943449 1943449 defendant Cokerell Thomas husbandman 588921 588921 Cokerell, Thomas, of Flamstede, husbandman 1
3888951 1986548 1986548 defendant Wyte John husbandman 588921 588921 Wyte, John, of Flamstede, husbandman 0
4002608 2025704 2025704 defendant Pecok William yeoman 588921 588921 Pecok, William, of Flamstede, yeoman 1
4122077 2068199 2068199 defendant Doggatt Robert yeoman 588921 588921 Doggatt, Robert, of Flamstede, yeoman 0
4122079 2068200 2068200 defendant Doggatt Robert yeoman 588921 588921 Doggatt, Robert, of Flamstede, yeoman 0
4142806 2075658 2075658 defendant Higden Walter husbandman 588921 588921 Higden, Walter, of Flamstede, husbandman 0
4168817 2084584 2084584 defendant Belgrave William yeoman 588921 588921 Belgrave, William, of Flamstede, yeoman 0
4447428 2184108 2184108 defendant Sexteyn John   588921 588921 Sexteyn, John, of Flamstede 0
4509972 2203603 2203603 defendant Smyth Thomas   588921 588921 Smyth, Thomas, of Flamstede 0
4538953 2212454 2212454 defendant Bradewyn John   588921 588921 Bradewyn, John, of Flamstede 5
4538961 2212455 2212455 defendant Bradewyn John   588921 588921 Bradewyn, John, of Flamstede 4
4538967 2212456 2212456 defendant Bradewyn John   588921 588921 Bradewyn, John, of Flamstede 4
4633247 2241268 2241268 plaintiff Warner William   588921 588921 Warner, William, of Flamstede 0
4669543 2256180 2256180 defendant Reynold John wheler 588921 588921 Reynold, John, of Flamstede, wheler 1
4669572 2256191 2256191 defendant Ballard John husbandman 588921 588921 Ballard, John, of Flamstede, husbandman 3
4725486 2273262 2273262 defendant Ballard John husbandman 588921 588921 Ballard, John, of Flamstede, husbandman 0
4873910 2318778 2318778 defendant Balsham William clerk 588921 588921 Balsham, William, of Flamstede, clerk 1
4873911 2318778 2318778 defendant Netmaker Henry husbandman 588921 588921 Netmaker, Henry, of Flamstede, husbandman 2
4898399 2326155 2326155 defendant Blythe John gent 588921 588921 Blythe, John, of Flamstede, gent 0
4945000 2340425 2340425 defendant Whitlok Roger laborer 588921 588921 Whitlok, Roger, of Flamstede, laborer 1
4945008 2340427 2340427 defendant Whitlok Roger laborer 588921 588921 Whitlok, Roger, of Flamstede, laborer 2
4994309 2355171 2355171 defendant Osbarn Agnes widow 588921 588921 Osbarn, Agnes, of Flamstede, widow 1
4995743 2355568 2355568 defendant Water John chaplain 588921 588921 Water, John, of Flamstede, chaplain 0
4995744 2355568 2355568 defendant Baker John butcher 588921 588921 Baker, John, of Flamstede, butcher 1
4995745 2355568 2355568 defendant Osbern Agnes widow 588921 588921 Osbern, Agnes, of Flamstede, widow 2
5075671 2379224 2379224 defendant Balsham John laborer 588921 588921 Balsham, John, of Flamstede, laborer 0
5118832 2391940 2391940 defendant Chalvehunt John husbandman 588921 588921 Chalvehunt, John, of Flamstede, husbandman 1
5195340 2414387 2414387 defendant Chalvehunt John husbandman 588921 588921 Chalvehunt, John, of Flamstede, husbandman 0
5344155 2458349 2458349 defendant Mathewe Robert butcher 588921 588921 Mathewe, Robert, of Flamstede, butcher 1
5348560 2459684 2459684 defendant Waterton Thomas husbandman 588921 588921 Waterton, Thomas, of Flamstede, husbandman 1
5348561 2459684 2459684 defendant Chalfunt John husbandman 588921 588921 Chalfunt, John, of Flamstede, husbandman 2
5348565 2459685 2459685 defendant Waterton Thomas husbandman 588921 588921 Waterton, Thomas, of Flamstede, husbandman 1
5348566 2459685 2459685 defendant Chalfunt John husbandman 588921 588921 Chalfunt, John, of Flamstede, husbandman 2
5362093 2463808 2463808 defendant Fynour John tanner 588921 588921 Fynour, John, of Flamstede, tanner 0
5362094 2463808 2463808 defendant Mathewe Robert butcher 588921 588921 Mathewe, Robert, of Flamstede, butcher 1
5362096 2463809 2463809 defendant Mathewe Robert butcher 588921 588921 Mathewe, Robert, of Flamstede, butcher 0
5362097 2463809 2463809 defendant Chalfunt John husbandman 588921 588921 Chalfunt, John, of Flamstede, husbandman 1
5362098 2463809 2463809 defendant Mosse Thomas husbandman 588921 588921 Mosse, Thomas, of Flamstede, husbandman 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);