names

67 rows where place_id = 611499

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3665890 1915268 1915268 defendant Draper Thomas   611499 611499 Draper, Thomas, of Salford, Soms, rector 0
3666957 1915609 1915609 plaintiff Welshe Nicholas (legal representative) 611499 611499 Welshe, Nicholas, of Salford, vicar, administrator of 0
3667625 1915818 1915818 defendant Draper Thomas   611499 611499 Draper, Thomas, of Salford, Soms, rector 0
3688660 1922614 1922614 defendant Wylde William brasier 611499 611499 Wylde, William, of Salford, brasier 1
3772202 1948991 1948991 defendant Brokeman John husbandman 611499 611499 Brokeman, John, of Salford, husbandman 0
3788712 1954273 1954273 defendant Davys Augustine   611499 611499 Davys, Augustine, of Salford 0
3791353 1955131 1955131 defendant Light Joan clerk 611499 611499 Light, Joan, of Salford, clerk 0
3870403 1980345 1980345 plaintiff Wykes John clerk 611499 611499 Wykes, John, of Salford, clerk 0
3870444 1980359 1980359 defendant Lyttylton Anthony gent 611499 611499 Lyttylton, Anthony, of Salford Abbot, gent 2
3916396 1995864 1995864 defendant Foster Thomas gent 611499 611499 Foster, Thomas, of Salford, gent 0
3916398 1995864 1995864 defendant Pedder Thomas yeoman 611499 611499 Pedder, Thomas, of Salford, yeoman 2
3916399 1995864 1995864 defendant Mounford Thomas yeoman 611499 611499 Mounford, Thomas, of Salford, yeoman 3
3916400 1995864 1995864 defendant Walles Edward tiler 611499 611499 Walles, Edward, of Salford, tiler 4
3916401 1995864 1995864 defendant Mowse William laborer 611499 611499 Mowse, William, of Salford, laborer 5
3916403 1995865 1995865 defendant Foster Thomas gent 611499 611499 Foster, Thomas, of Salford, gent 0
3916405 1995865 1995865 defendant Padder Thomas yeoman 611499 611499 Padder, Thomas, of Salford, yeoman 2
3916406 1995865 1995865 defendant Mounford Thomas yeoman 611499 611499 Mounford, Thomas, of Salford, yeoman 3
3916407 1995865 1995865 defendant Walles Edward tiler 611499 611499 Walles, Edward, of Salford, tiler 4
3916408 1995865 1995865 defendant Mowse William laborer 611499 611499 Mowse, William, of Salford, laborer 5
3921137 1997422 1997422 defendant Godyng Thomas husbandman 611499 611499 Godyng, Thomas, of Salford, husbandman 0
3921138 1997422 1997422 defendant Aleyn John husbandman 611499 611499 Aleyn, John, of Salford, husbandman 1
4030424 2035537 2035537 defendant Emmes Augustine yeoman 611499 611499 Emmes, Augustine, of Salford, yeoman 0
4036440 2037717 2037717 defendant Edkyns Richard singleman 611499 611499 Edkyns, Richard, of Salford, singleman 3
4096965 2059245 2059245 defendant Allen Thomas clerk 611499 611499 Allen, Thomas, of Salford, clerk 1
4219347 2102263 2102263 defendant Kylpyn William husbandman 611499 611499 Kylpyn, William, of Salford, husbandman 0
4219348 2102263 2102263 defendant Wodyll Richard husbandman 611499 611499 Wodyll, Richard, of Salford, husbandman 1
4245466 2111458 2111458 defendant Kylpyn William husbandman 611499 611499 Kylpyn, William, of Salford, husbandman 0
4245469 2111459 2111459 defendant Wodyll Richard husbandman 611499 611499 Wodyll, Richard, of Salford, husbandman 0
4251127 2113355 2113355 defendant Cowper William clothier 611499 611499 Cowper, William, of Salford, yeoman, clothier 0
4305752 2132149 2132149 defendant Cowper William gent 611499 611499 Cowper, William, of Salford, gent 2
4343996 2145178 2145178 defendant Marshall Gilbert yeoman 611499 611499 Marshall, Gilbert, of Salford, yeoman 1
4344030 2145190 2145190 defendant Marshall Robert sherman 611499 611499 Marshall, Robert, of Salford, sherman 2
4433364 2175190 2175190 defendant Grevull Richard de   611499 611499 Grevull, Richard de, of Salford, parson 0
4475560 2193042 2193042 defendant Plowryght John   611499 611499 Plowryght, John, of Salford 0
4542732 2213614 2213614 defendant Styward William   611499 611499 Styward, William, of Salford Abbot 0
4590766 2228464 2228464 defendant Smyth John   611499 611499 Smyth, John, of Salford 0
4590767 2228464 2228464 defendant Broun Simon   611499 611499 Broun, Simon, of Salford 1
4590768 2228464 2228464 defendant Pope John   611499 611499 Pope, John, of Salford 2
4597900 2230601 2230601 plaintiff Smyth John   611499 611499 Smyth, John, of Salford 0
4667958 2255682 2255682 defendant Purneour John, junior husbandman 611499 611499 Purneour, John, junior, of Salford, husbandman 0
4686210 2261285 2261285 defendant Pecche Roger husbandman 611499 611499 Pecche, Roger, of Salford, husbandman 0
4698401 2264977 2264977 defendant Silvestre Thomas   611499 611499 Silvestre, Thomas, of Salford, Warws. Yeoman 3
4713063 2269407 2269407 defendant Bailly Gillian widow 611499 611499 Bailly, Gillian, of Salford, widow 1
4728600 2274184 2274184 defendant Petche William husbandman 611499 611499 Petche, William, of Salford, husbandman 1
4728601 2274184 2274184 defendant Purveour John butcher 611499 611499 Purveour, John, of Salford, butcher 2
4728602 2274184 2274184 defendant Colet John miller 611499 611499 Colet, John, of Salford, miller 3
4739118 2277325 2277325 defendant Brigge John milner 611499 611499 Brigge, John, of Salford, milner 0
4801191 2296555 2296555 defendant Walshe Thomas fisher 611499 611499 Walshe, Thomas, of Salford, fisher 0
4827252 2304574 2304574 defendant Pesshon Richard husbandman 611499 611499 Pesshon, Richard, of Salford, husbandman 0
4892434 2324374 2324374 defendant Nobull William husbandman 611499 611499 Nobull, William, of Salford, husbandman 1
4894343 2324911 2324911 defendant Clerke John maltman 611499 611499 Clerke, John, of Salford, maltman 0
4895217 2325162 2325162 defendant Clerk John maltman 611499 611499 Clerk, John, of Salford, maltman 0
4911411 2330071 2330071 defendant Hantour William clerk 611499 611499 Hantour, William, of Salford, clerk 0
4936990 2337942 2337942 defendant Cowembe William husbandman 611499 611499 Cowembe, William, of Salford, husbandman 0
4936992 2337943 2337943 defendant Haytour William clerk 611499 611499 Haytour, William, of Salford, clerk 0
4972249 2348644 2348644 defendant Overton Ralph yeoman 611499 611499 Overton, Ralph, of Salford, yeoman 1
4978965 2350666 2350666 defendant Levot Thomas clerk 611499 611499 Levot, Thomas, of Salford, clerk 0
5139254 2397971 2397971 defendant Howet John husbandman 611499 611499 Howet, John, of Salford, husbandman 1
5240688 2427489 2427489 defendant Saunder John husbandman 611499 611499 Saunder, John, of Salford, husbandman 0
5270888 2436581 2436581 defendant Botreux John gent 611499 611499 Botreux, John, of Salford, gent 5
5305702 2446714 2446714 defendant Creweley John miller 611499 611499 Creweley, John, of Salford, miller 0
5305703 2446714 2446714 defendant Croweley Thomas miller 611499 611499 Croweley, Thomas, of Salford, miller 1
5321479 2451516 2451516 defendant Croweley John miller 611499 611499 Croweley, John, of Salford, miller 0
5321480 2451516 2451516 defendant Croweley Thomas miller 611499 611499 Croweley, Thomas, of Salford, miller 1
5370065 2466221 2466221 defendant Reed John yeoman 611499 611499 Reed, John, of Salford, yeoman 0
5370066 2466221 2466221 defendant Bynde John husbandman 611499 611499 (Bynde, John, of Salford, husbandman 1
5557750 2522215 2522215 defendant Noble Robert yeoman 611499 611499 Noble, Robert,of Salford, yeoman 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);