names

32 rows where place_id = 749407

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4389018 2160958 2160958 defendant Smythe William clerk 749407 749407 Smythe, William, of Kidderminster, clerk 0
4389019 2160958 2160958 defendant Smythe William butcher 749407 749407 Smythe, William, of Kidderminster, butcher 1
4504134 2201844 2201844 defendant Mille John   749407 749407 Mille, John, of Kidderminster 0
4504793 2202039 2202039 defendant Mason Thomas   749407 749407 Mason, Thomas, of Kidderminster 0
4532693 2210494 2210494 defendant Bremmesgrove William   749407 749407 Bremmesgrove, William, of Kidderminster 0
4547315 2215092 2215092 defendant Suche Thomas   749407 749407 Suche, Thomas, of Kidderminster 0
4547539 2215162 2215162 defendant Wyllys William   749407 749407 Wyllys, William, of Kidderminster 0
4563707 2220216 2220216 defendant Wasshebrook Walter   749407 749407 Wasshebrook, Walter, of Kidderminster 0
4590765 2228464 2228464 plaintiff Mason Thomas   749407 749407 Mason, Thomas, of Kidderminster 0
4591879 2228813 2228813 plaintiff Mulle John   749407 749407 Mulle, John, of Kidderminster 0
4597903 2230601 2230601 defendant Mason Thomas   749407 749407 Mason, Thomas, of Kidderminster 0
4616550 2236173 2236173 plaintiff Fylylode Giles   749407 749407 Fylylode, Giles, of Kidderminster 0
4643266 2244137 2244137 defendant Jones Nicholas   749407 749407 Jones, Nicholas, of Kidderminster 3
4645579 2244776 2244776 defendant Wenforton William   749407 749407 Wenforton, William, of Kidderminster 2
4716623 2270518 2270518 defendant Hykemanys John   749407 749407 Hykemanys, John, of Kidderminster, mill ward 0
4730381 2274701 2274701 plaintiff Wenforton John   749407 749407 Wenforton, John, of Kidderminster 1
4756165 2282304 2282304 defendant Duryche William husbandman 749407 749407 Duryche, William, of Kidderminster, husbandman 0
4756167 2282305 2282305 defendant Sugge William husbandman 749407 749407 Sugge, William, of Kidderminster, husbandman 0
4765048 2285043 2285043 defendant Cookes or Cockes John butcher 749407 749407 Cookes or Cockes, John, of Kidderminster, butcher 0
4767090 2285695 2285695 defendant Stapelford William husbandman 749407 749407 Stapelford, William, of Kidderminster, husbandman 2
4770200 2286653 2286653 plaintiff Pulton John dyer 749407 749407 Pulton, John, of Kidderminster, dyer 0
4770201 2286653 2286653 defendant Ssugge William chaplain 749407 749407 Ssugge, William, of Kidderminster, chaplain 0
4771165 2286964 2286964 defendant Wyncheley Thomas smith 749407 749407 Wyncheley, Thomas, of Kidderminster, smith 0
4809693 2299195 2299195 defendant Stodeley John goldsmith 749407 749407 Stodeley, John, of Kidderminster, goldsmith 1
4809694 2299195 2299195 defendant Merton Roger draper 749407 749407 Merton, Roger, of Kidderminster, draper 2
4809695 2299195 2299195 defendant Skutte William   749407 749407 Skutte, William, of Kidderminster, iron monger 3
4931137 2336125 2336125 defendant Ryder John smith 749407 749407 Ryder, John, of Kidderminster, smith 0
5010015 2359796 2359796 defendant Jones Nicholas walker 749407 749407 Jones, Nicholas, of Kidderminster, walker 0
5179067 2409606 2409606 defendant Keper Richard husbandman 749407 749407 Keper, Richard, of Kidderminster, husbandman 0
5271813 2436851 2436851 defendant Wessheburn William gent 749407 749407 Wessheburn, William, of Kidderminster, gent 0
5442030 2487537 2487537 defendant Oliver John   749407 749407 Oliver, John, of Kidderminster, vestment maker 1
5455970 2491696 2491696 defendant Mounslowe Roger husbandman 749407 749407 Mounslowe, Roger, of Kidderminster, 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);