names

23 rows where place_id = 589155

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596710 1866606 1866606 defendant Routh Henry yeoman 589155 589155 Routh, Henry, of Magna Dryffeld, yeoman 0
3624158 1875086 1875086 defendant Peirson William husbandman 589155 589155 Peirson, William, of Magna Dryffeld, husbandman 0
3651119 1910717 1910717 defendant Hogeson Robert husbandman 589155 589155 Hogeson, Robert, of Magna Dryffeld, husbandman 0
3651120 1910717 1910717 defendant Hellerd Katherine spinster 589155 589155 Hellerd, Katherine, of Magna Dryffeld, spinster 1
3700131 1926272 1926272 defendant Taillour John laborer 589155 589155 Taillour, John, of Magna Dryffeld, laborer 0
3719283 1932316 1932316 defendant Temson William husbandman 589155 589155 Temson, William, of Magna Dryffeld, husbandman 1
3884768 1985180 1985180 defendant Chapleyn Andrew laborer 589155 589155 Chapleyn, Andrew, of Magna Dryffeld, laborer 1
4659281 2248771 2248771 defendant Mawe Walter fleshewer or butcher 589155 589155 Mawe, Walter, of Magna Dryffeld, fleshewer or butcher 0
4659282 2248771 2248771 defendant Chapman William fleshewer or butcher 589155 589155 Chapman, William, of Magna Dryffeld, fleshewer or butcher 1
4776740 2288715 2288715 defendant Benet Thomas husbandman 589155 589155 Benet, Thomas, of Magna Dryffeld, husbandman 0
4797077 2295253 2295253 defendant Garton Richard husbandman 589155 589155 Garton, Richard, of Magna Dryffeld, husbandman 1
4953657 2343057 2343057 defendant Campyon William shoemaker 589155 589155 Campyon, William, of Magna Dryffeld, shoemaker 2
5027803 2365011 2365011 defendant Benson Robert yeoman 589155 589155 Benson, Robert, of Magna Dryffeld, yeoman 0
5036603 2367571 2367571 defendant Benet Thomas butcher 589155 589155 Benet, Thomas, of Magna Dryffeld, butcher 0
5069000 2377223 2377223 defendant Routh or Rouch Brian gent 589155 589155 Routh or Rouch, Brian, of Magna Dryffeld, gent 0
5070922 2377795 2377795 defendant Kynyowe John husbandman 589155 589155 Kynyowe, John, of Magna Dryffeld, husbandman 1
5094423 2384775 2384775 defendant Symson Robert laborer 589155 589155 Symson, Robert, of Magna Dryffeld, laborer 0
5094427 2384776 2384776 defendant Raper William chaplain 589155 589155 Raper, William, of Magna Dryffeld, chaplain 1
5094428 2384776 2384776 defendant Benson Richard miller 589155 589155 Benson, Richard, of Magna Dryffeld, miller 2
5094429 2384776 2384776 defendant Raper John   589155 589155 Raper, John, of Magna Dryffeld, servant 3
5101270 2386781 2386781 defendant Rasyn John husbandman 589155 589155 Rasyn, John, of Magna Dryffeld, husbandman 0
5124378 2393576 2393576 defendant Benet John husbandman 589155 589155 Benet, John, of Magna Dryffeld, husbandman 0
5535538 2515643 2515643 defendant Routh Henry gent 589155 589155 Routh, Henry, of Magna Dryffeld, gent 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);