names

26 rows where place_id = 593889

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613744 1871949 1871949 defendant Ingell John husbandman 593889 593889 Ingell, John, of Cotenham, husbandman 2
3715786 1931226 1931226 defendant Cooke John butcher 593889 593889 Cooke, John, of Cotenham, butcher 0
3813929 1962266 1962266 defendant Sygar William husbandman 593889 593889 Sygar, William, of Cotenham, husbandman 0
4455616 2186766 2186766 defendant Swon Robert   593889 593889 Swon, Robert, of Cotenham 1
4498040 2200035 2200035 defendant Draper John   593889 593889 Draper, John, of Cotenham 0
4609251 2233997 2233997 plaintiff Bruggeman John   593889 593889 Bruggeman, John, of Cotenham 0
4637575 2242541 2242541 defendant Ferrour John   593889 593889 Ferrour, John, of Cotenham 0
4693321 2263413 2263413 defendant Lebyngton Thomas husbandman 593889 593889 Lebyngton, Thomas, of Cotenham, husbandman 2
4713673 2269600 2269600 defendant Webbe John husbandman 593889 593889 Webbe, John, of Cotenham, husbandman 3
4742094 2278181 2278181 defendant Clerk John chaplain 593889 593889 Clerk, John, of Cotenham, chaplain 4
4745235 2279113 2279113 defendant Stanard Thomas smith 593889 593889 Stanard, Thomas, of Cotenham, smith 0
4763624 2284609 2284609 defendant Briggeman John yeoman 593889 593889 Briggeman, John, of Cotenham, yeoman 0
4773908 2287818 2287818 defendant Briggeman John husbandman 593889 593889 Briggeman, John, of Cotenham, husbandman 2
4802966 2297113 2297113 defendant Smyth Nicholas yeoman 593889 593889 Smyth, Nicholas, of Cotenham, yeoman 0
4811139 2299592 2299592 defendant Briggeman John yeoman 593889 593889 Briggeman, John, of Cotenham, yeoman 0
4815473 2300944 2300944 defendant Briggeman John husbandman 593889 593889 Briggeman, John, of Cotenham, husbandman 1
4879694 2320568 2320568 defendant Briggeman John husbandman 593889 593889 Briggeman, John, of Cotenham, husbandman 3
4894659 2325000 2325000 defendant Warwyk Thomas husbandman 593889 593889 Warwyk, Thomas, of Cotenham, husbandman 1
4928825 2335437 2335437 plaintiff Sperner Walter   593889 593889 Sperner, Walter, of Cotenham, on his own account 0
5072566 2378281 2378281 defendant May Henry husbandman 593889 593889 May, Henry, of Cotenham, husbandman 2
5180868 2410147 2410147 defendant Adam Thomas husbandman 593889 593889 Adam, Thomas, of Cotenham, husbandman 2
5349771 2460067 2460067 defendant Palmer Roger husbandman 593889 593889 Palmer, Roger, of Cotenham, husbandman 0
5616250 2548876 2548876 plaintiff Herd Richard   593889 593889 Herd, Richard, of Cotenham 0
5621941 2550773 2550773 defendant Heerd Richard   593889 593889 Heerd, Richard, of Cotenham 0
5629178 2553101 2553101 defendant Breggeman John husbandman 593889 593889 Breggeman, John, of Cotenham, husbandman 0
5632909 2554299 2554299 defendant Breggeman John husbandman 593889 593889 Breggeman, John, of Cotenham, husbandman 3

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