names

153 rows where place_id = 587446

✎ 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
3591439 1864950 1864950 defendant Heryng John husbandman 587446 587446 Heryng, John, of West Rudham, husbandman 0
3595601 1866252 1866252 defendant Clerk John thatcher 587446 587446 Clerk, John, of West Rudham, thatcher 2
3597284 1866771 1866771 defendant at Lye Robert laborer 587446 587446 at Lye, Robert, of West Rudham, laborer 0
3606803 1869801 1869801 defendant Sepens Simon husbandman 587446 587446 Sepens, Simon, of West Rudham, husbandman 2
3618462 1873400 1873400 plaintiff Hamond Robert   587446 587446 Hamond, Robert, of West Rudham 0
3618463 1873400 1873400 defendant Sepus Simon husbandman 587446 587446 Sepus, Simon, of West Rudham, husbandman 0
3622107 1874450 1874450 defendant Sevopens Simon husbandman 587446 587446 Sevopens, Simon, of West Rudham, husbandman 0
3625076 1875378 1875378 defendant Sepens Simon husbandman 587446 587446 Sepens, Simon, of West Rudham, husbandman 0
3666058 1915323 1915323 defendant Wyram Henry husbandman 587446 587446 Wyram, Henry, of West Rudham, husbandman 2
3675111 1918245 1918245 defendant Goodale Edmund husbandman 587446 587446 Goodale, Edmund, of West Rudham, husbandman 2
3685788 1921711 1921711 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3689568 1922894 1922894 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3689593 1922903 1922903 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 1
3689596 1922904 1922904 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 1
3689598 1922905 1922905 defendant Russell Henry, junior gent 587446 587446 Russell, Henry, junior, of West Rudham, gent 0
3689600 1922906 1922906 defendant Russell Henry gent 587446 587446 Russell, Henry, of West Rudham, gent 0
3692392 1923796 1923796 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3693763 1924245 1924245 defendant Jynne John husbandman 587446 587446 Jynne, John, of West Rudham, husbandman 0
3697906 1925567 1925567 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3698417 1925725 1925725 defendant Carleton Thomas   587446 587446 Carleton, Thomas, of West Rudham, shepherd 2
3708241 1928873 1928873 defendant Seevenpens Nicholas husbandman 587446 587446 Seevenpens, Nicholas, of West Rudham, husbandman 0
3708242 1928873 1928873 defendant Holand Thomas husbandman 587446 587446 Holand, Thomas, of West Rudham, husbandman 1
3708243 1928873 1928873 defendant Polle John husbandman 587446 587446 Polle, John, of West Rudham, husbandman 2
3708244 1928873 1928873 defendant Bronyngsthorp Richard husbandman 587446 587446 Bronyngsthorp, Richard, of West Rudham, husbandman 3
3708245 1928873 1928873 defendant Flode John husbandman 587446 587446 Flode, John, of West Rudham, husbandman 4
3710023 1929444 1929444 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3713116 1930418 1930418 defendant Russell Henry   587446 587446 Russell, Henry, of West Rudham, execttior of 0
3713117 1930418 1930418 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 1
3720014 1932531 1932531 defendant Halydaye Thomas tailor 587446 587446 Halydaye, Thomas, of West Rudham, tailor 1
3731880 1936202 1936202 defendant Warne Robert husbandman 587446 587446 Warne, Robert, of West Rudham, husbandman 2
3734391 1936997 1936997 defendant Hunt John husbandman 587446 587446 Hunt, John, of West Rudham, husbandman 0
3737867 1938062 1938062 defendant Awsten Thomas yeoman 587446 587446 Awsten, Thomas, of West Rudham, yeoman 1
3740511 1938891 1938891 defendant Eyne John husbandman 587446 587446 Eyne, John, of West Rudham, husbandman 0
3755815 1943772 1943772 defendant Holand Thomas husbandman 587446 587446 Holand, Thomas, of West Rudham, husbandman 0
3773807 1949521 1949521 defendant Holand Thomas husbandman 587446 587446 Holand, Thomas, of West Rudham, husbandman 0
3775252 1949995 1949995 defendant Kyng William husbandman 587446 587446 Kyng, William, of West Rudham, husbandman 1
3790114 1954727 1954727 defendant Johnson William carpenter 587446 587446 Johnson, William, of West Rudham, carpenter 0
3790115 1954727 1954727 defendant Lawrance William carpenter 587446 587446 Lawrance, William, of West Rudham, carpenter 1
3841317 1970865 1970865 defendant Williamson Robert   587446 587446 Williamson, Robert, of West Rudham, shepherd 0
3847157 1972664 1972664 defendant Russell Thomas gent 587446 587446 Russell, Thomas, of West Rudham, gent 0
3912555 1994530 1994530 defendant Crosby John husbandman 587446 587446 Crosby, John, of West Rudham, husbandman 1
3914434 1995172 1995172 defendant Burneham William laborer 587446 587446 Burneham, William, of West Rudham, laborer 0
3944775 2005271 2005271 defendant Holland William   587446 587446 Holland, William, of West Rudham, shepherd 2
3966316 2012845 2012845 defendant Busshoppe William husbandman 587446 587446 Busshoppe, William, of West Rudham, husbandman 0
3972164 2014826 2014826 defendant Busshoppe William husbandman 587446 587446 Busshoppe, William, of West Rudham, husbandman 0
4013733 2029643 2029643 plaintiff Russell Henry gent 587446 587446 Russell, Henry, of West Rudham, gent 0
4017317 2030900 2030900 defendant Clerke Robert husbandman 587446 587446 Clerke, Robert, of West Rudham, husbandman 0
4017319 2030901 2030901 defendant Clerke Robert husbandman 587446 587446 Clerke, Robert, of West Rudham, husbandman 0
4037508 2038078 2038078 defendant Clarke Edward husbandman 587446 587446 Clarke, Edward, of West Rudham, husbandman 1
4037513 2038079 2038079 defendant Clarke Edward husbandman 587446 587446 Clarke, Edward, of West Rudham, husbandman 1
4133494 2072308 2072308 defendant Sepence Robert yeoman 587446 587446 Sepence, Robert, of West Rudham, yeoman 0
4133578 2072342 2072342 defendant Sepens Robert yeoman 587446 587446 Sepens, Robert, of West Rudham, yeoman 0
4136361 2073349 2073349 defendant Sepens Robert yeoman 587446 587446 Sepens, Robert, of West Rudham, yeoman 0
4136476 2073387 2073387 defendant Sepens Robert yeoman 587446 587446 Sepens, Robert, of West Rudham, yeoman 0
4140306 2074777 2074777 defendant Sepens Robert yeoman 587446 587446 Sepens, Robert, of West Rudham, yeoman 0
4150951 2078462 2078462 defendant Seppyns Robert yeoman 587446 587446 Seppyns, Robert, of West Rudham, yeoman 0
4150952 2078462 2078462 defendant Seppyns John singleman 587446 587446 Seppyns, John, of West Rudham, yeoman, singleman 1
4175794 2087009 2087009 defendant Seepence Robert yeoman 587446 587446 Seepence, Robert, of West Rudham, yeoman 0
4175795 2087009 2087009 defendant Seepence John singleman 587446 587446 Seepence, John, of West Rudham, yeoman, singleman 1
4181448 2088990 2088990 defendant Sepence Robert yeoman 587446 587446 Sepence, Robert, of West Rudham, yeoman 0
4256915 2115285 2115285 defendant Seppence Richard yeoman 587446 587446 Seppence, Richard, of West Rudham, yeoman 0
4256916 2115285 2115285 defendant Seppence John singleman 587446 587446 Seppence, John, of West Rudham, yeoman, singleman 1
4276005 2121556 2121556 defendant Hempton John, senior yeoman 587446 587446 Hempton, John, senior, of West Rudham, yeoman 0
4276006 2121556 2121556 defendant Hempton Edward yeoman 587446 587446 Hempton, Edward, of West Rudham, yeoman 1
4366903 2153214 2153214 defendant Thompson John carpenter 587446 587446 Thompson, John, of West Rudham, carpenter 0
4366904 2153214 2153214 defendant Nicholls John blacksmith 587446 587446 Nicholls, John, of West Rudham, blacksmith 1
4376634 2156711 2156711 defendant Goodwyn Thomas husbandman 587446 587446 Goodwyn, Thomas, of West Rudham, husbandman 0
4404827 2166181 2166181 defendant Kynge Henry yeoman 587446 587446 Kynge, Henry, of West Rudham, yeoman 2
4405860 2166521 2166521 defendant Danyell James husbandman 587446 587446 Danyell, James, of West Rudham, husbandman 0
4431758 2174706 2174706 defendant Kempe Thomas   587446 587446 Kempe, Thomas, of West Rudham 0
4431764 2174707 2174707 defendant Kempe Thomas   587446 587446 Kempe, Thomas, of West Rudham 0
4436498 2176153 2176153 defendant Kempe Thomas   587446 587446 Kempe, Thomas, of West Rudham 0
4437095 2176344 2176344 defendant Kempe Thomas Thomas   587446 587446 Kempe, Thomas Thomas, of West Rudham 0
4440762 2182027 2182027 defendant Westlond Thomas   587446 587446 Westlond, Thomas, of West Rudham 2
4483959 2195676 2195676 defendant Shepherde James   587446 587446 Shepherde, James, of West Rudham 0
4483963 2195677 2195677 defendant Shepherde James   587446 587446 with Shepherde, James, of West Rudham 1
4525992 2208431 2208431 defendant Brond William   587446 587446 Brond, William, of West Rudham 4
4555876 2217778 2217778 defendant Kempe Walter   587446 587446 Kempe, Walter, of West Rudham 2
4640396 2243307 2243307 defendant Wryghte Wilaim   587446 587446 Wryghte, Wilaim, of West Rudham 1
4649825 2245972 2245972 defendant Westerne John   587446 587446 Westerne, John, of West Rudham 3
4653251 2246956 2246956 plaintiff Bacheler John   587446 587446 Bacheler, John, of West Rudham 1
4663165 2249944 2249944 defendant Westerne John butcher 587446 587446 Westerne, John, of West Rudham, butcher 6
4687634 2261715 2261715 defendant Westerne John butcher 587446 587446 Westerne, John, of West Rudham, butcher 3
4709207 2268247 2268247 defendant Parker John   587446 587446 Parker, John, of West Rudham, shepherd 0
4724728 2273031 2273031 defendant Muriell John yeoman 587446 587446 Muriell, John, of West Rudham, yeoman 1
4727999 2274003 2274003 defendant Wylles John yeoman 587446 587446 Wylles, John, of West Rudham, yeoman 1
4820530 2302490 2302490 defendant Barkere Thomas yeoman 587446 587446 Barkere, Thomas, of West Rudham, yeoman 0
4887196 2322838 2322838 defendant Bacheler John gent 587446 587446 Bacheler, John, of West Rudham, gent 0
4895716 2325336 2325336 defendant Bacheler John gent 587446 587446 Bacheler, John, of West Rudham, gent 0
4902547 2327415 2327415 defendant Bacheler John gent 587446 587446 Bacheler, John, of West Rudham, gent 0
4952653 2342751 2342751 defendant Man William husbandman 587446 587446 Man, William, of West Rudham, husbandman 0
4952654 2342751 2342751 defendant Mariet Nicholas   587446 587446 Mariet, Nicholas, of West Rudham, servant 1
4952655 2342751 2342751 defendant Hempton Simon husbandman 587446 587446 Hempton, Simon, of West Rudham, husbandman 2
4952656 2342751 2342751 defendant Hempton John   587446 587446 Hempton, John, of West Rudham, servant 3
5171587 2407410 2407410 plaintiff Rustell Henry gent 587446 587446 Rustell, Henry, of West Rudham, gent 1
5190105 2412851 2412851 plaintiff Rustel Henry gent 587446 587446 Rustel, Henry, of West Rudham, gent 1
5190109 2412852 2412852 plaintiff Rustel Henry gent 587446 587446 Rustel, Henry, of West Rudham, gent 1
5195306 2414375 2414375 plaintiff Russell Henry   587446 587446 Russell, Henry, of West Rudham 0
5206772 2417718 2417718 plaintiff Rustel Henry gent 587446 587446 Rustel, Henry, of West Rudham, gent 1
5209214 2418427 2418427 plaintiff Russell Henry   587446 587446 Russell, Henry, of West Rudham 0

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