names

80 rows where place_id = 590057

✎ 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
3599741 1867563 1867563 defendant Chamber William yeoman 590057 590057 Chamber, William, of Rokeby, yeoman 0
3599743 1867563 1867563 defendant Barnewell John husbandman 590057 590057 Barnewell, John, of Rokeby, husbandman 2
3601592 1868154 1868154 defendant Meyd Agnes widow 590057 590057 Meyd, Agnes, of Rokeby, widow 0
3607692 1870060 1870060 defendant Chambyr Agnes widow 590057 590057 Chambyr, Agnes, of Rokeby, widow 1
3619474 1873655 1873655 defendant Boteler Thomas husbandman 590057 590057 Boteler, Thomas, of Rokeby, husbandman 0
3619476 1873655 1873655 defendant Mede Simon (legal representative) 590057 590057 Mede, Simon, of Rokeby, fuller, executors of 2
3619477 1873655 1873655 defendant Preest Henry fuller 590057 590057 (Preest, Henry, of Rokeby, fuller 3
3632950 1905120 1905120 defendant Lytle John gent 590057 590057 Lytle, John, of Rokeby, gent 0
3633817 1905389 1905389 defendant Magett William carpenter 590057 590057 Magett, William, of Rokeby, carpenter 0
3673515 1917742 1917742 defendant Boswell Thomas baker 590057 590057 Boswell, Thomas, of Rokeby, baker 0
3712945 1930370 1930370 defendant Brokhurste John   590057 590057 Brokhurste, John, of Rokeby, yeoman, bailiff 0
3722005 1933145 1933145 defendant Lytley John gent 590057 590057 Lytley, John, of Rokeby, gent 0
3740605 1938921 1938921 defendant Devell John yeoman 590057 590057 Devell, John, of Rokeby, yeoman 2
3764633 1946600 1946600 defendant Gyll William husbandman 590057 590057 Gyll, William, of Rokeby, husbandman 0
3817894 1963513 1963513 defendant Devell John yeoman 590057 590057 Devell, John, of Rokeby, yeoman 2
3821766 1964694 1964694 defendant Couper Thomas cordwainer 590057 590057 Couper, Thomas, of Rokeby, cordwainer 1
3826724 1966209 1966209 defendant Burton John butcher 590057 590057 Burton, John, of Rokeby, butcher 0
3826725 1966209 1966209 defendant Browne William butcher 590057 590057 Browne, William, of Rokeby, butcher 1
3858451 1976302 1976302 defendant Walker Thomas yeoman 590057 590057 Walker, Thomas, of Rokeby, yeoman 0
4427756 2173518 2173518 defendant Weston John de   590057 590057 Weston, John de, of Rokeby 0
4427758 2173518 2173518 defendant Thurston Henry   590057 590057 Thurston, Henry, of Rokeby 2
4513042 2204514 2204514 plaintiff Bretford Robert   590057 590057 Bretford, Robert, of Rokeby 0
4590193 2228299 2228299 defendant Baron Thomas   590057 590057 Baron, Thomas, of Rokeby 0
4590194 2228299 2228299 defendant Smyth John   590057 590057 Smyth, John, of Rokeby 1
4590196 2228299 2228299 defendant Robertson Richard   590057 590057 Robertson, Richard, of Rokeby 3
4618441 2236778 2236778 defendant Hereward John   590057 590057 Hereward, John, of Rokeby 1
4662111 2249626 2249626 defendant Bell John smith 590057 590057 Bell, John, of Rokeby, smith 0
4662112 2249626 2249626 defendant Bell Thomas smith 590057 590057 Bell, Thomas, of Rokeby, smith 1
4662113 2249626 2249626 defendant Bell William smith 590057 590057 Bell, William, of Rokeby, smith 2
4662114 2249626 2249626 defendant Gosewyke John yeoman 590057 590057 Gosewyke, John, of Rokeby, yeoman 3
4662115 2249626 2249626 defendant Gosewyk William yeoman 590057 590057 Gosewyk, William, of Rokeby, yeoman 4
4662116 2249626 2249626 defendant Gosewyk Thomas yeoman 590057 590057 Gosewyk, Thomas, of Rokeby, yeoman 5
4662120 2249626 2249626 defendant Mason Thomas husbandman 590057 590057 Mason, Thomas, of Rokeby, husbandman 9
4662121 2249626 2249626 defendant Mason William husbandman 590057 590057 Mason, William, of Rokeby, husbandman 10
4715857 2270273 2270273 defendant Ryngolston William laborer 590057 590057 Ryngolston, William, of Rokeby, laborer 0
4803488 2297278 2297278 defendant Carter John husbandman 590057 590057 Carter, John, of Rokeby, husbandman 0
4803489 2297278 2297278 defendant fotergill Thomas husbandman 590057 590057 fotergill, Thomas, of Rokeby, husbandman 1
4835265 2307029 2307029 defendant Morland Gregory de yeoman 590057 590057 Morland, Gregory de, of Rokeby, yeoman 0
4860508 2314646 2314646 defendant Cleseby Arschulphus gent 590057 590057 Cleseby, Arschulphus, of Rokeby, gent 0
4860522 2314646 2314646 defendant Fothergill Mathew yeoman 590057 590057 Fothergill, Mathew, of Rokeby, yeoman 14
4913441 2330702 2330702 defendant Edmunde Thomas fisher 590057 590057 Edmunde, Thomas, of Rokeby, fisher 1
4991568 2354362 2354362 defendant Rokeby Thomas esq 590057 590057 Rokeby, Thomas, of Rokeby, esq 0
5017824 2362093 2362093 defendant Stoke Thomas   590057 590057 Stoke, Thomas, of Rokeby, cook 2
5025365 2364314 2364314 defendant Mabys or Mavys William husbandman 590057 590057 Mabys or Mavys, William, of Rokeby, husbandman 2
5077978 2379896 2379896 defendant Edmunde John, senior husbandman 590057 590057 Edmunde, John, senior, of Rokeby, husbandman 1
5077979 2379896 2379896 defendant Edmunde John, junior husbandman 590057 590057 Edmunde, John, junior, of Rokeby, husbandman 2
5077980 2379896 2379896 defendant Couper Hugh husbandman 590057 590057 Couper, Hugh, of Rokeby, husbandman 3
5077981 2379896 2379896 defendant Mabbe William weaver 590057 590057 Mabbe, William, of Rokeby, weaver 4
5077982 2379896 2379896 defendant Wykys John husbandman 590057 590057 Wykys, John, of Rokeby, husbandman 5
5077985 2379897 2379897 defendant Edmunde John, senior husbandman 590057 590057 Edmunde, John, senior, of Rokeby, husbandman 1
5077986 2379897 2379897 defendant Edmunde John, junior husbandman 590057 590057 Edmunde, John, junior, of Rokeby, husbandman 2
5077987 2379897 2379897 defendant Couper Hugh husbandman 590057 590057 Couper, Hugh, of Rokeby, husbandman 3
5077988 2379897 2379897 defendant Mabbe William weaver 590057 590057 Mabbe, William, of Rokeby, weaver 4
5077989 2379897 2379897 defendant Wykys John husbandman 590057 590057 Wykys, John, of Rokeby, husbandman 5
5081762 2381047 2381047 defendant Lote John baker 590057 590057 Lote, John, of Rokeby, baker 0
5081764 2381047 2381047 defendant Thurston John butcher 590057 590057 Thurston, John, of Rokeby, butcher 2
5081768 2381048 2381048 defendant Lote John baker 590057 590057 Lote, John, of Rokeby, baker 0
5081770 2381048 2381048 defendant Thurston John butcher 590057 590057 Thurston, John, of Rokeby, butcher 2
5160819 2404260 2404260 defendant Wykes John chapman 590057 590057 Wykes, John, of Rokeby, chapman 0
5226401 2423387 2423387 defendant Miller John yeoman 590057 590057 Miller, John, of Rokeby, yeoman 3
5236060 2426130 2426130 defendant Stones John clerk 590057 590057 Stones, John, of Rokeby, clerk 1
5247707 2429480 2429480 defendant Miller William miller 590057 590057 Miller, William, of Rokeby, miller 2
5247708 2429480 2429480 defendant Miller John yeoman 590057 590057 Miller, John, of Rokeby, yeoman 3
5263111 2434205 2434205 defendant Overton Hugh cooper 590057 590057 Overton, Hugh, of Rokeby, cooper 1
5288048 2441521 2441521 defendant Bocher Richard   590057 590057 Bocher, Richard, of Rokeby, card maker 0
5327678 2453345 2453345 defendant Edmond Robert husbandman 590057 590057 Edmond, Robert, of Rokeby, husbandman 0
5336215 2455912 2455912 defendant Mabbes John husbandman 590057 590057 Mabbes, John, of Rokeby, husbandman 3
5336222 2455913 2455913 defendant Mabbes John husbandman 590057 590057 Mabbes, John, of Rokeby, husbandman 3
5345744 2458811 2458811 defendant Cormerant John chapman 590057 590057 Cormerant, John, of Rokeby, chapman 3
5357772 2462501 2462501 defendant Mabbe Thomas husbandman 590057 590057 Mabbe, Thomas, of Rokeby, husbandman 0
5376828 2468346 2468346 defendant Skynner Robert yeoman 590057 590057 Skynner, Robert, of Rokeby, yeoman 2
5463116 2493882 2493882 defendant Hutte Lawrence miller 590057 590057 Hutte, Lawrence, of Rokeby, miller 0
5463117 2493882 2493882 defendant Huet William husbandman 590057 590057 Huet, William, of Rokeby, husbandman 1
5463118 2493882 2493882 defendant Bynley Alexander husbandman 590057 590057 Bynley, Alexander, of Rokeby, husbandman 2
5497652 2504241 2504241 defendant Chamber William yeoman 590057 590057 Chamber, William, of Rokeby, yeoman 3
5497658 2504242 2504242 defendant Chaumber William yeoman 590057 590057 Chaumber, William, of Rokeby, yeoman 3
5502359 2505663 2505663 defendant Chamber William yeoman 590057 590057 Chamber, William, of Rokeby, yeoman 0
5502360 2505663 2505663 defendant Chamber John yeoman 590057 590057 Chamber, John, of Rokeby, yeoman 1
5502362 2505664 2505664 defendant Chamber William yeoman 590057 590057 Chamber, William, of Rokeby, yeoman 0
5502363 2505664 2505664 defendant Chamber John yeoman 590057 590057 Chamber, John, of Rokeby, yeoman 1

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