names

68 rows where place_id = 590284

✎ 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
3600476 1867796 1867796 defendant Parker John husbandman 590284 590284 Parker, John, of Melburn, husbandman 1
3610837 1871058 1871058 defendant Heche George husbandman 590284 590284 Heche, George, of Melburn, husbandman 0
3748983 1941613 1941613 defendant Colwell Richard husbandman 590284 590284 Colwell, Richard, of Melburn, husbandman 1
3748990 1941615 1941615 defendant Collwell John husbandman 590284 590284 Collwell, John, of Melburn, husbandman 1
3748991 1941615 1941615 defendant Collwell George husbandman 590284 590284 Collwell, George, of Melburn, husbandman 2
3756401 1943973 1943973 defendant Herman John beer brewer 590284 590284 Herman, John, of Melburn, beer brewer 1
3813954 1962275 1962275 defendant Shevyn Ralph butcher 590284 590284 Shevyn, Ralph, of Melburn, butcher 0
4413928 2169255 2169255 defendant Weyge John   590284 590284 Weyge, John, of Melburn, son of John 0
4414735 2169508 2169508 defendant Toukere Robert   590284 590284 Toukere, Robert, of Melburn 0
4615728 2235919 2235919 plaintiff Ferrour William   590284 590284 Ferrour, William, of Melburn 0
4658820 2248631 2248631 defendant Clerk Robert yeoman 590284 590284 Clerk, Robert, of Melburn, yeoman 1
4713105 2269421 2269421 defendant Melburn John gent 590284 590284 together with Melburn, John, of Melburn, gent 2
4713106 2269421 2269421 defendant Melburn Henry gent 590284 590284 Melburn, Henry, of Melburn, gent 3
4713107 2269421 2269421 defendant Tylot Robert gent 590284 590284 Tylot, Robert, of Melburn, gent 4
4713110 2269422 2269422 defendant Melburn John gent 590284 590284 (Melburn, John, of Melburn, gent 1
4713111 2269422 2269422 defendant Melburn Henry gent 590284 590284 Melburn, Henry, of Melburn, gent 2
4713112 2269422 2269422 defendant Tylot Robert gent 590284 590284 Tylot, Robert, of Melburn, gent 3
4742396 2278268 2278268 defendant Sturmyn William yeoman 590284 590284 Sturmyn, William, of Melburn, yeoman 0
4760624 2283665 2283665 defendant Barker Thomas husbandman 590284 590284 Barker, Thomas, of Melburn, husbandman 2
4790889 2293240 2293240 defendant Warner Thomas yeoman 590284 590284 Warner, Thomas, of Melburn, yeoman 3
4836191 2307300 2307300 defendant Barker Walter butcher 590284 590284 Barker, Walter, of Melburn, butcher 2
4878470 2320210 2320210 defendant Ferour or Smith Willism chaplain 590284 590284 Ferour or Smith, Willism, of Melburn, chaplain 1
4905348 2328264 2328264 defendant Melburn Henry esq 590284 590284 Melburn, Henry, of Melburn, esq 0
4905349 2328264 2328264 defendant Baker Roger yeoman 590284 590284 Baker, Roger, of Melburn, yeoman 1
4905350 2328264 2328264 defendant Danson or Dauson William   590284 590284 Danson or Dauson, William, of Melburn, servant 2
4929205 2335550 2335550 defendant Cottell Geoffrey husbandman 590284 590284 Cottell, Geoffrey, of Melburn, husbandman 0
4932498 2336558 2336558 defendant Cotull John maltman 590284 590284 Cotull, John, of Melburn, maltman 1
4932501 2336558 2336558 defendant Cotell Geoffrey maltman 590284 590284 Cotell, Geoffrey, of Melburn, maltman 4
4973732 2349097 2349097 defendant Tayllour William chaplain 590284 590284 Tayllour, William, of Melburn, chaplain 0
4988948 2353634 2353634 defendant Smyth John husbandman 590284 590284 Smyth, John, of Melburn, husbandman 28
4991492 2354339 2354339 defendant Ormysby Thomas   590284 590284 Ormysby, Thomas, of Melburn 4
4991497 2354339 2354339 defendant Payne John   590284 590284 Payne, John, of Melburn 9
5015326 2361366 2361366 defendant Cuttell William, senior husbandman 590284 590284 Cuttell, William, senior, of Melburn, husbandman 0
5102219 2387068 2387068 defendant Hayton Robert husbandman 590284 590284 Hayton, Robert, of Melburn, husbandman 0
5102220 2387068 2387068 defendant Mowbray John husbandman 590284 590284 Mowbray, John, of Melburn, husbandman 1
5102221 2387068 2387068 defendant Barton Adam husbandman 590284 590284 Barton, Adam, of Melburn, husbandman 2
5106696 2388384 2388384 defendant Horold John, senior husbandman 590284 590284 Horold, John, senior, of Melburn, husbandman 3
5108807 2389004 2389004 defendant Baron William husbandman 590284 590284 Baron, William, of Melburn, husbandman 0
5132368 2395964 2395964 defendant Kelme John   590284 590284 Kelme, John, of Melburn 0
5152112 2401756 2401756 defendant Kelme John yeoman 590284 590284 Kelme, John, of Melburn, yeoman 0
5170008 2406964 2406964 defendant Kelme John yeoman 590284 590284 Kelme, John, of Melburn, yeoman 0
5187336 2412022 2412022 defendant Kelme John yeoman 590284 590284 Kelme, John, of Melburn, yeoman 0
5233685 2425439 2425439 defendant Aleyn Stephen clerk 590284 590284 Aleyn, Stephen, of Melburn, clerk 0
5239108 2427029 2427029 defendant Moubray William husbandman 590284 590284 Moubray, William, of Melburn, husbandman 7
5279686 2439141 2439141 defendant Gunthorp John turner 590284 590284 Gunthorp, John, of Melburn, turner 1
5284730 2440548 2440548 defendant Gentyng Robert husbandman 590284 590284 Gentyng, Robert, of Melburn, husbandman 0
5316196 2449926 2449926 defendant Fayreclough Hugh clerk 590284 590284 Fayreclough, Hugh, of Melburn, clerk 0
5323045 2451971 2451971 defendant Broun Robert gent 590284 590284 Broun, Robert, of Melburn, gent 0
5349643 2460023 2460023 defendant Hall John tailor 590284 590284 Hall, John, of Melburn, tailor 1
5379869 2469289 2469289 defendant Hech Thomas, junior husbandman 590284 590284 Hech, Thomas, junior, of Melburn, husbandman 0
5385757 2470999 2470999 defendant Chamberleyn Lewis husbandman 590284 590284 Chamberleyn, Lewis, of Melburn, husbandman 0
5404286 2476302 2476302 defendant Fox John butcher 590284 590284 Fox, John, of Melburn, butcher 1
5411011 2478248 2478248 defendant Chamberleyn Lewis husbandman 590284 590284 Chamberleyn, Lewis, of Melburn, husbandman 0
5417431 2480132 2480132 defendant Fox John butcher 590284 590284 Fox, John, of Melburn, butcher 1
5423005 2481830 2481830 defendant Worth Edward yeoman 590284 590284 Worth, Edward, of Melburn, yeoman 2
5423010 2481831 2481831 defendant Worth Edward yeoman 590284 590284 Worth, Edward, of Melburn, yeoman 2
5425166 2482492 2482492 defendant Chamberleyn John gent 590284 590284 Chamberleyn, John, of Melburn, gent 0
5425168 2482493 2482493 defendant Chamberleyn John gent 590284 590284 Chamberleyn, John, of Melburn, gent 0
5425169 2482494 2482494 plaintiff Chamberleyn Lewis husbandman 590284 590284 Chamberleyn, Lewis, of Melburn, husbandman 0
5434798 2485344 2485344 defendant Fox John butcher 590284 590284 Fox, John, of Melburn, butcher 1
5506917 2507079 2507079 defendant Mareys John smith 590284 590284 Mareys, John, of Melburn, smith 0
5516109 2509887 2509887 defendant Sutton Richard husbandman 590284 590284 Sutton, Richard, of Melburn, husbandman 2
5557028 2522013 2522013 defendant Taillour John tailor 590284 590284 Taillour, John, of Melburn, tailor 1
5557029 2522013 2522013 defendant Sparke Adam weaver 590284 590284 Sparke, Adam, of Melburn, weaver 2
5607709 2537312 2537312 defendant Medowes William yeoman 590284 590284 Medowes, William, of Melburn, yeoman 0
5615141 2548527 2548527 defendant Peytowe Thomas   590284 590284 Peytowe, Thomas, of Melburn 0
5619343 2549901 2549901 defendant Mason William   590284 590284 Mason, William, of Melburn 0
5630345 2553497 2553497 defendant Toly Nicholas chaplain 590284 590284 Toly, Nicholas, of Melburn, chaplain 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);