names

33 rows where place_id = 618561

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3725275 1934195 1934195 defendant Carver Robert smith 618561 618561 Carver, Robert, of Magna Stoughton, smith 1
3800947 1958206 1958206 defendant Parell Edmund husbandman 618561 618561 Parell, Edmund, of Magna Stoughton, husbandman 0
4284071 2124348 2124348 defendant Bigg Owen yeoman 618561 618561 Bigg, Owen, of Magna Stoughton, yeoman 0
4284072 2124348 2124348 defendant Stoddye or Studdye John laborer 618561 618561 Stoddye or Studdye, John, of Magna Stoughton, laborer 1
4284073 2124348 2124348 defendant Colemere or Colemorth William laborer 618561 618561 Colemere or Colemorth, William, of Magna Stoughton, laborer 2
4665759 2250766 2250766 defendant Warde William chaplain 618561 618561 Warde, William, of Magna Stoughton, chaplain 0
4665761 2250767 2250767 defendant Warde William chaplain 618561 618561 Warde, William, of Magna Stoughton, chaplain 0
4780286 2289836 2289836 defendant Taillour John husbandman 618561 618561 Taillour, John, of Magna Stoughton, husbandman 0
4783139 2290741 2290741 defendant Smyth John farmer 618561 618561 Smyth, John, of Magna Stoughton, farmer 0
4787001 2292001 2292001 defendant Roberdstonhamesbotiller Edmund yeoman 618561 618561 Roberdstonhamesbotiller, Edmund, of Magna Stoughton, yeoman 2
4787002 2292001 2292001 defendant Smyth John husbandman 618561 618561 Smyth, John, of Magna Stoughton, husbandman 3
4787003 2292001 2292001 defendant Cokkowe John tailor 618561 618561 Cokkowe, John, of Magna Stoughton, tailor 4
4787005 2292001 2292001 defendant Devyle Thomas yeoman 618561 618561 Devyle, Thomas, of Magna Stoughton, yeoman 6
4855733 2313167 2313167 defendant Hynde John husbandman 618561 618561 Hynde, John, of Magna Stoughton, husbandman 0
4855734 2313167 2313167 defendant Taillour Henry husbandman 618561 618561 Taillour, Henry, of Magna Stoughton, husbandman 1
4891217 2323987 2323987 defendant Botle Robert gent 618561 618561 Botle, Robert, of Magna Stoughton, gent 0
4891218 2323987 2323987 defendant Botle Williaam gent 618561 618561 Botle, Williaam, of Magna Stoughton, gent 1
4946687 2340964 2340964 defendant Smyth John husbandman 618561 618561 Smyth, John, of Magna Stoughton, husbandman 2
5020806 2362982 2362982 defendant Pawell Thomas clerk 618561 618561 Pawell, Thomas, of Magna Stoughton, clerk 0
5020807 2362982 2362982 defendant Gybbys William smith 618561 618561 Gybbys, William, of Magna Stoughton, smith 1
5020808 2362982 2362982 defendant Ivot John husbandman 618561 618561 Ivot, John, of Magna Stoughton, husbandman 2
5020809 2362982 2362982 defendant Smyth John husbandman 618561 618561 Smyth, John, of Magna Stoughton, husbandman 3
5111479 2389751 2389751 defendant Manne John gent 618561 618561 Manne, John, of Magna Stoughton, gent 0
5116911 2391372 2391372 defendant Crowe John husbandman 618561 618561 Crowe, John, of Magna Stoughton, husbandman 0
5348583 2459690 2459690 defendant Wake John gent 618561 618561 Wake, John, of Magna Stoughton, gent 0
5348584 2459690 2459690 defendant Cook John   618561 618561 Cook, John, of Magna Stoughton, cook 1
5348585 2459690 2459690 defendant Horner Thomas laborer 618561 618561 Horner, Thomas, of Magna Stoughton, laborer 2
5348586 2459690 2459690 defendant Baker John laborer 618561 618561 Baker, John, of Magna Stoughton, laborer 3
5348587 2459690 2459690 defendant Cosyn William husbandman 618561 618561 Cosyn, William, of Magna Stoughton, husbandman 4
5348594 2459692 2459692 defendant Cook John   618561 618561 Cook, John, of Magna Stoughton, cook 1
5348595 2459692 2459692 defendant Horner Thomas laborer 618561 618561 Horner, Thomas, of Magna Stoughton, laborer 2
5348596 2459692 2459692 defendant Baker John laborer 618561 618561 Baker, John, of Magna Stoughton, laborer 3
5348597 2459692 2459692 defendant Cosyn William husbandman 618561 618561 Cosyn, William, of Magna Stoughton, husbandman 4

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