names

59 rows where place_id = 587553

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591722 1865029 1865029 defendant Heylot John, senior husbandman 587553 587553 Heylot, John, senior, of Toftrys, husbandman 1
3593403 1865570 1865570 defendant Clyfton Thomas yeoman 587553 587553 Clyfton, Thomas, of Toftrys, yeoman 1
3673577 1917764 1917764 defendant Clyfton Thomas husbandman 587553 587553 (Clyfton, Thomas, of Toftrys, husbandman 2
3673578 1917764 1917764 defendant Browen John husbandman 587553 587553 Browen, John, of Toftrys, husbandman 3
3748548 1941479 1941479 defendant Heylott Thomas husbandman 587553 587553 Heylott, Thomas, of Toftrys, husbandman 0
3947365 2006151 2006151 plaintiff Clyfton Thomas gent 587553 587553 Clyfton, Thomas, of Toftrys, gent 0
4576665 2224211 2224211 defendant Bysshop Thomas   587553 587553 Bysshop, Thomas, of Toftrys 2
4741254 2277939 2277939 defendant Skynnere Alexander chaplain 587553 587553 Skynnere, Alexander, of Toftrys, chaplain 4
4908723 2329278 2329278 defendant Colyn Alexander chaplain 587553 587553 Colyn, Alexander, of Toftrys, chaplain 0
4908728 2329279 2329279 defendant Colyn Alexander chaplain 587553 587553 Colyn, Alexander, of Toftrys, chaplain 0
4970808 2348212 2348212 defendant Mowe John yeoman 587553 587553 Mowe, John, of Toftrys, yeoman 0
5129425 2395092 2395092 defendant Heylott John husbandman 587553 587553 Heylott, John, of Toftrys, husbandman 2
5148713 2400746 2400746 defendant Heylott John husbandman 587553 587553 Heylott, John, of Toftrys, husbandman 2
5167921 2406328 2406328 defendant Heylott John husbandman 587553 587553 Heylott, John, of Toftrys, husbandman 2
5183624 2410944 2410944 defendant Heylott John husbandman 587553 587553 Heylott, John, of Toftrys, husbandman 2
5233035 2425242 2425242 defendant Heylotte John husbandman 587553 587553 Heylotte, John, of Toftrys, husbandman 1
5280047 2439238 2439238 defendant Broun William husbandman 587553 587553 Broun, William, of Toftrys, husbandman 0
5319606 2450958 2450958 defendant Herd Thomas husbandman 587553 587553 Herd, Thomas, of Toftrys, husbandman 0
5319607 2450958 2450958 defendant Heylot John husbandman 587553 587553 Heylot, John, of Toftrys, husbandman 1
5319882 2451032 2451032 defendant Broun William husbandman 587553 587553 Broun, William, of Toftrys, husbandman 3
5320927 2451347 2451347 defendant Markham John yeoman 587553 587553 Markham, John, of Toftrys, yeoman 0
5320928 2451347 2451347 defendant Heylot John yeoman 587553 587553 Heylot, John, of Toftrys, yeoman 1
5326385 2452976 2452976 defendant Heylot John husbandman 587553 587553 Heylot, John, of Toftrys, husbandman 2
5327275 2453228 2453228 defendant Clyfton John, junior yeoman 587553 587553 Clyfton, John, junior, of Toftrys, yeoman 4
5337772 2456374 2456374 defendant Cliston or Clifton John yeoman 587553 587553 Cliston or Clifton, John, of Toftrys, yeoman 0
5354932 2461615 2461615 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 3
5364815 2464660 2464660 defendant Goddyng William   587553 587553 Goddyng, William, of Toftrys 0
5401944 2475614 2475614 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 12
5414067 2479141 2479141 defendant Clyfton John gent 587553 587553 Clyfton, John, of Toftrys, gent 1
5414859 2479374 2479374 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 12
5429678 2483814 2483814 defendant Clyfton John gent 587553 587553 Clyfton, John, of Toftrys, gent 1
5429682 2483815 2483815 defendant Clyfton John gent 587553 587553 Clyfton, John, of Toftrys, gent 1
5429686 2483816 2483816 defendant Clyfton John gent 587553 587553 Clyfton, John, of Toftrys, gent 1
5474947 2497489 2497489 defendant Curteys John husbandman 587553 587553 Curteys, John, of Toftrys, husbandman 2
5481034 2499277 2499277 defendant Heylot John husbandman 587553 587553 Heylot, John, of Toftrys, husbandman 4
5481337 2499359 2499359 defendant Clyfton Agnes widow 587553 587553 Clyfton, Agnes, of Toftrys, widow 3
5493441 2502953 2502953 defendant Barsham Thomas husbandman 587553 587553 Barsham, Thomas, of Toftrys, husbandman 2
5493442 2502953 2502953 defendant Danny John husbandman 587553 587553 Danny, John, of Toftrys, husbandman 3
5493443 2502953 2502953 defendant Tytyng Henry husbandman 587553 587553 Tytyng, Henry, of Toftrys, husbandman 4
5493444 2502953 2502953 defendant Mannyng Robert husbandman 587553 587553 Mannyng, Robert, of Toftrys, husbandman 5
5493445 2502953 2502953 defendant Deynes Richard husbandman 587553 587553 Deynes, Richard, of Toftrys, husbandman 6
5493449 2502954 2502954 defendant Heylot John husbandman 587553 587553 Heylot, John, of Toftrys, husbandman 2
5496389 2503825 2503825 defendant Jelle John weaver 587553 587553 Jelle, John, of Toftrys, weaver 0
5506055 2506817 2506817 defendant Clyfton John yeoman 587553 587553 Clyfton, John, of Toftrys, yeoman 0
5506058 2506818 2506818 defendant Clyfton John yeoman 587553 587553 Clyfton, John, of Toftrys, yeoman 0
5510648 2508167 2508167 defendant Clyfton Nicholas husbandman 587553 587553 Clyfton, Nicholas, of Toftrys, husbandman 0
5510649 2508167 2508167 defendant Mower William   587553 587553 Mower, William, of Toftrys, shepherd 1
5521528 2511550 2511550 defendant Otley William clerk 587553 587553 Otley, William, of Toftrys, clerk 0
5521529 2511550 2511550 defendant Heylot Joan spinster 587553 587553 Heylot, Joan, of Toftrys, spinster 1
5525520 2512574 2512574 defendant Mannyng Robert husbandman 587553 587553 Mannyng, Robert, of Toftrys, husbandman 3
5533024 2514871 2514871 defendant Styward John husbandman 587553 587553 Styward, John, of Toftrys, husbandman 2
5538517 2516528 2516528 defendant Clyfton Nicholas yeoman 587553 587553 Clyfton, Nicholas, of Toftrys, yeoman 0
5548329 2519544 2519544 defendant Stodvyle William gent 587553 587553 Stodvyle, William, of Toftrys, gent 2
5550684 2520227 2520227 defendant Otley William clerk 587553 587553 Otley, William, of Toftrys, clerk 0
5550686 2520228 2520228 defendant Ottley William clerk 587553 587553 Ottley, William, of Toftrys, clerk 0
5554057 2521227 2521227 defendant Levenard Thomas husbandman 587553 587553 Levenard, Thomas, of Toftrys, husbandman 1
5554058 2521227 2521227 defendant Clyfton Thomas husbandman 587553 587553 Clyfton, Thomas, of Toftrys, husbandman 2
5608553 2537575 2537575 defendant Clyfton John, senior husbandman 587553 587553 Clyfton, John, senior, of Toftrys, husbandman 0
5608556 2537575 2537575 defendant Heylott John husbandman 587553 587553 Heylott, John, of Toftrys, husbandman 3

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