names

256 rows where place_id = 590512

✎ 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
3601427 1868106 1868106 defendant Godyere Richard smith 590512 590512 Godyere, Richard, of Welyngton, smith 0
3601428 1868106 1868106 defendant Bale John smith 590512 590512 Bale, John, of Welyngton, smith 1
3604154 1868965 1868965 defendant Amore John husbandman 590512 590512 Amore, John, of Welyngton, husbandman 2
3617765 1873180 1873180 defendant Domate or Doniate Thomas husbandman 590512 590512 Domate or Doniate, Thomas, of Welyngton, husbandman 0
3617766 1873180 1873180 defendant Domate or Doniate John husbandman 590512 590512 Domate or Doniate, John, of Welyngton, husbandman 1
3617767 1873180 1873180 defendant More John husbandman 590512 590512 More, John, of Welyngton, husbandman 2
3626020 1902994 1902994 defendant Squyer John yeoman 590512 590512 Squyer, John, of Welyngton, yeoman 0
3648356 1909886 1909886 defendant Bole Richard husbandman 590512 590512 Bole, Richard, of Welyngton, husbandman 0
3656571 1912309 1912309 defendant Evesham Edmund husbandman 590512 590512 Evesham, Edmund, of Welyngton, husbandman 0
3656668 1912336 1912336 defendant Evesham Edmund husbandman 590512 590512 Evesham, Edmund, of Welyngton, husbandman 0
3661629 1913914 1913914 defendant Spenser Margaret widow 590512 590512 Spenser, Margaret, of Welyngton, widow 2
3661630 1913914 1913914 defendant Smyth Edward husbandman 590512 590512 Smyth, Edward, of Welyngton, husbandman 3
3680649 1920026 1920026 defendant Cranmore George husbandman 590512 590512 Cranmore, George, of Welyngton, husbandman 0
3680651 1920026 1920026 defendant Waren Robert tucker 590512 590512 Waren, Robert, of Welyngton, tucker 2
3698302 1925686 1925686 defendant Smythe Edward husbandman 590512 590512 Smythe, Edward, of Welyngton, husbandman 2
3698316 1925692 1925692 defendant Wyllyams Walter husbandman 590512 590512 Wyllyams, Walter, of Welyngton, husbandman 1
3698439 1925731 1925731 defendant Evesham Edmund husbandman 590512 590512 Evesham, Edmund, of Welyngton, husbandman 0
3712684 1930283 1930283 defendant Miller Robert smith 590512 590512 Miller, Robert, of Welyngton, smith 0
3715501 1931135 1931135 defendant Grynt William yeoman 590512 590512 Grynt, William, of Welyngton, yeoman 3
3742525 1939535 1939535 defendant Smyth John husbandman 590512 590512 Smyth, John, of Welyngton, husbandman 1
3742895 1939634 1939634 defendant Evesham Edmund yeoman 590512 590512 Evesham, Edmund, of Welyngton, yeoman 0
3781194 1951857 1951857 defendant Broke John husbandman 590512 590512 Broke, John, of Welyngton, husbandman 0
3790745 1954930 1954930 defendant Leynthalle John husbandman 590512 590512 Leynthalle, John, of Welyngton, husbandman 0
3794976 1956291 1956291 defendant Eyvysham Edmund husbandman 590512 590512 Eyvysham, Edmund, of Welyngton, husbandman 0
3824773 1965621 1965621 defendant Eyevisham Edmund husbandman 590512 590512 Eyevisham, Edmund, of Welyngton, husbandman 0
4439080 2181506 2181506 defendant Hichcokes John   590512 590512 Hichcokes, John, of Welyngton 0
4439082 2181507 2181507 defendant Hichecokes John   590512 590512 Hichecokes, John, of Welyngton, vicar 0
4439084 2181508 2181508 defendant Hichecokkes John   590512 590512 Hichecokkes, John, of Welyngton, vicar 0
4439981 2181789 2181789 defendant Fenne John   590512 590512 Fenne, John, of Welyngton 0
4439983 2181790 2181790 defendant Fenne John   590512 590512 Fenne, John, of Welyngton 0
4442418 2182571 2182571 defendant Bailly Richard   590512 590512 Bailly, Richard, of Welyngton 0
4444150 2183148 2183148 defendant Hichecokkes John   590512 590512 Hichecokkes, John, of Welyngton, vicar 1
4444152 2183149 2183149 defendant Hichekoces Richard under the Wrekin 590512 590512 Hichekoces, Richard, of Welyngton, under the Wrekin 0
4444734 2183333 2183333 plaintiff Comeldon John   590512 590512 Comeldon, John, of Welyngton, vicar 0
4444736 2183334 2183334 plaintiff Comelond John   590512 590512 Comelond, John, of Welyngton, vicar 0
4451533 2185451 2185451 plaintiff Holeweye William   590512 590512 Holeweye, William, of Welyngton 0
4452376 2185736 2185736 defendant Sadeler Thomas   590512 590512 Sadeler, Thomas, of Welyngton 0
4456819 2187141 2187141 defendant Roche John   590512 590512 Roche, John, of Welyngton 2
4463064 2189149 2189149 defendant Venne John   590512 590512 Venne, John, of Welyngton 0
4465066 2189734 2189734 defendant Bledleter John   590512 590512 Bledleter, John, of Welyngton 5
4469202 2191036 2191036 plaintiff Blakemore William   590512 590512 Blakemore, William, of Welyngton 0
4472980 2192223 2192223 defendant Hunte Thomas   590512 590512 Hunte, Thomas, of Welyngton 0
4474771 2192777 2192777 defendant Whyteheye John   590512 590512 Whyteheye, John, of Welyngton 3
4477115 2193502 2193502 defendant Frissell Richard   590512 590512 Frissell, Richard, of Welyngton 0
4479367 2194198 2194198 defendant Risshton John   590512 590512 Risshton, John, of Welyngton 0
4485448 2196156 2196156 defendant Roche John   590512 590512 Roche, John, of Welyngton 0
4485930 2196305 2196305 defendant Purs Richard   590512 590512 Purs, Richard, of Welyngton 2
4494625 2199011 2199011 defendant Tourner Richard   590512 590512 Tourner, Richard, of Welyngton 1
4494701 2199037 2199037 defendant Roper Thomas   590512 590512 Roper, Thomas, of Welyngton 0
4496340 2199529 2199529 plaintiff Comelond John   590512 590512 Comelond, John, of Welyngton, vicar 0
4501773 2201149 2201149 defendant Ropere Thomas   590512 590512 Ropere, Thomas, of Welyngton 0
4501774 2201149 2201149 defendant Halewell John   590512 590512 Halewell, John, of Welyngton 1
4507839 2202912 2202912 plaintiff Harper William   590512 590512 Harper, William, of Welyngton 1
4513209 2204555 2204555 defendant Fenne John   590512 590512 Fenne, John, of Welyngton 4
4513906 2204770 2204770 defendant Taillour Thomas   590512 590512 Taillour, Thomas, of Welyngton 0
4518545 2206173 2206173 defendant Ropere Thomas   590512 590512 Ropere, Thomas, of Welyngton 0
4519928 2206575 2206575 defendant Roper Thomas   590512 590512 Roper, Thomas, of Welyngton 0
4520025 2206592 2206592 defendant Newecherch John   590512 590512 Newecherch, John, of Welyngton 0
4521230 2206986 2206986 plaintiff Fyge John chaplain 590512 590512 Fyge, John, of Welyngton, chaplain 0
4527248 2208801 2208801 defendant Acton William   590512 590512 Acton, William, of Welyngton 0
4532542 2210444 2210444 defendant Adamyson Richard   590512 590512 Adamyson, Richard, of Welyngton 0
4534121 2210939 2210939 defendant Fyge John chaplain 590512 590512 Fyge, John, of Welyngton, chaplain 0
4535166 2211276 2211276 defendant Baker John   590512 590512 Baker, John, of Welyngton 0
4537165 2211895 2211895 defendant Helewill John   590512 590512 Helewill, John, of Welyngton 0
4539006 2212468 2212468 plaintiff Upton Henry   590512 590512 Upton, Henry, of Welyngton, parson 0
4540237 2212847 2212847 defendant Roche John   590512 590512 Roche, John, of Welyngton 0
4541299 2213176 2213176 defendant Fester John   590512 590512 Fester, John, of Welyngton 1
4543699 2213923 2213923 defendant Fenne John   590512 590512 Fenne, John, of Welyngton 0
4549011 2215623 2215623 defendant Baker John   590512 590512 Baker, John, of Welyngton 5
4555958 2217802 2217802 defendant atte Yete Maud   590512 590512 atte Yete, Maud, of Welyngton 0
4558308 2218540 2218540 defendant Ropere Thomas   590512 590512 Ropere, Thomas, of Welyngton 1
4559651 2218974 2218974 defendant Bocwell John   590512 590512 Bocwell, John, of Welyngton 0
4561347 2219495 2219495 defendant Brokton Roger   590512 590512 (Brokton, Roger, of Welyngton 5
4566557 2221109 2221109 defendant Ropere Thomas   590512 590512 Ropere, Thomas, of Welyngton 0
4567146 2221284 2221284 plaintiff Taillour Edward   590512 590512 Taillour, Edward, of Welyngton 0
4569671 2222098 2222098 defendant Walrond John   590512 590512 Walrond, John, of Welyngton 2
4569677 2222099 2222099 defendant Walrond John   590512 590512 Walrond, John, of Welyngton 3
4572745 2223015 2223015 defendant Sterlyng Richard butcher 590512 590512 Sterlyng, Richard, of Welyngton, butcher 2
4575032 2223713 2223713 defendant Neuton John   590512 590512 Neuton, John, of Welyngton, mason 0
4580808 2225479 2225479 defendant Carpenter John   590512 590512 Carpenter, John, of Welyngton 0
4584393 2226535 2226535 defendant touker John   590512 590512 together with touker, John, of Welyngton 2
4593863 2229356 2229356 defendant Cok John   590512 590512 Cok, John, of Welyngton 0
4594451 2229526 2229526 defendant Brabbe John   590512 590512 Brabbe, John, of Welyngton 0
4594453 2229527 2229527 defendant Brabbe John   590512 590512 Brabbe, John, of Welyngton 0
4597434 2230442 2230442 defendant Starlyng Richard   590512 590512 Starlyng, Richard, of Welyngton 1
4597782 2230558 2230558 defendant Ropere Thomas   590512 590512 Ropere, Thomas, of Welyngton 0
4597783 2230558 2230558 defendant Oke John   590512 590512 Oke, John, of Welyngton 1
4597784 2230558 2230558 defendant Tournour John   590512 590512 Tournour, John, of Welyngton 2
4598220 2230682 2230682 defendant Halwill John   590512 590512 Halwill, John, of Welyngton 2
4599856 2231184 2231184 defendant Frysell William   590512 590512 Frysell, William, of Welyngton 2
4599867 2231188 2231188 plaintiff Taillour William   590512 590512 Taillour, William, of Welyngton 0
4600803 2231475 2231475 defendant Halewille John   590512 590512 Halewille, John, of Welyngton 2
4606535 2233156 2233156 defendant Hulgreve William   590512 590512 Hulgreve, William, of Welyngton 0
4607704 2233518 2233518 defendant Blake John   590512 590512 Blake, John, of Welyngton 2
4614514 2235545 2235545 defendant Roper Thomas   590512 590512 Roper, Thomas, of Welyngton 4
4616678 2236219 2236219 defendant Webber William   590512 590512 Webber, William, of Welyngton 0
4620943 2237532 2237532 defendant Hunte Robert   590512 590512 Hunte, Robert, of Welyngton 0
4621818 2237809 2237809 defendant Hulgreve William   590512 590512 Hulgreve, William, of Welyngton 3
4642415 2243907 2243907 plaintiff Harper William   590512 590512 Harper, William, of Welyngton 0
4648632 2245653 2245653 defendant Petur William   590512 590512 Petur, William, of Welyngton 2

Next page

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