names

90 rows where place_id = 596570

✎ 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
3625313 1875453 1875453 defendant Frere William husbandman 596570 596570 Frere, William, of Bromham, husbandman 0
3932364 2001122 2001122 defendant Rawson William husbandman 596570 596570 Rawson, William, of Bromham, husbandman 0
3932365 2001122 2001122 defendant Sympson Thomas husbandman 596570 596570 Sympson, Thomas, of Bromham, husbandman 1
3932366 2001122 2001122 defendant Harte William husbandman 596570 596570 Harte, William, of Bromham, husbandman 2
3932367 2001122 2001122 defendant Taylor Anne widow 596570 596570 Taylor, Anne, of Bromham, widow 3
3940264 2003763 2003763 defendant Chaundeler Richard beer brewer 596570 596570 Chaundeler, Richard, of Bromham, beer brewer 1
3940265 2003763 2003763 defendant Powneney William   596570 596570 Powneney, William, of Bromham, shoe maker 2
3944663 2005232 2005232 plaintiff Baynton Andrew esq 596570 596570 Baynton, Andrew, of Bromham, esq 0
3966749 2013004 2013004 defendant Baynton Henry   596570 596570 Baynton, Henry, of Bromham, Wilts. esq 0
3999468 2024574 2024574 defendant Stafford Thomas esq 596570 596570 Stafford, Thomas, of Bromham, esq 2
4036356 2037687 2037687 defendant Peade Henry   596570 596570 Peade, Henry, of Bromham, yeoman, administrators of 0
4103795 2061630 2061630 defendant Webbe alias Rawling John   596570 596570 Webbe alias Rawling, John, of Bromham, yeoman, "his son" or son of preceding 0
4103797 2061631 2061631 defendant Webbe alias Rawling John, senior yeoman 596570 596570 Webbe alias Rawling, John, senior, of Bromham, yeoman 0
4234438 2107584 2107584 defendant Ansty or Austy Richard yeoman 596570 596570 Ansty or Austy, Richard, of Bromham, yeoman 1
4439556 2181634 2181634 plaintiff Ballard John   596570 596570 Ballard, John, of Bromham 0
4439557 2181634 2181634 defendant Forster Hugh   596570 596570 Forster, Hugh, of Bromham 0
4464456 2189551 2189551 defendant Vyse John glover 596570 596570 Vyse, John, of Bromham, glover 1
4491921 2198159 2198159 defendant Ive John   596570 596570 Ive, John, of Bromham 0
4495366 2199229 2199229 defendant Weller Thomas   596570 596570 Weller, Thomas, of Bromham 0
4507432 2202790 2202790 plaintiff Welle John   596570 596570 Welle, John, of Bromham, on his own account 0
4507433 2202790 2202790 defendant Turret John   596570 596570 Turret, John, of Bromham 0
4528405 2209160 2209160 defendant Jones John   596570 596570 Jones, John, of Bromham 0
4528406 2209160 2209160 defendant Skarnant Thomas   596570 596570 Skarnant, Thomas, of Bromham 1
4550923 2216225 2216225 defendant Percevale John   596570 596570 Percevale, John, of Bromham 0
4560913 2219367 2219367 plaintiff Orberd Robert   596570 596570 Orberd, Robert, of Bromham 0
4563533 2220168 2220168 defendant Jones John   596570 596570 Jones, John, of Bromham 0
4602288 2231931 2231931 plaintiff Webbe John   596570 596570 Webbe, John, of Bromham 0
4630328 2240395 2240395 defendant Ordewey John   596570 596570 Ordewey, John, of Bromham 4
4641086 2243485 2243485 defendant Stokkewell John   596570 596570 Stokkewell, John, of Bromham 0
4641087 2243485 2243485 defendant Slade Letitia   596570 596570 Slade, Letitia, of Bromham 1
4641088 2243485 2243485 defendant Johnys John   596570 596570 Johnys, John, of Bromham 2
4643153 2244106 2244106 defendant Clerk Nicholas   596570 596570 Clerk, Nicholas, of Bromham 0
4656281 2247858 2247858 defendant Pertnale John husbandman 596570 596570 Pertnale, John, of Bromham, husbandman 2
4668452 2255845 2255845 defendant Bailly Philip ploughman 596570 596570 Bailly, Philip, of Bromham, ploughman 0
4691177 2262761 2262761 defendant Goos John ploughman 596570 596570 Goos, John, of Bromham, ploughman 1
4697834 2264820 2264820 defendant Grenewode John husbandman 596570 596570 Grenewode, John, of Bromham, husbandman 0
4697835 2264820 2264820 defendant Abraham Robert husbandman 596570 596570 Abraham, Robert, of Bromham, husbandman 1
4697838 2264820 2264820 defendant Pisford John laborer 596570 596570 Pisford, John, of Bromham, laborer 4
4716839 2270594 2270594 defendant Wryght William   596570 596570 Wryght, William, of Bromham, wright 0
4716848 2270596 2270596 defendant Goos John laborer 596570 596570 Goos, John, of Bromham, laborer 0
4716849 2270596 2270596 defendant Abraham Robert   596570 596570 Abraham, Robert, of Bromham, wright 1
4716850 2270596 2270596 defendant Burgh John   596570 596570 Burgh, John, of Bromham, franklin 2
4718426 2271100 2271100 defendant Est John   596570 596570 Est, John, of Bromham, wright 3
4731648 2275091 2275091 defendant Terat John husbandman 596570 596570 Terat, John, of Bromham, husbandman 3
4731649 2275091 2275091 defendant Ussher Thomas   596570 596570 Ussher, Thomas, of Bromham, mill ward 4
4747733 2279846 2279846 defendant Bouer Henry husbandman 596570 596570 Bouer, Henry, of Bromham, husbandman 0
4747736 2279847 2279847 defendant Ordewey John husbandman 596570 596570 Ordewey, John, of Bromham, husbandman 0
4747738 2279847 2279847 defendant Ussher John husbandman 596570 596570 Ussher, John, of Bromham, husbandman 2
4747739 2279847 2279847 defendant Ussher Thomas husbandman 596570 596570 Ussher, Thomas, of Bromham, husbandman 3
4753656 2281515 2281515 defendant Curteys William laborer 596570 596570 Curteys, William, of Bromham, laborer 0
4762159 2284143 2284143 defendant Bette Bartholomew   596570 596570 Bette, Bartholomew, of Bromham, mason 1
4787181 2292057 2292057 defendant Frere John butcher 596570 596570 Frere, John, of Bromham, butcher 0
4790311 2293054 2293054 defendant Bristebolt William husbandman 596570 596570 Bristebolt, William, of Bromham, husbandman 0
4791585 2293463 2293463 defendant Burgh John husbandman 596570 596570 Burgh, John, of Bromham, husbandman 0
4835537 2307104 2307104 defendant Est John husbandman 596570 596570 Est, John, of Bromham, husbandman 1
4836460 2307382 2307382 defendant Beauchamp Elizabeth   596570 596570 Beauchamp, Elizabeth, of Bromham, widow, formerly wife of Walter Beauchamp, knight 0
4856365 2313365 2313365 defendant Bristbolt William husbandman 596570 596570 Bristbolt, William, of Bromham, husbandman 1
4876978 2319770 2319770 defendant Beauchamp Elizabeth   596570 596570 Beauchamp, Elizabeth, of Bromham, widow of Beauchamp, Walter, knight 0
4891499 2324077 2324077 defendant Coupere Bartholomew   596570 596570 Coupere, Bartholomew, of Bromham, mason 1
4891500 2324077 2324077 defendant Scot John husbandman 596570 596570 Scot, John, of Bromham, husbandman 2
4895200 2325158 2325158 defendant Paton John miller 596570 596570 together with Paton, John, of Bromham, miller 2
4898363 2326144 2326144 defendant Tanner Roger tanner 596570 596570 Tanner, Roger, of Bromham, tanner 0
4898637 2326220 2326220 defendant Coupere Bartholomew   596570 596570 Coupere, Bartholomew, of Bromham, mason 1
4898638 2326220 2326220 defendant Scot John husbandman 596570 596570 Scot, John, of Bromham, husbandman 2
4909357 2329466 2329466 defendant Skotte John husbandman 596570 596570 Skotte, John, of Bromham, husbandman 0
4917788 2332077 2332077 defendant Ragoun John (legal representative) 596570 596570 Ragoun, John, of Bromham, gent, executors of 1
4917790 2332077 2332077 defendant Ragoun Thomas gent 596570 596570 Ragoun, Thomas, of Bromham, gent 3
4933797 2336949 2336949 defendant Skote William pulter 596570 596570 Skote, William, of Bromham, pulter 2
4934845 2337299 2337299 defendant Pertenale John husbandman 596570 596570 Pertenale, John, of Bromham, husbandman 0
4934959 2337339 2337339 defendant Skot John husbandman 596570 596570 Skot, John, of Bromham, husbandman 0
4934965 2337341 2337341 defendant Skot John husbandman 596570 596570 Skot, John, of Bromham, husbandman 0
4969439 2347815 2347815 defendant Hamond John yeoman 596570 596570 Hamond, John, of Bromham, yeoman 3
4977869 2350339 2350339 defendant Hamond John yeoman 596570 596570 Hamond, John, of Bromham, yeoman 0
4977871 2350340 2350340 defendant Hamond John yeoman 596570 596570 Hamond, John, of Bromham, yeoman 0
4977872 2350340 2350340 defendant Paton John, senior husbandman 596570 596570 Paton, John, senior, of Bromham, husbandman 1
4977873 2350340 2350340 defendant Hobbes Nicholas weaver 596570 596570 Hobbes, Nicholas, of Bromham, weaver 2
4977874 2350340 2350340 defendant Pertonhale John husbandman 596570 596570 Pertonhale, John, of Bromham, husbandman 3
4977875 2350340 2350340 defendant Wyllymot John husbandman 596570 596570 Wyllymot, John, of Bromham, husbandman 4
4977876 2350340 2350340 defendant Paten Thomas husbandman 596570 596570 Paten, Thomas, of Bromham, husbandman 5
4977877 2350340 2350340 defendant Hille John husbandman 596570 596570 Hille, John, of Bromham, husbandman 6
4977879 2350341 2350341 defendant Hamond John yeoman 596570 596570 Hamond, John, of Bromham, yeoman 0
4977880 2350341 2350341 defendant Paton John, senior husbandman 596570 596570 Paton, John, senior, of Bromham, husbandman 1
5009755 2359733 2359733 defendant Brese John   596570 596570 Brese, John, of Bromham 2
5284250 2440413 2440413 defendant Catour Thomas yeoman 596570 596570 Catour, Thomas, of Bromham, yeoman 1
5303286 2445980 2445980 defendant Stokes Henry husbandman 596570 596570 Stokes, Henry, of Bromham, husbandman 1
5303287 2445980 2445980 defendant Stokes Richard husbandman 596570 596570 Stokes, Richard, of Bromham, husbandman 2
5492914 2502790 2502790 defendant Lyllyot Henry husbandman 596570 596570 Lyllyot, Henry, of Bromham, husbandman 0
5500466 2505080 2505080 defendant Ussher Simon miller 596570 596570 Ussher, Simon, of Bromham, miller 0
5611480 2547323 2547323 plaintiff Botiller Philip   596570 596570 Botiller, Philip, of Bromham 0
5618675 2549679 2549679 defendant Troyes William   596570 596570 Troyes, William, of Bromham 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);